linux mysql 主从配置_linux下mysql主从配置详细教程

1、修改MySQL配置：

主库配置

server-id = 3

binlog-do-db=xmcp_gxfc #the db need to sync

binlog-ignore-db = mysql #不需要同步的数据库

binlog-ignore-db = redmine #不需要同步的数据库

log_slave_updates = 1

binlog_format=mixed

relay_log = /usr/local/mysql/relay_log/mysql-relay-bin

read_only = 1

2创建账号

grant replication slave on . to 'slave2'@'%' identified by 'FjAfj6#xajot#K%V';

grant replication slave on . to 'slave3'@'%' identified by 'FjAfj6#xajot#K%V';

更新数据库权限

mysql>flush privileges;

mysql> show master status;

记录下 File为mysql-bin.000001

记录下 position为 154

3、修改从库MySQL配置：

从库配置：

server-id = 5

log-bin = mysql-bin

replicate-do-db=xmcp_gxfc

binlog_format=mixe