Hi Jeremy and Arjen, I think we are definitely on the same page here. If you can make these kind of statements the whole problem gets a lot easier.
One thing that I have run into (in a conversation earlier this week) is that it's important to be able to partition within tables as well. One thing that we might consider is some sort of scope to identify independent streams for replicatoin. Suppose you could say something in SQL like tables X and Z belong to scope A and table Y belongs to scope B? I don't know if you guys have read it but there's paper by Pat Helland called "Life beyond Distributed Transactions: an Apostate¹s Opinion." He talks about scopes of serializability--the idea is to divide data into independently serializable units. Has anyone else read this? It would be really cool to implement somehow and would help enormously with sharding--these two topics seem to be very closely related. Cheers, Robert On 5/8/09 4:08 PM PDT, "Jeremy Zawodny" <[email protected]> wrote: > On Thu, May 7, 2009 at 7:09 PM, Arjen Lentz <[email protected]> wrote: >> Hi Robert, >> >>> Another option is to apply the approach only on groups of >>> autocommit transactions, but that would rule out a lot of the value. >> >> Actually I think that is really valuable and perhaps an excellent approach to >> start with! >> Many apps run autocommit for most stuff, and have some transactions. So there >> the vast majority of writes can be done in parallel, which would be a >> fantastic improvement. I'm going to guess that Jeremy Zawodny will be >> cheering on for this one when he reads ;-) and he won't be the only one. > > And, better yet, in our case, I know that transactions involving table X can > run completely independently of those involving table Y. (You can pretend > that I said "database X" and "database Y" if it helps make this easier to > digest.) > > Jeremy > > -- Robert Hodges, CTO, Continuent, Inc. Email: [email protected] Mobile: +1-510-501-3728 Skype: hodgesrm _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
