On Mon, Mar 22, 2010 at 8:43 PM, Robert Hodges <[email protected] > wrote:
> Hi All, > > This is slightly off-topic but Jay and I are doing a talk called "Not Your > Grandpa¹s Replication-The New Wave of MySQL Replication and How It Helps > Your Applications" next month at the 2010 MySQL Conference. We are going > to > survey the field of MySQL-related replication work and how these efforts > are > solving the big problems of data replication. > > This is a topic that interests a lot of people and not just rep nerds like > me and Jay, so we though we would open a thread to talk about it on list. > Here are a couple of starter questions: > > 1.) What are the "big" problems in replication? Let's say we have things > like availability and basic read scaling basically handled. What's next on > the list? (Big data, No-SQL, replication/database impedance mismatch due > to > faster hardware, complex topologies, management, etc., all suggestions are > welcome.) > > 2.) What replication solutions are emerging to address those problems? Jay > and I work on or know most of the usual suspects like Drizzle, Tungsten, > Galera, MySQL 5.4, Rabbit MQ, etc. However, if there's something really > cool out there we'll add it to the list. > Personally I like the idea of having a message oriented middleware (like rabbitmq or gearman) transporting the changes from the master to the slaves, this removes alot of the complexity in the masters and the slaves since it is the MOM that guarantees that the transaction will be delivered to all slaves. It also makes it real easy to implement many different kinds of slaves (nosql, websockets etc :) ) since the API against the MOM is easy to use. Replacing a broken master is also easy, just take a slave, make it publish the transactions to the MOM and it is done, no config changes on the slaves etc. There is of course an overhead of having a MOM (though a small one i imagine, they are after all optimized to transport data as efficiently as possible) and I have not seen any of this in production, but in theory it works great! :) -- Marcus
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
