vs.

Learn why Tungsten Clustering is a better (complete, proven) and more cost-effective (software, 24/7 support and consulting all included) MySQL High Availability (HA), Disaster Recovery (DR) and Geographically-Distributed (Geo-Scale) solution compared to DIY Solution.

For any MySQL clustering to be a complete high-availability and disaster recovery solution, it requires three core components working in sync: connectivity (proxy), management (orchestration) and replication (local/global).

Tungsten Clustering includes three highly integrated and fully tested components Tungsten Proxy, Tungsten Manager and Tungsten Replicator working together to provide both local (individual clusters) and global (multiple clusters working together) data service for continuous 24/7 MySQL operations.

Connectivity

Complete and Integrated
(Tungsten Proxy)

Orchestration

Integrated Business Rules
(Tungsten Manager)

Replication

Advanced Local and Global
(Tungsten Replicator)

“Do It Yourself” may seem attractive to be able to pick and choose technologies, but the level of effort is quite high when considering the high level of orchestration required to maintain a highly available cluster. The effort grows exponentially when adding additional sites or creating a geo-deployment. In a critical system, failure scenarios must be fully enumerated and tested to ensure continuous operations. When questions arise or incidents occur, support is generally not available for a DIY system.

Connectivity

Direct or 3rd party solution

Orchestration

Depends on level of effort and time

Replication

Pick replication choice for local clusters, use asynchronous for global replication

  Tungsten Cluster DIY Solution
Connectivity Complete and Integrated
(Tungsten Proxy)
Direct or 3rd party solution
Orchestration Integrated Business Rules
(Tungsten Manager)
Depends on level of effort and time
Replication Advanced Local and Global
(Tungsten Replicator)
Pick replication choice for local clusters, use asynchronous for global replication

Do-It-Yourself (DIY) MySQL Clustering Solution Comparison

Use Cases Supported

 
Tungsten Cluster
DIY (such as with Orchestrator & a proxy / ProxySQL)
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Supported
MySQL Multi-Primary
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Supported

Features & Benefits

 
Tungsten Cluster
DIY (such as with Orchestrator & a proxy / ProxySQL)
Continuous Operations
4.67
3.00
Zero Downtime Maintenance
Both database, operating system and hardware changes & upgrades
Needs manual reconfiguration
High Availability
Automatic failover of primary
Needs to be developed
DR with Active/Passive Cluster
Automated site level switch with one failover command
Needs to be developed
DR with Active/Active Cluster
Only requires repointing the apps
Needs to be developed
DR Failback
Single command, fast
Needs to be developed
Backup & Data Recovery
Flexible backups using existing external tools
Using existing tools

Support Services

 
Tungsten Cluster
DIY (such as with Orchestrator & a proxy / ProxySQL)
24/7 Support
5.00
0.67
24/7 Support
24/7 support with high, near 100% customer satisfaction
Each tool in use is individually supported, some only by forums
Fast Support Reponse Time
The fastest in the industry, averaging less than 3 minutes for Urgent support request.
Depends on tool
Support Team Experience
Each member has 20+ years experience on DBA and Site Reliability
Depends on tool

Intangibles

 
Tungsten Cluster
DIY (such as with Orchestrator & a proxy / ProxySQL)
MySQL Version Support
5.00
5.00
MySQL Community
Fully supported, all versions up to 8.0
Chose MySQL version, though it may not be possible to mix versions
MySQL Enterprise
Fully supported, all versions up to 8.0
Chose MySQL version, though it may not be possible to mix versions
MariaDB
Fully supported, all versions up to 10.5
Chose MySQL version, though it may not be possible to mix versions
Percona Server
Fully supported
Chose MySQL version, though it may not be possible to mix versions

Tungsten Clustering

Tungsten Clustering comes at an equal or often lower total cost of ownership (TCO) versus alternative solutions and provides access to the best MySQL database engineers at a moments notice via 24/7 human-only enterprise support.

The Tungsten Clustering family of products is the only complete, fully-integrated, fully-tested MySQL HA, DR and geo-clustering solution running on-premises and in the cloud combined with industry-best and fastest, 24/7 support for business-critical MySQL, MariaDB, & Percona Server applications.

Continuous Operations
High Availability
Disaster Recovery
Global Scaling

Watch the Comparison Presentation

MySQL HA/DR/Geo-Scale - High Noon #6: Do-it-Yourself (DIY) MySQL Clustering

Experience Our Industry-Best Continuent MySQL Support

Highly qualified 24/7 MySQL support
Our support engineers have 15 or more years of MySQL DBA and Site Reliability experience
24/7 support comes with 1-hour SLA, with response times for urgent requests averaging less than 3 minutes
MySQL uptime measured in months or years

These Companies Trust Our Solutions

Why Continuent?

Our customers are leading SaaS, e-commerce, financial services, gaming and telco companies who rely on MySQL and Continuent to cost-effectively safeguard billions of dollars annual revenue.