- 3,741,291 Users
- 2,248,405 Discussions
- 7,861,727 Comments
Forum Stats
Discussions
Howdy, Stranger!
Categories
- 381.2K All Categories
- 2.1K Data
- 204 Big Data Appliance
- 1.9K Data Science
- 446.6K Databases
- 220.6K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 23 Multilingual Engine
- 511 MySQL Community Space
- 462 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 448 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.6K SQL & PL/SQL
- 20.8K SQL Developer
- 291.8K Development
- 7 Developer Projects
- 117 Programming Languages
- 288.6K Development Tools
- 94 DevOps
- 3K QA/Testing
- 645.3K Java
- 18 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.7K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 12 Java Essentials
- 141 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 197 Java User Groups
- 23 JavaScript - Nashorn
- Programs
- 193 LiveLabs
- 34 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 165 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
MySQL 5.7 automatic failover steps with GTID=ON
Hello All,
I need help in setting up automatic failover for MySQL 5.7.
I know the steps for the manual failover.
But if i need to automate the failover process please let me know the steps and process.
I have 2 servers only. Master and Slave with GTID=ON.
Please let me know the details.
Best Answer
-
You should probably look at InnoDB Cluster but to get high availability you will need at least three servers. You may be able to get by with two servers with something like ProxySQL and some intelligence built into your application that senses failure of the primary server.
Answers
-
You should probably look at InnoDB Cluster but to get high availability you will need at least three servers. You may be able to get by with two servers with something like ProxySQL and some intelligence built into your application that senses failure of the primary server.
-
Thanks for the reply Dave. Not sure about what intelligence i can use that senses failure.
But if i opt for the innodb-cluster do you have any generic steps which i can follow and do it.