Description:
I try to start 3 MySQL Servers(Server version: 8.0.32) on SAME server that has 3 IP Addresses (192.168.0.100, 192.168.0.101, 192.168.0.102)
and bind each MySQL server to a different IP address on same server and use group_replication_communication_stack = "MYSQL",
then 3 MySQL server Group replication will start filed on same sever also.
mysql config like this:(every mysql use same port but different ip)
mysql1:
bind_address = 192.168.0.100
port = 3306
admin_address = 192.168.0.100
admin_port = 13306
mysqlx_bind_address = 192.168.0.100
mysqlx_port = 33060
report_host = 192.168.0.100
report_port = 3306
group_replication_communication_stack = "MYSQL"
mysql2:
bind_address = 192.168.0.101
port = 3306
admin_address = 192.168.0.101
admin_port = 13306
mysqlx_bind_address = 192.168.0.101
mysqlx_port = 33060
report_host = 192.168.0.101
report_port = 3306
group_replication_communication_stack = "MYSQL"
mysql3:
bind_address = 192.168.0.102
port = 3306
admin_address = 192.168.0.102
admin_port = 13306
mysqlx_bind_address = 192.168.0.102
mysqlx_port = 33060
report_host = 192.168.0.102
report_port = 3306
group_replication_communication_stack = "MYSQL"
errors:
2023-04-23T00:26:37.518624-07:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Using MySQL as Communication Stack for XCom'
2023-04-23T00:26:37.518789-07:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Successfully connected to the local XCom via anonymous pipe'
2023-04-23T00:26:37.522529-07:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 3306'
2023-04-23T00:26:37.582697-07:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306'
2023-04-23T00:26:37.582713-07:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sleeping for 5 seconds before retrying to join the group. There are 9 more attempt(s) before giving up.'
2023-04-23T00:26:42.616372-07:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Using MySQL as Communication Stack for XCom'
2023-04-23T00:26:42.616506-07:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Successfully connected to the local XCom via anonymous pipe'
2023-04-23T00:26:42.617928-07:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 3306'
2023-04-23T00:26:42.680951-07:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306'
2023-04-23T00:26:42.680967-07:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sleeping for 5 seconds before retrying to join the group. There are 8 more attempt(s) before giving up.'
=======================================================================
If I use this config(different port), group_replication will start success.
mysql1:
bind_address = 192.168.0.100
port = 3306
admin_address = 192.168.0.100
admin_port = 13306
mysqlx_bind_address = 192.168.0.100
mysqlx_port = 33060
report_host = 192.168.0.100
report_port = 3306
group_replication_communication_stack = "MYSQL"
mysql2:
bind_address = 192.168.0.101
port = 3307
admin_address = 192.168.0.101
admin_port = 13307
mysqlx_bind_address = 192.168.0.101
mysqlx_port = 33070
report_host = 192.168.0.101
report_port = 3307
group_replication_communication_stack = "MYSQL"
mysql3:
bind_address = 192.168.0.102
port = 3308
admin_address = 192.168.0.102
admin_port = 13308
mysqlx_bind_address = 192.168.0.102
mysqlx_port = 33080
report_host = 192.168.0.102
report_port = 3308
group_replication_communication_stack = "MYSQL"
=======================================================================
How to repeat:
on same server(has 3 IP Addresses 192.168.0.100, 192.168.0.101, 192.168.0.102) config like this:
mysql1:
bind_address = 192.168.0.100
port = 3306
admin_address = 192.168.0.100
admin_port = 13306
mysqlx_bind_address = 192.168.0.100
mysqlx_port = 33060
report_host = 192.168.0.100
report_port = 3306
group_replication_communication_stack = "MYSQL"
mysql2:
bind_address = 192.168.0.101
port = 3306
admin_address = 192.168.0.101
admin_port = 13306
mysqlx_bind_address = 192.168.0.101
mysqlx_port = 33060
report_host = 192.168.0.101
report_port = 3306
group_replication_communication_stack = "MYSQL"
mysql3:
bind_address = 192.168.0.102
port = 3306
admin_address = 192.168.0.102
admin_port = 13306
mysqlx_bind_address = 192.168.0.102
mysqlx_port = 33060
report_host = 192.168.0.102
report_port = 3306
group_replication_communication_stack = "MYSQL"