linux环境下搭建mysql主从复制

Mster配置

1、登录mysql数据库，创建slave用户并授权replication

CREATEA USER SLAVE;

GRANT REPLICATIONSLAVE ON *.* TO 'SLAVE'@'192.168.0.%' IDENTIFIED BY '******' WITH GRANT OPTION;

2、配置my.cfg

在[mysqld]下添加

server-id=1001

log-bin=mysql-bin

Log-bin-index=mysql-bin.index

3、重启mysql server,查看master状态

Show masterstatus \G;

Slave配置

1、登录slave server，修改my.cfg

   在[mysqld]下添加

server-id=1002 #unique

log-bin=mysql-bin #optional

relay-log-index=slave-relay-bin.index

relay-log=slave-relay-bin

2、登录slave数据库，修改/添加master信息

changemaster to master_host='192.168.0.6',#master server ip

master_port=3306,

master_user='slave',

master_password='123456',

master_log_file='master-bin.000003',

master_log_pos=1286;

3、启动slave

Start slave

4、查看slave状态

如果Slave_IO_Running为no，查看/var/log/mysqld.logerror信息，

并stop slave，change master_log信息，start slave…

如果slave_io_runing为connecting，可能是master server上slave的账号

没有replication权限或者账号信息有误