Reference Guide

Achieve high availability for MySQL InnoDB

The following steps explain how to achieve high availability for MySQL InnoDB:

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 Creating 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

To install MySQL InnoDB, see dev.mysql.com.

To set up the environment as per the high availability setup, see dev.mysql.com.

Check MySQL InnoDB server instances

Before you add MySQL InnoDB to the cluster setup, verify that MySQL InnoDB is created as per the cluster requirements.

You must login as root user to run the commands and restart the system each time you run a set of commands.

Run the following commands to verify that the MySQL InnoDB server instance meets the congured cluster requirements:

NOTE

: The IP Address is dierent for each system that is used at your work place and the following commands are used only as

an example.

• To check that the MySQL InnoDB is created as per the requirements, run the following commands at the command prompt:

•

mysql-js> dba.checkInstanceConfiguration('root@IP Address1')

•

mysql-js> dba.checkInstanceConfiguration('root@IP Address2')

•

mysql-js> dba.checkInstanceConfiguration('root@IP Address3')

Achieve high availability for MySQL InnoDB 21