[Twisted-Python] adbapi MySQL read/write splitting
Jason J. W. Williams
jasonjwwilliams at gmail.com
Tue Aug 31 23:42:56 EDT 2010
Thank you for the info. Any idea what kind of changes they had to make
to the MySQLdb wrapper for adbapi to like it?
On Tue, Aug 31, 2010 at 9:13 PM, Alvin Delagon <adelagon at gmail.com> wrote:
> Used to wrap MySQLdb for something like except that I did it for sharding.
> It worked well on distributing load across multiple database servers. I
> think the guys from my former company updated the wrapper to use adbapi.
> - Alvin
> On Wed, Sep 1, 2010 at 10:54 AM, Jason J. W. Williams
> <jasonjwwilliams at gmail.com> wrote:
>> That's one way of handling it. Another way is to wrap the library so
>> it does the splitting automatically. The advantage to the latter is
>> not making mistakes where you accidentally use the READ connection for
>> a write. For non-async Python there are some tools like SQL Relay
>> which will do this for you, but you have to setup SQL Relay servers
>> and use the SQL Relay dbapi driver. MySQL Proxy will also do it, but
>> it's not very stable.
>> I was somewhat hoping someone had already written a wrapper for doing
>> the splitting. Which brings me to a related question...if I were to
>> write a wrapper to do the splitting, would wrapping MySQLdb be
>> sufficient? Or would wrapping adbapi be the better path?
>> On Tue, Aug 31, 2010 at 8:40 PM, Itamar Turner-Trauring
>> <itamar at itamarst.org> wrote:
>> > On Tue, 2010-08-31 at 20:36 -0600, Jason J. W. Williams wrote:
>> >> Sending writes (e.g. INSERTs and UPDATEs) to a master MySQL server and
>> >> reads (SELECTs) to a slave.
>> > So... two adbapi.ConnectionPool instances, one for the server, one for
>> > the slave?
>> > _______________________________________________
>> > Twisted-Python mailing list
>> > Twisted-Python at twistedmatrix.com
>> > http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
>> Twisted-Python mailing list
>> Twisted-Python at twistedmatrix.com
> Twisted-Python mailing list
> Twisted-Python at twistedmatrix.com
More information about the Twisted-Python