Author:
erics, May 22nd, 2019
Overview The Skinny In this blog post we will discuss how the managed cross-site replication streams work in a Composite Multi-Master Tungsten Cluster for MySQL, MariaDB and Percona Server. Agenda What’s Here? Briefly explore how managed cross-site replication works in a Tungsten Composite Multi-Master Cluster Describe the reasons why the default design was chosen Explain […]
Categories: Architecture, CMM, Mastering Tungsten Clustering, MSMM, Multi Master, Multimaster, Multisite, Site, v6 Tags: cross, cross-site, HA, High Availability, monitoring, mysql, Replication
| Comments Off on Understanding Cross-Site Replication in a Tungsten Composite Multi-Master Cluster for MySQL, MariaDB and Percona Server
Author:
erics, September 25th, 2013
If you are inserting to the same table at the same time at two or more different sites, and using bi-directional or multi-master replication, then the auto-increment keys need to be offset so they do not conflict or the application needs to be be able to generate it’s own unique keys. Use the auto-increment-increment and […]
Categories: How-To's, Technology Tags: Auto, Auto-Increment, Avoid, Collision, Increment, Master, Master-Master, mysql, Offset, Replication
| No comments