← Back to team overview

drizzle-discuss team mailing list archive

Re: Updating replication docs



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:
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>"?


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.  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.html and 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

Follow ups