Hi Stu, Kuldeep Possibly a separate task, but have you guys considered supporting the Galera replication system for Drizzle? It may even be possible to have mixed Drizzle and MariaDB in a cluster.
Async repl, even the best possible implementation, still leaves write-scaling and failover/resilience/redundancy issues. Async repl has its place, but with Galera on the scene it's clear that for many (if not most) new cases, Galera may be the best architecture, with async repl having an auxiliary role for tasks such as geographically displaced slaves (not active-active DCs), in-office reporting and such. In light of that, I'd see more sense in spending time on utilising the Galera system into Drizzle than spending new time on async repl jazz. Just my 2c. Cheers, Arjen. ----- Original Message ----- > From: "Stewart Smith" <stew...@flamingspork.com> > To: "kuldeep porwal" <2591kuld...@gmail.com> > Cc: drizzle-discuss@lists.launchpad.net > Sent: Monday, 22 April, 2013 10:28:09 AM > Subject: Re: [Drizzle-discuss] GSOC'13 MySQL and drizzle replication with > Google Protobuffers > kuldeep porwal <2591kuld...@gmail.com> writes: > > If in future if we find some DDL inconsistency or any other issue > > that > > *may* require changing transaction.proto then we should modify it > > and keep > > that under different version. As this will obviously help in > > entirely > > independent working of our module and we don't affect Drizzle slave > > or > > applier at the same time. > > We should not need to modify transaction.proto at all as it can > already > be used to express all DDL and DML changes possible to apply to > Drizzle. > > >> I wouldn't worry too much about it at this stage, we could attempt > >> the SQL > > and just error out if it doesn't apply. > > Yeah great! I introduced Checksum and DDL heuristics just as a part > > of > > proposal. We have to create basic prototype first then we will keep > > on > > improving it. > > There shouldn't be any place to add in checksum, we can > support/notsupport the MySQL binlog checksum for reading. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Australian peace of mind for your MySQL/MariaDB infrastructure. Follow us at http://openquery.com/blog/ & http://twitter.com/openquery _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : drizzle-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
