主庫配置
server-id=1
port=3306
datadir=/data/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#log
expire_logs_days = 7
tmp_table_size=1G
#bin-log
log-bin=mysql-bin
sync_binlog=1
binlog_format=mixed
max_binlog_size=5G
binlog_cache_size=128m
max_binlog_cache_size=512m
#config
innodb_buffer_pool_size=1G
添加用戶
添加用戶權(quán)限
grant replication slave on *.* to 'relay'@'%';
FLUSH PRIVILEGES;
顯示主庫狀態(tài)
show master status;
配置
配置從庫
CHANGE MASTER TO
MASTER_HOST = '11.11.4.15',
MASTER_USER = 'relay',
MASTER_PASSWORD = 'xxxx',
MASTER_PORT = 3306,
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=852,
MASTER_RETRY_COUNT = 60,
GET_MASTER_PUBLIC_KEY=1,
MASTER_HEARTBEAT_PERIOD = 10000;
啟動(dòng)從庫
start slave;
如果要重新修改配置 ，需要先停止文章來源：http://www.zghlxwxcb.cn/news/detail-834413.html
stop slave;
最后查看從庫狀態(tài)文章來源地址http://www.zghlxwxcb.cn/news/detail-834413.html
show slave status;
到了這里，關(guān)于配置mysql的主從同步的文章就介紹完了。如果您還想了解更多內(nèi)容，請?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
