← Back to team overview

maria-discuss team mailing list archive

Re: Galera cluster as slave: Duplicate entry errors

 


----- Original Message -----
> 
> Hmm, maybe an idea by myself on the cause:
> 
> the initial sync to galera was done as followed:
> 
> - dump on the (locked) master
> - inserted the dumps on a galera node
> - started replication (change master to...) with the saved state of the
> master
> 
> I've read somewhere that galera handles the auto_increments with a
> offset for each node (by design) - so you cannot rely on it.

This should only matter if you are writing directly to the galera nodes.

It can be disabled however.
http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsrep-auto-increment-control

> That is no
> problem for the application at all. But as i use ROW based replication
> the autoincrements (created on the master) could exist on the galera
> side already, right?

Did you compare the contents of the row on master and galera?

> what would be a way to avoid it? i think i need another migration
> scenario...

It looks quite sane to me.

-- 
-- 
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.


Follow ups

References