ITPub博客

Build mysql replication

原创 作者:yuanqc 时间:2018-08-08 14:18:19 0 删除 编辑

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

 


下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-11-23

  • 博文量
    40
  • 访问量
    97590