Use Case: Multi-Master MySQL for Financial Services

Introduction
Geo-distributed Multi-Master MySQL Replication for Financial Services SaaS Providers. The number one open source database in the cloud, and a leading SaaS database, MySQL enables SaaS vendors to be competitive because it provides cost-effective data security and privacy, performance, and availability.
User Profile
This Financial Services SaaS provider provides 24/7/365 application availability for their payment gateway and decryption-as-a-service, which are essential to point-of-sale (POS) solutions. More specifically, their payment and data security technologies protect point-of-sale (POS) and online transactions.
Tungsten Topology
Active/Active Tungsten Clustering – Two active multi-master MySQL clusters with 20 production nodes

Challenge

How to provide customers with continuous availability

Financial Services require two or more active data centers to provide their customers with continuous availability along with quick response times. This customer uses co-located data centers with multi-master replication between each MySQL cluster. This provides a complete, local High Availability and a remote Disaster Recovery solution for more than 350 million financial transactions each month.

Solution

The two services, payment gateway and decryption-as-a-service, are identical deployments: production, certification, and staging (UAT).

More specifically:

  • Two collocated data centers
  • Multi-master replication between each cluster in each data center
  • Full failover within the cluster and between clusters
  • Handle approx. 350M records each month

Benefits - Multi-Master MySQL for Financial Services

Geo-distributed Multi-master
Availability
Disaster Recovery
  • Maximum resiliency inside the data center as well as globally
  • Easy to deploy and manage Tungsten Clustering
  • Tungsten Connector (intelligent proxy) provides required abstraction
  • Lower cost through complete solution
  • Customer service provides peace of mind

Watch the Webinar

No Data Loss MySQL: Guaranteed Credit Card Transaction Availability

Interested in Tungsten Clustering? Get in Touch!

Please use the button below to contact our sales team, you will receive a reply within 24 hours.