Tag Info

New answers tagged


With a single write master <> master setup, I don't need to worry about setting the auto_increment_offset correct? Yes, you are right. I have setup Master-Master setups for years with one Write Master. I never touched the auto_increment options. Never had an incident. Does MySQL replicate all databases by default, or do I need to explicitly ...


first of all, please have a look at this recent response about multi-master replication, where I remark how likely is this setup to create problems and some alternatives. This was probably a direct or indirect cause of your desync. Bidirectional sync is supported in pt-table-sync, but not in a replication environment, and only between 2 servers. You must ...

Top 50 recent answers are included