mysql启动命令如何配置集群_mysql启动命令集群模式启动配置说明

[mysqld]
server-id = 1
log-bin = mysql-bin

[mysqld]
server-id = 2
relay-log = mysql-relay-bin

sudo systemctl restart mysql

CHANGE MASTER TO
  MASTER_HOST='主库IP',
  MASTER_USER='repl',
  MASTER_PASSWORD='password',
  MASTER_LOG_FILE='mysql-bin.000001',
  MASTER_LOG_POS= 4;

START SLAVE;

[mysqld]
server-id = 101
gtid_mode = ON
enforce-gtid-consistency = ON
binlog_checksum = NONE
log-bin = binlog
log-slave-updates = ON
master-info-repository = TABLE
relay-log-info-repository = TABLE
plugin-load-add = group_replication.so
transaction-write-set-extraction = XXHASH64
loose-group-replication-group-name = "aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee"
loose-group-replication-start-on-boot = OFF
loose-group-replication-local-address = "本机IP:33261"
loose-group-replication-group-seeds = "节点1IP:33261,节点2IP:33261"
loose-group-replication-ip-allowlist = "信任IP段"
loose-group-replication-single-primary-mode = OFF  # 多主模式

sudo systemctl start mysql

INSTALL PLUGIN group_replication SONAME 'group_replication.so';
SET SQL_LOG_BIN=0;
CREATE USER repl@'%' IDENTIFIED BY 'replpass';
GRANT REPLICATION SLAVE ON *.* TO repl@'%';
FLUSH PRIVILEGES;
SET SQL_LOG_BIN=1;
CHANGE MASTER TO MASTER_USER='repl', MASTER_PASSWORD='replpass' FOR CHANNEL 'group_replication_recovery';
START GROUP_REPLICATION;

mysqlsh --uri root@localhost:3306
# 进入 JS 模式
var cluster = dba.createCluster('mycluster')

cluster.addInstance('root@node2:3306')

sudo systemctl start mysql

sudo systemctl start mysql    # Systemd 系统
sudo service mysql start      # SysVinit 系统