Dynamic MySQL
Performance Scaling

Performance Scaling with Dynamic Active/Active Cluster

Dynamic Active/Active (DAA) gives the simplicity of deployment and data integrity of Composite Active/Passive (CAP), with the automated continuous operations of Composite Active/Active (CAA).

DAA allows for simplicity of application adoption, lowering the risk for write conflicts. DAA Connectors automatically reroute writes to another available cluster if the current Active cluster fails, while CAP requires human intervention to move the Active role to another cluster.

A DAA Topology Contains

Minimum Configuration

2 clusters with 3-node (or 2-node + witness) per cluster.

Dynamic Design

Combines Active/Passive and Active/Active capabilities.

Single Writeable Primary

Connectors route writes to a single primary, with automated failover to another cluster.

Cross-Site Replication

Managed replication flows in all directions.

Flexibility

Easily switch between Active/Passive and Active/Active modes.

The benefit of a Composite Dynamic Active/Active cluster is being able to direct writes to only one cluster, which avoids all the inherent risks of a true Active/Active deployment, such as conflicts when the same row is altered in both clusters. This is especially useful for deployments that do not have the ability to avoid potential conflicts programmatically.

Use Cases

3-Node Cluster

Continuous Operations for a Payment Gateway
Need

A payment gateway processes credit card transactions for online retailers. The gateway must ensure 24/7 availability and rapid failover to prevent disruptions in payment processing. At the same time, the company wants to simplify database management by centralizing write operations.

Solution

The company deploys the Tungsten DAA (3-Node), with two clusters in different regions. The Tungsten Connector routes all write operations to a single preferred primary node, while local replicas handle read operations. If the primary cluster becomes unavailable, the Connector automatically redirects writes to the secondary cluster, ensuring uninterrupted service. This topology combines the simplicity of centralized writes with the automation of cross-site failover, allowing the payment gateway to maintain continuous operations without manual intervention.

2 Node + Witness Cluster

Cost-Effective and Lightweight Active/Active for E-Commerce
Need

An e-commerce platform needs an Active/Active solution to maintain uptime and simplify operations but must also manage costs effectively.

Solution

The e-commerce platform deploys Tungsten DAA (2-Node +) to centralize writes and enable local reads. The lightweight witness ensures failover quorum, delivering a cost-effective solution for high availability and seamless shopping experiences.

Get Started with Tungsten Cluster

Tungsten Cluster solutions are built to support organizations with different needs—from small-scale operations to large, multi-region deployments.

Request a demo of Tungsten Cluster today!