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.
Please take a few seconds and answer the following poll. It will help the community get an idea of how companies are approaching HA in their critical database environments.
If you’re using other solutions or have specific issues, feel free to comment below. We’ll post a follow-up blog with the results!
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