MGR

Percona MySQL MGR集群

安装MySQL 安装插件配置组复制 启动组复制 安装MySQL sudo yum install http://10.10.102.88:8090/percona-release-latest.noarch.rpm -y sudo percona-release setup ps80 sudo dnf -y module disable mysql sudo yum install -y percona-server-server percona-toolkit percona-xtrabackup-80 pmm2-client sudo systemctl start mysql sudo mysql_secure_installation 三台节点安装插件配置组复制 set sql_log_bin = 0; create user 'dbreplica'@'%' identified by '8888888888'; grant replication slave on *.* to 'dbreplica'@'%'; flush privileges; set sql_log_bin = 1; mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; Query OK, 0 rows affected (0.04 sec) mysql> show master status; +----------------+----------+--------------+------------------+------------------------------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +----------------+----------+--------------+------------------+------------------------------------------+ | bin-log.

继续阅读