MySQL clustering

AgileApps is now certified with MySQL v5.7 enterprise edition and supports clustering for on-premises installation. MySQL cluster is designed to avoid single point of failure. The cluster is set up to avoid any node, system, or hardware failure.

MySQL Cluster implementation

To implement MySQL cluster, you have to install three types of nodes.

• Management node: This node is used to manage the other nodes of the server.
• Data node: This node facilitates the process of data synchronization and data replication between the nodes.
• SQL node: This node acts as an interface server to connect the applications to the database cluster.

Each node should be installed in its own server.

Pre-requisites

Operating System	RedHat Enterprise Linux Server - Version 5 or Version 6 SUSE Linux Enterprise Server - Version 11 CentOS Linux - Release 7
Database	Management node: mgmt node1 = 10.60.30.75 Data node: data node 1 = 10.60.29.119, data node 2 = 10.60.29.176 SQL node: sql node 1 = 10.60.30.44, sql node 2 = 10.60.30.75
Libraries	MySQL Cluster client library MySQL Cluster server library MySQL Cluster shared library

Setting up nodes

To set up management, data, and SQL nodes:

• Remove mariadb-libs and install perl-Data-Dumper required for MySQL Cluster server.
• Download MySQL-Cluster-gpl-7.4.13-1.el7.x86_64.rpm-bundle.tar file from MySQL website.
• Install MySQL Cluster client, server, and shared packages using rpm commands.

Configuring management node

Create a new configuration file for cluster management config.ini inside the /var/lib/mysql-cluster directory and save the configuration file after customizing the settings.