How to setup MySQL Master-Slave replication
Hello there! This time I’m going to discuss one of the projects I got involved recently. The team is expanding the operations to a new operator and we need to deploy the platform in new servers. One instance is to create database replications in MySQL. Below is the environment I’m working on Master and Slave are CentOS Linux release 7.4 Linux Servers. Master IP Address is 192.168.100.1. Slave IP Address is 192.168.100.2. Master and Slave are on the same LAN network. Let’s install MySQL on the master server and configure 1. For CentOS 7 and Red Hat (RHEL) 7 yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm 2. CentOS 7.4/6.9 and Red Hat (RHEL) 7.4/6.9 yum install mysql-community-server 3. Start MySQL server and auto start MySQL on boot. Below commands can be used in Fedora 27/26/25 and CentOS 7.4 and Red Hat (RHEL) 7.4 systemctl start mysqld.service systemctl enable mysqld.service But I couldn’t log in to the MySQL by using below command