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.
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!