數(shù)據(jù)安裝完成后

配置信息? 開啟二進(jìn)制文件復(fù)制

[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

#主從復(fù)制配置

server-id=1 #設(shè)置server-id

log_bin=mysql-bin #開啟二進(jìn)制日志

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

復(fù)制用戶授權(quán)

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

查看二進(jìn)制是否開啟

show variables like ‘%log_bin%‘;

查看二進(jìn)制文件名/id

SHOW MASTER STATUS;

根據(jù)二進(jìn)制文件 配置復(fù)制腳本

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;

啟動(dòng)復(fù)制(更新腳本時(shí)需要停止 stop slave)

start slave;

查看配置是否成功

show slave status\G;

刷新

flush privileges;

mysql主主配置

標(biāo)簽：ges???查看???config???max???二進(jìn)制日志???完成后???clu???啟動(dòng)???serve

本條技術(shù)文章來源于互聯(lián)網(wǎng)，如果無意侵犯您的權(quán)益請(qǐng)點(diǎn)擊此處反饋版權(quán)投訴

本文系統(tǒng)來源：https://www.cnblogs.com/yxnyd/p/10757372.html

總結(jié)

以上是生活随笔為你收集整理的mysql搭建主主_mysql主主配置的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。