mysql-router-MIC-8.0.26集群部署
1、具体部署详情请看视频
https://space.bilibili.com/677825194
2、mysql主要配置如下
cat > /etc/my.cnf < [client] socket=/tmp/mysql.sock [mysqld] user=mysql port=3306 basedir=/usr/local/mysql datadir=/usr/local/mysql/data log_bin=/usr/local/mysql/binlog log_error=/usr/local/mysql/data/err.log server_id=100 socket=/tmp/mysql.sock gtid_mode=ON enforce_gtid_consistency=ON master_info_repository=TABLE relay_log_info_repository=TABLE log_slave_updates=ON tmpdir = /tmp default-storage-engine=INNODB disabled_storage_engines =MyISAM,BLACKHOLE,FEDERATED,CSV,ARCHIVE max_connections=500 max_allowed_packet=32M default_authentication_plugin=mysql_native_password binlog_checksum=NONE binlog_transaction_dependency_tracking = WRITESET transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name="fe6a56f8-1ba4-4a6e-a6ac-81148224101a" loose-group_replication_start_on_boot=OFF loose-group_replication_local_address= "master:33061" loose-group_replication_group_seeds="master:33061,slave1:33062,slave2:33063" loose-group_replication_bootstrap_group=OFF #loose-group_replication_ip_whitelist="master,slave1,slave2,manager" [mysql] socket=/tmp/mysql.sock prompt=master [\\d]> EOF slav1节点 cat > /etc/my.cnf < [client] socket=/tmp/mysql.sock [mysqld] user=mysql port=3306 basedir=/usr/local/mysql datadir=/usr/local/mysql/data log_bin=/usr/local/mysql/binlog log_error=/usr/local/mysql/data/err.log server_id=101 socket=/tmp/mysql.sock gtid_mode=ON enforce_gtid_consistency=ON master_info_repository=TABLE relay_log_info_repository=TABLE log_slave_updates=ON tmpdir = /tmp default-storage-engine=INNODB disabled_storage_engines =MyISAM,BLACKHOLE,FEDERATED,CSV,ARCHIVE max_connections=500 max_allowed_packet=32M default_authentication_plugin=mysql_native_password binlog_checksum=NONE binlog_transaction_dependency_tracking = WRITESET transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name="fe6a56f8-1ba4-4a6e-a6ac-81148224101a" loose-group_replication_start_on_boot=OFF loose-group_replication_local_address= "slave1:33061" loose-group_replication_group_seeds="master:33061,slave1:33062,slave2:33063" loose-group_replication_bootstrap_group=OFF #loose-group_replication_ip_whitelist="master,slave1,slave2,manager" [mysql] socket=/tmp/mysql.sock prompt=slave1 [\\d]> EOF slav2节点 cat > /etc/my.cnf < [client] socket=/tmp/mysql.sock [mysqld] user=mysql port=3306 basedir=/usr/local/mysql datadir=/usr/local/mysql/data log_bin=/usr/local/mysql/binlog log_error=/usr/local/mysql/data/err.log server_id=102 socket=/tmp/mysql.sock gtid_mode=ON enforce_gtid_consistency=ON master_info_repository=TABLE relay_log_info_repository=TABLE log_slave_updates=ON tmpdir = /tmp default-storage-engine=INNODB disabled_storage_engines =MyISAM,BLACKHOLE,FEDERATED,CSV,ARCHIVE max_connections=500 max_allowed_packet=32M default_authentication_plugin=mysql_native_password binlog_checksum=NONE binlog_transaction_dependency_tracking = WRITESET transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name="fe6a56f8-1ba4-4a6e-a6ac-81148224101a" loose-group_replication_start_on_boot=OFF loose-group_replication_local_address= "slave2:33061" loose-group_replication_group_seeds="master:33061,slave1:33062,slave2:33063" loose-group_replication_bootstrap_group=OFF #loose-group_replication_ip_whitelist="master,slave1,slave2,manager" [mysql] socket=/tmp/mysql.sock prompt=slave2 [\\d]> EOF