[Twisted-Python] Silverberg CQL Driver
![](https://secure.gravatar.com/avatar/b5edb1094c1aa4e8a09ee0640a57f463.jpg?s=120&d=mm&r=g)
Is anyone using the silverberg CQL (Cassandra) library for Twisted in production? Just curious what people's experience with it is, since it appears to be the most recently updated Twisted/CQL project. -J
![](https://secure.gravatar.com/avatar/3a7e70f3ef2ad1539da42afc85c8d09d.jpg?s=120&d=mm&r=g)
Yes, we use it in production in the Rackspace Otter project: https://github.com/rackerlabs/otter <https://github.com/rackerlabs/otter> The particular file we most use it in is here: https://github.com/rackerlabs/otter/blob/master/otter/models/cass.py#L530 <https://github.com/rackerlabs/otter/blob/master/otter/models/cass.py#L530> — the connection attribute of that class is a silverberg client. I’ve not personally touched that code but I know we've been using it in production for about a year. -radix
![](https://secure.gravatar.com/avatar/3a7e70f3ef2ad1539da42afc85c8d09d.jpg?s=120&d=mm&r=g)
On Dec 3, 2014, at 2:03 PM, Jason J. W. Williams <jasonjwwilliams@gmail.com <mailto:jasonjwwilliams@gmail.com>> wrote:
Is anyone using the silverberg CQL (Cassandra) library for Twisted in production? Just curious what people's experience with it is, since it appears to be the most recently updated Twisted/CQL project.
On Dec 29, 2014, at 1:11 PM, Jason J. W. Williams <jasonjwwilliams@gmail.com> wrote:
Thanks radix. I noticed the README says Python >= 2.7 is a pre-req but the changelog for 0.1.7 says "fixed incompatibility with Python 2.6". Are y'all running it with 2.6 or 2.7?
Otter runs on Python 2.7. It looks like builds are run against 2.6 on Travis CI, but they’re in “allowed to fail” mode — but still passing 100%. -radix
![](https://secure.gravatar.com/avatar/01c6deeb9d1a1053553d353caa464581.jpg?s=120&d=mm&r=g)
We (TweetDeck@Twitter) have been using a patched version of Telephus for 3 years now. We've had problems in the past where it would cause problems with down and flaky seed hosts, so ymmv. It's available here: https://github.com/tweetdeck/Telephus On 3 December 2014 at 20:03, Jason J. W. Williams <jasonjwwilliams@gmail.com
wrote:
![](https://secure.gravatar.com/avatar/01c6deeb9d1a1053553d353caa464581.jpg?s=120&d=mm&r=g)
On 29 December 2014 at 19:11, Jason J. W. Williams < jasonjwwilliams@gmail.com> wrote:
We haven't -- when I said that, I meant "on some occasions, after 3 years of continuous use". It's a sporadic failure mode, and hasn't happened enough times for us to investigate deeply. That said, we're in our own DC, so the environment is pretty stable. If you're in AWS or similar, you might want to run some testing around failure cases (let us know what you find!) All that said, we've been very happy with it. The likelihood is that we'll be working on migrating to Manhattan[1] rather than trying out a new Cassandra library. Not quite sure which way we'll go, but one option may be to write a telephus-like wrapper around the thrift bindings. [1] https://blog.twitter.com/2014/manhattan-our-real-time-multi-tenant-distribut...
![](https://secure.gravatar.com/avatar/b5edb1094c1aa4e8a09ee0640a57f463.jpg?s=120&d=mm&r=g)
Sorry for rewaking this thread. Finally getting around to playing with silverberg, but having a lot of trouble getting it to talk to Cassandra 2.1.6 (throws "unknown opcode 44" or "unknown opcode 81" depending on whether I'm trying to use authentication or not). Was curious if y'all ran without authentication and if you thought this might be a 2.1.x compatibility issue? Thank you in advance for any advice. -J On Thu, Jan 1, 2015 at 7:51 AM, James Broadhead <jamesbroadhead@gmail.com> wrote:
![](https://secure.gravatar.com/avatar/20f06bf01a3d002acdf02cd8feacb237.jpg?s=120&d=mm&r=g)
Hi Jason, On Thu, Jul 2, 2015 at 12:39 PM, Jason J. W. Williams <jasonjwwilliams@gmail.com> wrote:
Regards, Manish [1] https://github.com/rackerlabs/otter
![](https://secure.gravatar.com/avatar/3a7e70f3ef2ad1539da42afc85c8d09d.jpg?s=120&d=mm&r=g)
Yes, we use it in production in the Rackspace Otter project: https://github.com/rackerlabs/otter <https://github.com/rackerlabs/otter> The particular file we most use it in is here: https://github.com/rackerlabs/otter/blob/master/otter/models/cass.py#L530 <https://github.com/rackerlabs/otter/blob/master/otter/models/cass.py#L530> — the connection attribute of that class is a silverberg client. I’ve not personally touched that code but I know we've been using it in production for about a year. -radix
![](https://secure.gravatar.com/avatar/3a7e70f3ef2ad1539da42afc85c8d09d.jpg?s=120&d=mm&r=g)
On Dec 3, 2014, at 2:03 PM, Jason J. W. Williams <jasonjwwilliams@gmail.com <mailto:jasonjwwilliams@gmail.com>> wrote:
Is anyone using the silverberg CQL (Cassandra) library for Twisted in production? Just curious what people's experience with it is, since it appears to be the most recently updated Twisted/CQL project.
On Dec 29, 2014, at 1:11 PM, Jason J. W. Williams <jasonjwwilliams@gmail.com> wrote:
Thanks radix. I noticed the README says Python >= 2.7 is a pre-req but the changelog for 0.1.7 says "fixed incompatibility with Python 2.6". Are y'all running it with 2.6 or 2.7?
Otter runs on Python 2.7. It looks like builds are run against 2.6 on Travis CI, but they’re in “allowed to fail” mode — but still passing 100%. -radix
![](https://secure.gravatar.com/avatar/01c6deeb9d1a1053553d353caa464581.jpg?s=120&d=mm&r=g)
We (TweetDeck@Twitter) have been using a patched version of Telephus for 3 years now. We've had problems in the past where it would cause problems with down and flaky seed hosts, so ymmv. It's available here: https://github.com/tweetdeck/Telephus On 3 December 2014 at 20:03, Jason J. W. Williams <jasonjwwilliams@gmail.com
wrote:
![](https://secure.gravatar.com/avatar/01c6deeb9d1a1053553d353caa464581.jpg?s=120&d=mm&r=g)
On 29 December 2014 at 19:11, Jason J. W. Williams < jasonjwwilliams@gmail.com> wrote:
We haven't -- when I said that, I meant "on some occasions, after 3 years of continuous use". It's a sporadic failure mode, and hasn't happened enough times for us to investigate deeply. That said, we're in our own DC, so the environment is pretty stable. If you're in AWS or similar, you might want to run some testing around failure cases (let us know what you find!) All that said, we've been very happy with it. The likelihood is that we'll be working on migrating to Manhattan[1] rather than trying out a new Cassandra library. Not quite sure which way we'll go, but one option may be to write a telephus-like wrapper around the thrift bindings. [1] https://blog.twitter.com/2014/manhattan-our-real-time-multi-tenant-distribut...
![](https://secure.gravatar.com/avatar/b5edb1094c1aa4e8a09ee0640a57f463.jpg?s=120&d=mm&r=g)
Sorry for rewaking this thread. Finally getting around to playing with silverberg, but having a lot of trouble getting it to talk to Cassandra 2.1.6 (throws "unknown opcode 44" or "unknown opcode 81" depending on whether I'm trying to use authentication or not). Was curious if y'all ran without authentication and if you thought this might be a 2.1.x compatibility issue? Thank you in advance for any advice. -J On Thu, Jan 1, 2015 at 7:51 AM, James Broadhead <jamesbroadhead@gmail.com> wrote:
![](https://secure.gravatar.com/avatar/20f06bf01a3d002acdf02cd8feacb237.jpg?s=120&d=mm&r=g)
Hi Jason, On Thu, Jul 2, 2015 at 12:39 PM, Jason J. W. Williams <jasonjwwilliams@gmail.com> wrote:
Regards, Manish [1] https://github.com/rackerlabs/otter
participants (4)
-
Christopher Armstrong
-
James Broadhead
-
Jason J. W. Williams
-
Manish Tomar