Not the answer you need?
Register and ask your own question!

need HA and failover

farrokhfarrokh EntrantInactive User Role Beginner
we have mysql prod database in AWS EC2 and we like to implement a full HA solution so we have no downtime and can failover, can you send me a details solution, much appreciated.

Comments

  • wagnerbianchiwagnerbianchi Remote DBA Current User Role Patron
    Is this just one MySQL instance? Normally, plans for HA and even scale-out will consider at least tow MySQL instances to act as MASTER/SLAVE when MASTER is most of time reserved for writes and SLAVE in standby or serving apps for data read and/or users for reports, no writes on SLAVEs, most of time. Is this the kind of solution you're looking for? Give us more details about that. Cheers!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.