For this next blog in our Continuent MySQL Case Study series, we’re diving into a sub-series on the topic of ‘multi-master MySQL’.
We’ll cover three (3) multi-master MySQL case studies as part of this sub-series focusing first on e-commerce to start with, and then following up with use cases from financial services and telecommunications.
Multi-master replication for MySQL typically means that a user can write to any master node knowing that the write will be eventually consistent for all nodes in the cluster; unlike regular MySQL replication, where writes have to be applied to the sole master to ensure that it will be synched to all the slaves.
The First Multi-Primary Customer
The first Continuent multi-primary customer is a leading fashion e-commerce company with sites servicing customers across the globe.
More specifically, it has four multi-brand online stores and several online flagship stores serving millions of customers in 180 countries around the world.
The challenge this customer faced had to do with managing a single sign-on e-commerce portal for their millions of worldwide customers as well as their need to reduce contention in a single location by balancing traffic to each cluster based on the source website.
Multi-master Tungsten Clustering topology (active/active) – Two or more master MySQL clusters
In the Tungsten multi-master cluster topology (active/active), there is one writeable master node per cluster, across two or more clusters. All writes are directed to an available (usually local) master by the Tungsten Connectors / Proxies serving the client requests.
The Connectors/Proxies are able to use any other site in the event of a local outage; both sites are write-able at all times, and each cluster replicates from all other member clusters.
Our customer’s current Tungsten Clustering deployment consists of two (2) 3-node MySQL clusters configured in a multi-master topology.
The Tungsten MySQL clusters are situated in two (2) separate data centers, geographically located in different sites, providing remote redundancy and disaster recovery.
They also utilize Tungsten Replicator to replicate out in real-time from each cluster for management reporting.
Multi-master, Availability, Disaster Recovery
Tungsten Clustering allows enterprises running business-critical MySQL database applications to cost-effectively achieve continuous operations with commercial-grade high availability (HA), geographically redundant disaster recovery (DR) and global scaling.
To find out more, visit our Tungsten Clustering product page.