maria-discuss team mailing list archive
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
> 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.
> 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
It looks quite sane to me.
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.