Difference between revisions of "How to install MYSQL NDB cluster"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
* 1 SQL node | * 1 SQL node | ||
== Hardware/software requirements== | == Hardware/software requirements== | ||
| − | I am running this in a VM environment. All nodes have 1Gb of RAM and 20GB of disk. To run this in a productions environment please refer to the MSQL NDB cluster documentation. All 4 nodes are running Debian stretch | + | I am running this in a VM environment. All nodes have 1Gb of RAM and 20GB of disk. To run this in a productions environment please refer to the MSQL NDB cluster documentation. |
| + | df -h | ||
| + | Filesystem Size Used Avail Use% Mounted on | ||
| + | udev 488M 0 488M 0% /dev | ||
| + | tmpfs 100M 11M 90M 11% /run | ||
| + | /dev/sda1 19G 9.0G 8.8G 51% / | ||
| + | tmpfs 499M 0 499M 0% /dev/shm | ||
| + | tmpfs 5.0M 0 5.0M 0% /run/lock | ||
| + | tmpfs 499M 0 499M 0% /sys/fs/cgroup | ||
| + | tmpfs 100M 0 100M 0% /run/user/2001 | ||
| + | |||
| + | All 4 nodes are running Debian stretch | ||
lsb_release -a | lsb_release -a | ||
No LSB modules are available. | No LSB modules are available. | ||
Revision as of 13:00, 25 August 2018
In the tutorial we will install MYSQL Network Database cluster (NDB) using 4 nodes.
Prerequisites
To complete this tutorial, you'll need the following:
- 1 management node
- 2 data nodes
- 1 SQL node
Hardware/software requirements
I am running this in a VM environment. All nodes have 1Gb of RAM and 20GB of disk. To run this in a productions environment please refer to the MSQL NDB cluster documentation.
df -h Filesystem Size Used Avail Use% Mounted on udev 488M 0 488M 0% /dev tmpfs 100M 11M 90M 11% /run /dev/sda1 19G 9.0G 8.8G 51% / tmpfs 499M 0 499M 0% /dev/shm tmpfs 5.0M 0 5.0M 0% /run/lock tmpfs 499M 0 499M 0% /sys/fs/cgroup tmpfs 100M 0 100M 0% /run/user/2001
All 4 nodes are running Debian stretch
lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux 9.5 (stretch) Release: 9.5 Codename: stretch
Networking
IF you want to use the node FQDN you need to have a DNS server or update the /etc/hosts file; othewise, you can you the node IP address. For this tutorial We are gong to use the node FQDN.