Users 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 instance—see Create MySQL InnoDB cluster.
2. Add server or node to MySQL InnoDB—see Adding server or node to MySQL InnoDB cluster.
3. Create MySQL Router—see 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
Achieve high availability for MySQL InnoDB 23