Could you post your slave config files for each server? On Sat, Feb 25, 2012 at 2:02 PM, Daniel Nichter <dan...@percona.com> wrote:
> Dave, > > It seems master-master does not work in Drizzle. If I create a db on > master1, it replicates to master2, and master2 writes the event to its repl > log, which master1 then tries to reapply, causing the error on master1: > > (SQLSTATE 00000) Can't create schema 'test'; schema exists > Failure while executing: > COMMIT > CREATE SCHEMA `test` COLLATE utf8_general_ci > UPDATE `sys_replication`.`applier_state` SET `last_applied_commit_id` = > 16, `originating_server_uuid` = '30433CCA-4655-4C37-9567-61749AA8A9FD' , > `originating_commit_id` = 69 WHERE `master_id` = 1 > > UUID 304... is master1. I'm not familiar with the slave plugin code, but > perhaps the SELECT statement in QueueConsumer::getMessage needs "WHERE > originating_server_uuid != <my uuid>"? > > -Daniel > > Le 5 févr. 2012 à 13:12, David Shrewsbury a écrit : > > Hi Daniel, > > On Feb 5, 2012, at 1:19 PM, Daniel Nichter wrote: > > Just FYI to everyone: I'm in the process of updating the replication > documentation which is currently wrong due to > https://code.launchpad.net/~fallenpegasus/drizzle/multimaster/+merge/67103<https://code.launchpad.net/%7Efallenpegasus/drizzle/multimaster/+merge/67103>. > This means that the examples in the docu don't work, nor do the example > given by > http://dshrewsbury.blogspot.com/2011/03/simple-drizzle-replication-example.htmland > http://www.learningdrizzle.com/?p=97 because the slave plugin is > multi-master which requires [masterN] headers in slave.cfg. I was puzzled > why slave wasn't working this morning, stopping Drizzle from starting with > this cryptic error message: "what(): unknown option master-host", > extremely cryptic because "master-host" is correct. I had to look at the > config filed used by slave tests to see that "[master1]" is now required. > > Also, talking with Monty this morning I realized more clearly the > relationship between http://docs.drizzle.org/plugins/slave/index.html and > http://docs.drizzle.org/replication/drizzle.html which, as two separate > entities, is probably confusing to users (it's been confusing to me). > Therefore, I'm going to rewrite docs/replication/*. > > > Thanks for taking on this task. My development skills far outweigh > my documentation/communication skills, so your work here is much > appreciated. And my time available to work on such stuff has seemed > to disappear into the ether... > > Feel free to direct any questions you may have directly to me and > I'll try my best to answer them. > > -Dave > > > > _______________________________________________ > 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 > >
_______________________________________________ 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
