环境准备
1、主机名和和IP地址如下
10.0.0.51 db01.ljbb.com
10.0.0.52 db02.ljbb.com
10.0.0.53 db03.ljbb.com
2、配置文件
- db01
[mysqld]
user=mysql
basedir=/app/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=51
port=3306
secure-file-priv=/tmp
autocommit=0
log_bin=/data/binlog/mysql-bin
binlog_format=row
gtid-mode=on
enforce-gtid-consistency=true
#log-slave-uodates=1
log_slave_updates = ON
[mysql]
prompt=db01 [\\d]>
- db02
[mysqld]
user=mysql
basedir=/app/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=52
port=3306
secure-file-priv=/tmp
autocommit=0
log-bin=/data/binlog/mysql-bin
binlog_format=row
gtid-mode=on
enforce-gtid-consistency=true
log_slave_updates = ON
[mysql]
prompt=db02 [\\d]>
- db03
[mysqld]
user=mysql
basedir=/app/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=53
port=3306
secure-file-priv=/tmp
autocommit=0
log-bin=/data/binlog/mysql-bin
binlog_format=row
gtid-mode=on
enforce-gtid-consistency=true
log_slave_updates = ON
[mysql]
prompt=db03 [\\d]>
3、准备软件用户
3台执行：
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
4、准备软件目录（根据配置文件-保证权限）
mkdir /data/binlog/ -p
mkdir /data/mysql/data -p
chown mysql:mysql /data
chown mysql:mysql /app/mysql
5、初始化（3台执行）
mysqld --initialize-insecure --user=mysql --basedir=/app/mysql --datadir=/data/mysql/data
