This guide explains how to configure MySQL on a master node for replication. By default, MySQL listens on localhost and does not allow remote connections. To enable replication, MySQL must listen on the master server\u2019s public IP and be properly configured.<\/p>\n
Step 1: Edit the MySQL Configuration File<\/p>\n
On Debian-based systems (Ubuntu, Debian)<\/p>\n
nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/pre>\nOn RHEL-based systems (CentOS, RHEL, AlmaLinux)<\/p>\n
nano \/etc\/my.cnf<\/pre>\nStep 2: Update MySQL Bind Address<\/p>\n
Find the following line:<\/p>\n
bind-address = 127.0.0.1<\/pre>\nReplace it with:<\/p>\n
bind-address = log_bin = \/var\/lib\/mysql\/mysql-bin.log<\/pre>\nStep 3: Enable Replication Settings<\/p>\n
Ensure the following line is present and uncommented:<\/p>\n
server-id = 1<\/pre>\nAdd the following lines at the end of the configuration file:<\/p>\n
log_bin = \/var\/log\/mysql\/mysql-bin.loglog_bin_index = \/var\/log\/mysql\/mysql-bin.log.indexrelay_log = \/var\/log\/mysql\/mysql-relay-binrelay_log_index = \/var\/log\/mysql\/mysql-relay-bin.index<\/pre>\nSave and close the file.<\/p>\n
Step 4: Restart the MySQL Service<\/p>\n
Apply the changes by restarting MySQL:<\/p>\n
systemctl restart mysql<\/pre>\nStep 5: Create a Replication User<\/p>\n
Log in to the MySQL shell:<\/p>\n
mysql -u root -p<\/pre>\nCreate a replication user:<\/p>\n
CREATE USER 'replica_user'@'%' IDENTIFIED BY 'strong_password';<\/pre>\nGrant replication privileges:<\/p>\n
GRANT REPLICATION SLAVE ON *.* TO 'replica_user'@'%';\r\nFLUSH PRIVILEGES;<\/pre>\nExit MySQL:<\/p>\n
EXIT;<\/pre>\nMySQL is now configured on the master node with replication enabled. The server is listening on the public IP, binary logging is active, and a replication user has been created. This setup allows slave nodes to connect securely for replication.<\/p>\n
If you need further assistance, please contact our support team.<\/p>\n","protected":false},"excerpt":{"rendered":"
This guide explains how to configure MySQL on a master node for replication. By default, MySQL listens on localhost and does not allow remote connections. To enable replication, MySQL must…<\/p>\n