Build mysql replication

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

1.  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)