The primary server has been installed and running there, and already have bin log enabled.
1.
Install RPM packages on slave server
Linux rpm package sequence:
rpm -ivh --replacefiles mysql-community-common-5.7.23-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.23-1.el6.x86_64.rpm
rpm -ivh --replacefiles mysql-community-libs-compat-5.7.23-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.23-1.el6.x86_64.rpm
rpm -ivh --replacefiles /development/soft/mysql/mysql-community-server-5.7.23-1.el6.x86_64.rpm
2.
Start mysql serivce slave server
[LAB] root@jptkytcdh02vl /etc/init.d # service mysqld start
Initializing MySQL database: [ OK ]
Starting mysqld: [ OK ]
3.
Create slave user
create user 'slave'@'jptkytcdh02vl' identified by slave;
grant replication slave on *.* to 'slave'@'jptkytcdh02vl';
4.
Connect to slave server, and configure slave server
change master to
master_host = ’
jptkytcdh01vl
’,
master_user = ’slave’,
master_password = ’slave’,
master_log_file = ’mine-master.000001’,
master_log_pos =
980;
5.
Check the status
show slave status;
more /var/lib/mysql/master.info
Notes: how to troubleshooting
show grants for 'replicate'@'192.168.1.203';
2. select host,user,password from mysql.user;
3. mysql -u slave -h 192.168.83.35 -p (on slave)
4. sudo iptables -F(disable firewall on both servers)