Reference Guide

Achieve high availability for MySQL InnoDB
About this task
The following steps explain how to achieve high availability for MySQL InnoDB:
Steps
1. Check MySQL InnoDB server instancesee Create MySQL InnoDB cluster.
2. Add server or node to MySQL InnoDBsee Adding server or node to MySQL InnoDB cluster.
3. Configure MySQL Routersee Configure MySQL Router.
High availability with MySQL InnoDB
The MySQL InnoDB cluster provides a complete high availability solution for MySQL. The client application is connected to the
primary node by using the MySQL router. If the primary node fails, a secondary node is automatically promoted to the role of
primary node, and the MySQL router routes the requests to the new primary node.
The components of the MySQL InnoDB cluster are:
MySQL server
MySQL router
Install MySQL InnoDB database
About this task
To install MySQL InnoDB database, do the following:
Steps
1. Double-click the MySQL installer.
The MySQL Installer window is displayed.
2. On the License Agreement screen, read the license agreement, and click Next.
3. On the Choosing a Setup Type screen, click the Custom radio button, and click Next.
5
24 Achieve high availability for MySQL InnoDB