Re: [sqlalchemy] Cross-shard queries

2012-03-21 Thread George V. Reilly
On Sunday, March 11, 2012 10:56:44 PM UTC-7, Michael Bayer wrote: > > > On Mar 11, 2012, at 8:03 PM, George V. Reilly wrote: > > > We ran into a nasty problem with sharding a while back. We came up with > an effective workaround, but we don't fully understand the problem. Perhaps > someone here

Re: [sqlalchemy] Cross-shard queries

2012-03-11 Thread Michael Bayer
On Mar 11, 2012, at 8:03 PM, George V. Reilly wrote: > We ran into a nasty problem with sharding a while back. We came up with an > effective workaround, but we don't fully understand the problem. Perhaps > someone here can provide more insight. > > We shard requests to our production MySQL da

[sqlalchemy] Cross-shard queries

2012-03-11 Thread George V. Reilly
We ran into a nasty problem with sharding a while back. We came up with an effective workaround, but we don't fully understand the problem. Perhaps someone here can provide more insight. We shard requests to our production MySQL databases using sqlalchemy.ext.horizontal_shard.ShardedSession. Ou