MySQL Forums
Forum List  »  Replication

MYSQL 8.0 - Group Replication - Error on Start up
Posted by: Harishankar Sekar
Date: August 16, 2018 09:02AM

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...

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL 8.0 - Group Replication - Error on Start up
2668
August 16, 2018 09:02AM


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.