MySQL Group Replication ->Error on opening a connection to 192.168.2.1:33061 on local port: 33061.'

MySQL & MariaDB Percona Distribution for MySQL
1

Hi There …

Iam configuring MySQL Group replication with 3 server s ,When started the MySQL group replication at server 1

faced the below error.

Can any anyone please suggest how to proceed.

mysql> START GROUP_REPLICATION;

[ERROR] Plugin group_replication reported: ‘[GCS] Error on opening a connection to 192.168.2.1:33061 on local port: 33061.’

[ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 192.168.2.2:33061 on local port: 33061.

'[ERROR] Plugin group_replication reported: ‘[GCS] Error connecting to all peers. Member join failed. Local port: 33061’

[Warning] Plugin group_replication reported: ‘read failed’

Error reading relay log event for channel ‘group_replication_applier’: slave SQL thread was killed

2

Hello @AneeshBabuThe first member must be bootstrapped, always:

SET GLOBAL group_replication_bootstrap_group = ON;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group = OFF;

Then, start remaining members as normal.