I have one database (mysql). What is the best "failover" strategy?
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.
This SO post might be of help to you:
精彩评论