mysql 主主配置_mysql主主配置

数据安装完成后

配置信息  开启二进制文件复制

[client]

port=3306

[mysqld]

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

#socket=/usr/local/mysql/mysql.sock

socket=/tmp/mysql.sock

user=mysql

#skip-grant-tables

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

#主从复制配置

server-id=1 #设置server-id

log_bin=mysql-bin #开启二进制日志

expire_logs_days=10

max_binlog_size=100M

binlog-do_db=test_master_slave

binlog_ignore_db=mysql

[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

pid-file=/var/run/mariadb/mariadb.pid

#

# include all files from the config directory

#

!includedir /etc/my.cnf.d

复制用户授权

GRANT REPLICATION SLAVE ON *.* TO 'root'@'%';

查看二进制是否开启

show variables like '%log_bin%';

查看二进制文件名/id

SHOW MASTER STATUS;

根据二进制文件 配置复制脚本

CHANGE MASTER TO MASTER_HOST='192.168.0.114',MASTER_USER='root',MASTER_PASSWORD='root',MASTER_LOG_FILE='mysql-bin.000003',MASTER_LOG_POS=154;

CHANGE MASTER TO MASTER_HOST='192.168.0.113',MASTER_USER='root',MASTER_PASSWORD='root',MASTER_LOG_FILE='mysql-bin.000002',MASTER_LOG_POS=848;

启动复制(更新脚本时需要停止 stop slave)

start slave;

查看配置是否成功

show slave status\G;

刷新

flush privileges;