MySQL主从复制：半同步、异步
node1配置文件(master)datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_file_per_table = 1
log_bin=master-log #开启二进制日志
log_bin_index=1
server_id=1 #设置serverid
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
node2配置文件(slave1)
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
relay-log=relay-log #开启relay日志
innodb_file_per_table = 1
read-only = 1 #设置只读
server_id = 2 #设置serverid
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
node3配置文件(slave2)
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
relay-log=relay-log
innodb_file_per_table = 1
read-only = 1
server_id = 3
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
##启动mysql
##注意: serverid一定不能相同
页:
[1]