Difference between revisions of "MySQL clustering"
From AgileApps Support Wiki
imported>Aeric (Created page with "===MySQL Clustering===") |
imported>Aeric |
||
| Line 1: | Line 1: | ||
===MySQL | <noinclude>__TOC__</noinclude> | ||
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==== | |||
{| border="1" cellpadding="5" cellspacing="0" | |||
|-valign="top" | |||
|Operating System | |||
| | |||
* RedHat Enterprise Linux Server - Version 5 or Version 6 | |||
* SUSE Linux Enterprise Server - Version 11 | |||
* CentOS Linux - Release 7 | |||
|-valign="top" | |||
|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 | |||
|-valign="top" | |||
|Libraries | |||
| | |||
*MySQL Cluster client library | |||
*MySQL Cluster server library | |||
*MySQL Cluster shared library | |||
Revision as of 06:04, 5 April 2017
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 |
|
| Database |
|
| Libraries |
|