In this tutorial I will show you how to install a MySQL cluster on a single node: obviously you will not gain any hardware redundancy with this setup but it is useful if you need to create a test installation as it was for me. You can find many tutorials about this topic but they are quite old and MySQL Cluster changed a lot in last years.
What is a MySQL cluster?
Let’s start explaining the architecture of a MySQL cluster with an image taken from dev.mysql.com:
As you may see the MySQL cluster is an aggregation of many components:
- one management server;
- many MySQL daemons that acts as “frontend”;
- many data nodes that store the real data.
This tutorial will guide you in the creation of a cluster with:
- one management node;
- two MySQL daemons;
- two data nodes.
Obviously you can expand this configuration simply adding the components you need. As stated at the beginning of this tutorial you can create all this setup on a single server (well you need 3 IPs on the server) or, and that would be very easy, you can split the MySQL cluster components on many servers.
2 Comments
Hi,
Thanks a lot. This demonstration is very useful to me and it is working fine. I have installed and tested the mysql clusters in my single linux machine.
Very useful………………..
Hi Karuna,
many thanks for your feedback: I tried all these steps for a clean installation but I’m also the writer of this tutorial
Bye
Apiero
Post a Comment