1,初始化和启动
<代码> mysql/bin/mysqld——initialize-insecure basedir=/下/mysql——datadir=/经理/数据/s1 mysql/bin/mysqld——initialize-insecure basedir=/下/mysql——datadir=/经理/数据/s2 mysql/bin/mysqld——initialize-insecure basedir=/下/mysql——datadir=/经理/数据/s3/下/mysql/bin/mysqld——defaults-file=/经理/数据/s1/s1.cnf/下/mysql/bin/mysqld——defaults-file=/经理/数据/s2/s2.cnf/下/mysql/bin/mysqld——defaults-file=/下/数据/s3/s3.cnf
2,配置文件具体内
<代码> s1: (mysqld) #服务器配置 datadir=/经理/数据/s1 basedir=/经理/mysql/用户=mysql 端口=24801 套接字=/下/数据/s1/s1.sock # disabled_storage_engines=" MyISAM、黑洞、联合、归档、记忆” #复制框架 server_id=1 gtid_mode=对 enforce_gtid_consistency=对 master_info_repository=表 relay_log_info_repository=表 binlog_checksum=没有 log_slave_updates=对 log_bin=binlog binlog_format=行 #组复制设置 transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name=" 5 c7975ec - 0000 - 11 - e9 a8c9 - 0800273906 ff” loose-group_replication_start_on_boot=了 loose-group_replication_local_address=" 127.0.0.1:24901 " loose-group_replication_group_seeds=" 127.0.0.1:24901、127.0.0.1:24902 127.0.0.1:24903” loose-group_replication_bootstrap_group=了 s2: (mysqld) #服务器配置 datadir=/经理/数据/s2 basedir=/经理/mysql/用户=mysql 端口=24802 套接字=/下/数据/s2/s2.sock # disabled_storage_engines=" MyISAM、黑洞、联合、归档、记忆” #复制框架 server_id=2 gtid_mode=对 enforce_gtid_consistency=对 master_info_repository=表 relay_log_info_repository=表 binlog_checksum=没有 log_slave_updates=对 log_bin=binlog binlog_format=行 #组复制设置 transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name=" 5 c7975ec - 0000 - 11 - e9 a8c9 - 0800273906 ff” loose-group_replication_start_on_boot=了 loose-group_replication_local_address=" 127.0.0.1:24902 " loose-group_replication_group_seeds=" 127.0.0.1:24901、127.0.0.1:24902 127.0.0.1:24903” loose-group_replication_bootstrap_group=了 s3: (mysqld) #服务器配置 datadir=/经理/数据/s3 basedir=/经理/mysql/用户=mysql 端口=24803 套接字=/下/数据/s3/s3.sock # disabled_storage_engines=" MyISAM、黑洞、联合、归档、记忆” #复制框架 server_id=3 gtid_mode=对 enforce_gtid_consistency=对 master_info_repository=表 relay_log_info_repository=表 binlog_checksum=没有 log_slave_updates=对 log_bin=binlog binlog_format=行 #组复制设置 transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name=" 5 c7975ec - 0000 - 11 - e9 a8c9 - 0800273906 ff” loose-group_replication_start_on_boot=了 loose-group_replication_local_address=" 127.0.0.1:24903 " loose-group_replication_group_seeds=" 127.0.0.1:24901、127.0.0.1:24902 127.0.0.1:24903” loose-group_replication_bootstrap_group=了
3,登录MySQL执行命令
<代码> s1必要过程 mysql>设置SQL_LOG_BIN=0; mysql>创建用户rpl_user@‘%’被‘密码’; mysql>格兰特复制奴隶 group_replication_start_on_boot=了 group_replication_local_address=" 127.0.0.1:24903 " group_replication_group_seeds=" 127.0.0.1:24901、127.0.0.1:24902 127.0.0.1:24903” group_replication_bootstrap_group=了 修改后参数 loose-group_replication_group_name=" 5 c7975ec - 0000 - 11 - e9 a8c9 - 0800273906 ff” loose-group_replication_start_on_boot=了 loose-group_replication_local_address=" 127.0.0.1:24903 " loose-group_replication_group_seeds=" 127.0.0.1:24901、127.0.0.1:24902 127.0.0.1:24903” loose-group_replication_bootstrap_group=了 问题2创建的复制用户和使用的复制用户不一致 mysql>从performance_schema.replication_group_members SELECT *; + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - + | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - + | group_replication_applier | 5 c7975ec a9cd - 11 - e9 a8c9 - 0800273906 ff | mgr1 | 24801 |在线| | group_replication_applier | 69908 c35 - a9cd - 11 - e9 - 8 b78 - 0800273906 - ff | mgr1 | 24802 | |中恢复 + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - + 原: 修改主MASTER_USER=repli, MASTER_PASSWORD=皉epli@ %”频道“group_replication_recovery”; 修改后,要和创建的复制用户一致 修改主MASTER_USER=rpl_user, MASTER_PASSWORD频道“group_replication_recovery”=懊苈搿? 问题3未执行开始GROUP_REPLICATION;新加入节点显示离线 mysql>从performance_schema.replication_group_members SELECT *; + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + 零离线| | | group_replication_applier | | | + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + 1行集(0.00秒) 执行后 mysql>null null null null null null null null null null null nullMySQL组复制下安装关键过程
