I have one database (mysql). What is the best "failover" strategy?

Question

Does MySQL come with a built-in automatic failover? Or, are there load-balancers out there that can "detect" whether the database is alive...and if not...shoot it to the failover database?

I know basic MySQL, but do not know the best way to design failover for one master DB.

possible duplicate of [Full complete MySQL database replication? Ideas? What do people do?](http://stackoverflow.com/questions/3798/full-complete-mysql-database-replication-ideas-what-do-people-do) — Qantas 94 Heavy, Jul 17 '14 at 08:07

score 4 · Accepted Answer · edited May 23 '17 at 11:57

4

This SO post might be of help to you:

edited May 23 '17 at 11:57

Community

1
1

answered Nov 04 '09 at 07:12

Derek

982
1
8
19

I have one database (mysql). What is the best "failover" strategy?

1 Answers1