Step:1 Install mysql using RPM pakages. Following is my.cnf configuration: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid port=3306 server_id=103 skip-name-resolve bind-address=0.0.0.0 # General replication configuration master_info_repository = TABLE relay_log_info_repository = TABLE log-bin=mysql-bin103 relay-log=relay-bin103 relay_log_recovery= on log-slave-updates=1 #expire_logs_days=15 gtid-mode=on enforce-gtid-consistency=1 binlog_format=row binlog_checksum=NONE # Group replication configuration transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name="64100a82-fccb-11e6-9ead-00505605efff" loose-group_replication_start_on_boot=off loose-group_replication_local_address= "192.168.2.103:3308" loose-group_replication_group_seeds= "192.168.2.104:3307,192.168.2.103:3308,192.168.2.102:3309,192.168.2.101:3310" loose-group_replication_bootstrap_group= off [mysql] socket = /var/lib/mysql/mysql.sock [client] socket = /var/lib/mysql/mysql.sock port = 3306 STEP 2: - Login to mysql with default generated password in mysql server log (log-error). - Set root@localhost password using ALTER USER. - Executed follwing cmds for group replication setup: mysql> SET SQL_LOG_BIN=0; Query OK, 0 rows affected (0.00 sec) mysql> CREATE USER rpl_user@'%' IDENTIFIED BY 'Rpl_usr@114'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> SET SQL_LOG_BIN=1; Query OK, 0 rows affected (0.00 sec) mysql> CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='Rpl_usr@114' FOR CHANNEL 'group_replication_recovery'; Query OK, 0 rows affected, 2 warnings (0.01 sec) mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; Query OK, 0 rows affected (0.01 sec) mysql> START GROUP_REPLICATION; ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log. mysql> SELECT * FROM performance_schema.replication_group_members; +---------------------------+--------------------------------------+--------------+-------------+--------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | +---------------------------+--------------------------------------+--------------+-------------+--------------+ | group_replication_applier | 19500be1-fd87-11e6-982c-0050560525da | VM-100351267 | 3306 | OFFLINE | +---------------------------+--------------------------------------+--------------+-------------+--------------+ 1 row in set (0.00 sec) BINLOG events: mysql> show binlog events in 'mysql-bin103.000001'; +---------------------+-----+----------------+-----------+-------------+-------------------------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +---------------------+-----+----------------+-----------+-------------+-------------------------------------------------------------------+ | mysql-bin103.000001 | 4 | Format_desc | 103 | 123 | Server ver: 5.7.17-log, Binlog ver: 4 | | mysql-bin103.000001 | 123 | Previous_gtids | 103 | 150 | | | mysql-bin103.000001 | 150 | Gtid | 103 | 211 | SET @@SESSION.GTID_NEXT= '19500be1-fd87-11e6-982c-0050560525da:1' | | mysql-bin103.000001 | 211 | Query | 103 | 278 | BEGIN | | mysql-bin103.000001 | 278 | Table_map | 103 | 329 | table_id: 62 (mysql.plugin) | | mysql-bin103.000001 | 329 | Write_rows | 103 | 401 | table_id: 62 flags: STMT_END_F | | mysql-bin103.000001 | 401 | Xid | 103 | 428 | COMMIT /* xid=3949 */ | | mysql-bin103.000001 | 428 | Stop | 103 | 447 | | +---------------------+-----+----------------+-----------+-------------+-------------------------------------------------------------------+ 8 rows in set (0.00 sec) mysql> show binlog events in 'mysql-bin103.000002'; +---------------------+-----+----------------+-----------+-------------+----------------------------------------------------------------------------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +---------------------+-----+----------------+-----------+-------------+----------------------------------------------------------------------------------------------------------------------+ | mysql-bin103.000002 | 4 | Format_desc | 103 | 123 | Server ver: 5.7.17-log, Binlog ver: 4 | | mysql-bin103.000002 | 123 | Previous_gtids | 103 | 190 | 19500be1-fd87-11e6-982c-0050560525da:1 | | mysql-bin103.000002 | 190 | Gtid | 103 | 251 | SET @@SESSION.GTID_NEXT= '19500be1-fd87-11e6-982c-0050560525da:2' | | mysql-bin103.000002 | 251 | Query | 103 | 426 | ALTER USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*7BB96B4D3E986612D96E53E62DBE9A38AAA40A5A' | | mysql-bin103.000002 | 426 | Stop | 103 | 445 | | +---------------------+-----+----------------+-----------+-------------+----------------------------------------------------------------------------------------------------------------------+ 5 rows in set (0.00 sec) mysql> ____________________________ Error Log: 2017-02-28T07:31:31.583430Z 3 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"' 2017-02-28T07:31:31.583672Z 3 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 127.0.0.1/8,192.168.2.103/24 to the whitelist' 2017-02-28T07:31:31.583905Z 3 [Note] Plugin group_replication reported: '[GCS] SSL was not enabled' 2017-02-28T07:31:31.583934Z 3 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "64100a82-fccb-11e6-9ead-00505605efff"; group_replication_local_address: "192.168.2.103:3308"; group_replication_group_seeds: "192.168.2.104:3307,192.168.2.103:3308,192.168.2.102:3309,192.168.2.101:3310"; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "AUTOMATIC"' 2017-02-28T07:31:31.592912Z 6 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. 2017-02-28T07:31:31.604661Z 9 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-bin103-group_replication_applier.000001' position: 4 2017-02-28T07:31:31.605096Z 3 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!' 2017-02-28T07:31:31.605109Z 3 [Note] Plugin group_replication reported: 'auto_increment_increment is set to 7' 2017-02-28T07:31:31.605113Z 3 [Note] Plugin group_replication reported: 'auto_increment_offset is set to 103' 2017-02-28T07:31:31.605283Z 0 [Note] Plugin group_replication reported: 'state 0 action xa_init' 2017-02-28T07:31:31.622664Z 0 [Note] Plugin group_replication reported: 'Successfully bound to 0.0.0.0:3308 (socket=67).' 2017-02-28T07:31:31.622697Z 0 [Note] Plugin group_replication reported: 'Successfully set listen backlog to 32 (socket=67)!' 2017-02-28T07:31:31.622706Z 0 [Note] Plugin group_replication reported: 'Successfully unblocked socket (socket=67)!' 2017-02-28T07:31:31.622743Z 0 [Note] Plugin group_replication reported: 'Ready to accept incoming connections on 0.0.0.0:3308 (socket=67)!' 2017-02-28T07:31:31.622759Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.2.103 3308' 2017-02-28T07:31:31.622872Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.2.103 3308 fd 69' 2017-02-28T07:31:31.623091Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.2.103 3308' 2017-02-28T07:31:31.623159Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.2.103 3308 fd 71' 2017-02-28T07:31:31.623332Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.2.103 3308' 2017-02-28T07:31:31.623385Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.2.103 3308 fd 73' 2017-02-28T07:31:31.623591Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.2.103 3308' 2017-02-28T07:31:31.623645Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.2.103 3308 fd 75' 2017-02-28T07:31:31.623801Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.2.103 3308' 2017-02-28T07:31:31.623880Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.2.103 3308 fd 77' 2017-02-28T07:31:31.624033Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.2.103 3308' 2017-02-28T07:31:31.624092Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.2.103 3308 fd 79' 2017-02-28T07:31:31.624277Z 0 [Note] Plugin group_replication reported: 'connecting to 192.168.2.104 3307' 2017-02-28T07:31:31.625040Z 0 [Note] Plugin group_replication reported: 'client connected to 192.168.2.104 3307 fd 81' 2017-02-28T07:31:32.270711Z 0 [Note] Plugin group_replication reported: 'state 4257 action xa_snapshot' 2017-02-28T07:31:32.270987Z 0 [Note] Plugin group_replication reported: 'new state x_recover' 2017-02-28T07:31:32.270996Z 0 [Note] Plugin group_replication reported: 'state 4277 action xa_complete' 2017-02-28T07:31:32.271103Z 0 [Note] Plugin group_replication reported: 'new state x_run' 2017-02-28T07:31:37.123504Z 0 [ERROR] Plugin group_replication reported: 'This member has more executed transactions than those present in the group. Local transactions: 19500be1-fd87-11e6-982c-0050560525da:1-2 > Group transactions: 64100a82-fccb-11e6-9ead-00505605efff:1-10' 2017-02-28T07:31:37.123556Z 0 [ERROR] Plugin group_replication reported: 'The member contains transactions not present in the group. The member will now exit the group.' 2017-02-28T07:31:37.123561Z 0 [Note] Plugin group_replication reported: 'To force this member into the group you can use the group_replication_allow_local_disjoint_gtids_join option' 2017-02-28T07:31:37.123634Z 3 [Note] Plugin group_replication reported: 'Going to wait for view modification' 2017-02-28T07:31:37.124131Z 0 [Note] Plugin group_replication reported: 'getstart group_id a61722e4' 2017-02-28T07:31:40.742156Z 0 [Note] Plugin group_replication reported: 'state 4330 action xa_terminate' 2017-02-28T07:31:40.742403Z 0 [Note] Plugin group_replication reported: 'new state x_start' 2017-02-28T07:31:40.742412Z 0 [Note] Plugin group_replication reported: 'state 4257 action xa_exit' 2017-02-28T07:31:40.742463Z 0 [Note] Plugin group_replication reported: 'Exiting xcom thread' 2017-02-28T07:31:40.742470Z 0 [Note] Plugin group_replication reported: 'new state x_start' 2017-02-28T07:31:45.752332Z 3 [Note] Plugin group_replication reported: 'auto_increment_increment is reset to 1' 2017-02-28T07:31:45.752374Z 3 [Note] Plugin group_replication reported: 'auto_increment_offset is reset to 1' 2017-02-28T07:31:45.752607Z 9 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed 2017-02-28T07:31:45.757110Z 6 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'