Use Case: MySQL HA and Simple Disaster Recovery

Introduction
MySQL High Availability, Zero Downtime Maintenance and Disaster Recovery for SaaS: How to Easily Deploy MySQL Clusters in AWS and Recover from Multi-Zone AWS Outages.
User Profile
This is a multi-year (since 2012) Continent customer who is a large Florida-based SaaS provider dealing with sensitive (HIPAA Compliant) medical data, which offers electronic health records, practice management, revenue cycle management and data analytics for thousands of doctors.
Tungsten Topology
Composite Active/Passive Tungsten Clustering Topology

Challenge

Lack of high availability in AWS

Lack of high availability in AWS. The challenge this customer was facing came from using AWS, which allowed them to rapidly provision database and application servers - but the instances, underlying storage, and management interface were not highly available.

Solution

The solution uses a Pod Architecture with multiple 3-node Active Clusters (for HA) and 3-node Passive Clusters (for DR). The Pod Architecture provides practically infinite scalability for the SaaS providers as they can just keep adding new Pods when and as their customer base grows. Each Pod includes a 3-node Tungsten cluster deployed in multi-AZ AWS, and a 3-node DR cluster deployed in another AWS Region with all sensitive traffic encrypted in flight (this covers application traffic as well).

Benefits - MySQL HA & Simple Disaster Recovery

Continuous MySQL Operations
High Availability
Scalability
Better Data Protection

The benefits this SaaS provider customer is able to reap from our solution include continuous operations, high availability, scalability and better data protection.

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.