I have configured On-Prem MySQL Community edition 8.0 for my Application server using JDBC.
What are my options for MySQL High Availability?
What I could gather from an online search is to use MySQL Replication between Master and Slave. But it is not 100% reliable and the failover has to be manual by promoting Slave to Master.
Can someone please give me some pointers on how do I go about it and what are the challenges?