High availability (HA) is always a hot topic. The reality is that if your data is not available, your customers cannot do business with you. In fact, estimates show the average cost of downtime is about $5K per minute. With an average outage taking 40 minutes to correct, you could be looking at a potential cost of $200K if your MySQL instance goes down. Whether your database is on premise, or in public or private clouds, it is critical that your database deployment does not have a potentially devastating single point of failure.
The results from Percona’s high availability poll responses are in:
What high availability (HA) solutions do you use with MySQL in production?
- MySQL Replication (56%, 473 Votes)
- Percona XtraDB Cluster (or other Galera-based solution) (28%, 233 Votes)
- Storage Based High Availability (8%, 70 Votes)
- MySQL Cluster (NDB) (8%, 68 Votes)
Total Voters: 704
With over 700 unique participants and 844 different selections, MySQL replication was the clear frontrunner when it comes to high availability solutions.
Percona has HA solutions available, come find out more at our website.
If you’re using other solutions or have specific issues, feel free to comment below.
Check out the latest Percona one-click poll on database security here.