MYSQL 8.0 - Group Replication - Error on Start up
We are trying to configure group replication in MySQL 8.0 with two machines. We made the following config entries,
[mysqld]
server-id=1
log-bin = /var/lib/mysql/mysql-bin
basedir=/var/lib
relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
relay-log-info-file = /var/lib/mysql/mysql-relay-log.info
max_connections = 1000D
plugin_dir=/usr/lib64/mysql/plugin
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
gtid_mode=ON
enforce-gtid-consistency=ON
binlog_checksum=NONE
log_slave_updates=ON
binlog_format=ROW
master_info_repository=TABLE
relay_log_info_repository=TABLE
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="f4c300ce-a156-11e8-a825-00e07c7e1047"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "192.168.100.183:3306"
loose-group_replication_group_seeds= "192.168.100.183:3306,192.168.100.188:3306"
loose-group_replication_bootstrap_group=off
Also created a new user, gave full permission to that user id and changed it to the master user id using the following command,
CHANGE MASTER TO MASTER_USER='mygroup', MASTER_PASSWORD='######' FOR CHANNEL 'group_replication_recovery';
Then installed group replication plugin using the following command,
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
Then executed the following commands,
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
At this point we are getting the following error,
ERROR 3094 (HY000): The START GROUP_REPLICATION command failed as the applier module failed to start.
What could be the issue..? Kindly assist...
Subject
Views
Written By
Posted
MYSQL 8.0 - Group Replication - Error on Start up
3351
August 16, 2018 09:02AM
1244
August 20, 2018 04:11PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.