Case Study: Multi-Primary MySQL for e-Commerce Sites

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

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.

The Solution

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.

The Benefits

Multi-master, Availability, Disaster Recovery

About Tungsten Clustering

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.

About the Author

Jean-Jérôme Schmidt
VP of Marketing

Jean-Jérôme has been an avid open source (database) marketer for most of his career. Prior to joining Continuent, he was VP of Marketing at Severalnines, a leader in automation & management of open source databases, having come from MariaDB, where he headed up marketing as well. Previous roles include Director EMEA Marketing at Pentaho, Global Sales Ops Mgr at MySQL & Commercial Director at marketing agency Connection2. And all that from his home-base in Dublin.

Add new comment