How to Configure a MySQL Cluster
Prerequisites 3 Virtual Machines or servers (Using Ubuntu 24.04 LTS here). Ensure mysql-server and mysql-shell are installed. (If not installed, use this command: apt install mysql-server mysql-shell -y). These three servers must have network connectivity with each other. Edit /etc/mysql/mysql.conf.d/mysqld.cnf and change bind-address = 127.0.0.1 to bind-address = 0.0.0.0. Restart MySQL after making this change. Getting Started 🚀 Update the /etc/hosts file Run on all 3 servers 127.0.0.1 localhost 192.168.100.140 db-node-01 192.168.100.141 db-node-02 192.168.100.142 db-node-03 Update hostnames Run on all 3 servers respectively ...