MySQL Forums
Forum List  »  Install & Repo

Port problem insetting up group replication
Posted by: Yuichiro Yoshinari
Date: February 09, 2017 09:08PM

Hi,

I'm setting up gourp replication, but I have a port problem.
Coulc someone help me?

I added the following lines in my.cfg.

--- my.cfg ------
loose-group_replication_local_address= "127.0.0.1:24801"
loose-group_replication_group_seeds= "127.0.0.1:24801,127.0.0.1:24902,127.0.0.1:24801"
-----------------

However, I got an error as follows:

-----------------
mysql> SET GLOBAL group_replication_bootstrap_group=on;
Query OK, 0 rows affected (0.00 sec)

mysql> START GROUP_REPLICATION;
Query OK, 0 rows affected (1.09 sec)

mysql> SELECT * FROM performance_schema.replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| group_replication_applier | 083ebdd9-ec51-11e6-b129-000c298ddb21 | db01 | 3306 | ONLINE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
1 row in set (0.00 sec)
-----------------

As you see, I designated the port number 24801 in my.cfg, but the MEMBER PORT above indicates 3306.

So, I added the following lines, but again, I got an error.

--- my.cfg ------
[mysqld]
port=24801
-----------------

-----------------
mysql> SET GLOBAL group_replication_bootstrap_group=on;
Query OK, 0 rows affected (0.00 sec)

mysql> RESET MASTER;
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.
-----------------

Any solution?

Options: ReplyQuote


Subject
Written By
Posted
Port problem insetting up group replication
February 09, 2017 09:08PM


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.