create user repl@'%' identified by 'repl123';

grant replication slave on *.* to repl@'%';

change master to

            master_user='repl',

            master_password='repl123'

            for channel 'group_replication_recovery';

select * from mysql.slave_relay_log_info\G

install plugin group_replication soname 'group_replication.so';

set @@global.group_replication_bootstrap_group=on;   ---->是否是Group Replication的引导节点，初次搭建集群的时候需要有一个节点设置为ON来启动Group Replication

start group_replication;

set @@global.group_replication_bootstrap_group=off;

select * from performance_schema.replication_group_members;

create database test;

use test;

create table t1(id int);

create table t2(id int)engine=myisam;

create table t3(id int primary key)engine=myisam;  --->不支持

create table t4(id int primary key);

  change master to

            master_user='repl',

            master_password='repl123'

            for channel 'group_replication_recovery';

install plugin group_replication soname 'group_replication.so';

set global group_replication_allow_local_disjoint_gtids_join=1;

start group_replication;
 

sql_log_bin=0;

start transaction..........

sql_log_bin=1；

start group_replication;

stop group_replication;

select * from performance_schema.replication_group_members;

select b.member_host the_master,a.variable_value master_uuid

    from performance_schema.global_status a

    join performance_schema.replication_group_members b

    on a.variable_value = b.member_id

    where variable_name='group_replication_primary_member';

+------------+--------------------------------------+
| the_master | master_uuid |
+------------+--------------------------------------+
| calldb3 | cc4958ae-a1cc-11e8-9334-00155d322c00 |
+------------+--------------------------------------+

[root@calldb1 ~]# cat /etc/keepalived/keepalived.conf

vrrp_script chk_mysql_port {

script "/etc/keepalived/chk_mysql.sh"  ---判断实例存活

interval 2

weight -5

fall 2

rise 1

}

vrrp_script chk_mysql_master {

script "/etc/keepalived/chk_mysql2.sh"  ---判断主节点

interval 2

weight 10

}

vrrp_instance VI_1 {

state MASTER

interface eth0

virtual_router_id 88

priority 100

advert_int 1

authentication {

auth_type PASS

auth_pass 1111

}

virtual_ipaddress {

192.168.0.100

}

track_script {

chk_mysql_port

chk_mysql_master

}

}

[root@calldb1 ~]# cat /etc/keepalived/chk_mysql.sh

#!/bin/bash

netstat -tunlp |grep mysql

a=`echo $?`

if [ $a -eq 1 ] ;then

service keepalived stop

fi

[root@calldb1 ~]# cat /etc/keepalived/chk_mysql2.sh

#!/bin/bash

host=`/data/mysql/bin/mysql -h127.0.0.1 -uroot -pxxx -e "SELECT * FROM performance_schema.replication_group_members WHERE MEMBER_ID = (SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME= 'group_replication_primary_member')" |awk 'NR==2{print}'|awk -F" " '{print $3}'`

host2=`hostname`

if [ $host == $host2 ] ;then

exit 0

else

exit 1

fi

--30T21::24.604720+:  [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt 6/10'

--30T21::24.605458+:  [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='sanborn1', master_port= , master_log_file='', master_log_pos= , master_bind=''. New state master_host='sanborn1', master_port= , master_log_file='', master_log_pos= , master_bind=''.

--30T21::24.610029+:  [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor 75af6fe1-6a92-11e9-8bf8-005056a1d54e at sanborn1 port: 3306.'

--30T21::24.611927+:  [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.

--30T21::24.645794+:  [ERROR] Slave I/O for channel 'group_replication_recovery': error connecting to master 'repl@sanborn1:3306' - retry-time:   retries: , Error_code:

--30T21::24.645847+:  [Note] Slave I/O thread for channel 'group_replication_recovery' killed while connecting to master

--30T21::24.645861+:  [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'FIRST', position

--30T21::24.646002+:  [ERROR] Plugin group_replication reported: 'There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.'

--30T21::24.646064+:  [ERROR] Plugin group_replication reported: 'For details please check performance_schema.replication_connection_status table and error log messages of Slave I/O for channel group_replication_recovery.'

--30T21::24.646271+:  [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt 7/10'