mysql主从配置

1、mysql二进制搭建（三台）

2、配置文件修改重启

（1）

[mysqld]
basedir=/application/mysql
datadir=/application/mysql/data
socket=/tmp/mysql.sock
log-error=/var/log/mysql.log
log-bin=/application/mysqlbin/mysql-bin
binlog_format=row
secure-file-priv=/tmp
server-id=51
log-slave-updates=1
relay_log_purge = 0
skip-name-resolve
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
innodb_buffer_pool_size=10G
innodb_log_file_size=1000M
max_connections=1500
innodb_log_file_size=1024M
[mysql]
socket=/tmp/mysql.sock
default-character-set = utf8mb4

（2）

[mysqld]
basedir=/application/mysql
datadir=/application/mysql/data
socket=/tmp/mysql.sock
log-error=/var/log/mysql.log
log-bin=/application/mysqlbin/mysql-bin
binlog_format=row
secure-file-priv=/tmp
server-id=52
log-slave-updates=1
relay_log_purge = 0
skip-name-resolve
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
innodb_buffer_pool_size=10G
innodb_log_file_size=1000M
max_connections=1500
innodb_log_file_size=1024M
[mysql]
socket=/tmp/mysql.sock
default-character-set = utf8mb4

 （3）

[mysqld]
basedir=/application/mysql
datadir=/application/mysql/data
socket=/tmp/mysql.sock
log-error=/var/log/mysql.log
log-bin=/application/mysqlbin/mysql-bin
binlog_format=row
secure-file-priv=/tmp
server-id=53
log-slave-updates=1 
relay_log_purge = 0
skip-name-resolve
character-set-server = utf8mb4  
collation-server = utf8mb4_unicode_ci
innodb_buffer_pool_size=10G
innodb_log_file_size=1000M
max_connections=1500
innodb_log_file_size=1024M
[mysql]
socket=/tmp/mysql.sock
default-character-set = utf8mb4

3、在主节点执行

show master status;

查看postion号和二进制日志位置

创建repl复制权限的用户，供主从复制用

grant replication slave  on *.* to repl@'%' identified by '123';

4、两台slave节点执行
 

CHANGE MASTER TO

MASTER_HOST='10.9.218.181',

MASTER_USER='repl',

MASTER_PORT=3306,

MASTER_LOG_FILE='mysql-bin.000002',

MASTER_LOG_POS=446;

启动主从复制

start slave;

查看主从复制状态

show slave status\G