MySQL Forums
Forum List  »  InnoDB clusters

Re: Mysql group replication..
Posted by: Steph V
Date: May 11, 2017 12:17AM

Hi Frederic,

Thanks for the advice in regards to only running it on two nodes. I was actually in the process of configuring a third server when my group decided to break up :)

I'm not sure why the second server were preferred. This was all handled by mysql router. It's a rather basic config. Also , and I'm guessing this is where stuff went wrong. My second server were in "super read only mode" which I've removed since in my understanding it should be ok to write to either server ? I'm not sure what "sql_log_bin=0" does but it doesn't seem present within my config files. Also , same goes for log_slave_updates . I basically skimmed through the howto on the Mysql dev site. I've also included my configs for both servers.

<--- Here's the Mysql Router config: --->
[routing:read_write]
bind_address = 10.25.0.200
bind_port = 7002
destinations = 10.25.0.200:3306,10.25.0.201:3306
mode = read-write

<---- server nr. 1 my.cnf /---->

server_id=1
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
log_bin=binlog
binlog_format=ROW

transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "10.25.0.200:33061"
loose-group_replication_group_seeds= "10.25.0.200:33061,10.25.0.201:33061"
loose-group_replication_bootstrap_group= off

<---- server nr. 2 my.cnf /---->

server_id=2

gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
log_bin=binlog
binlog_format=ROW

transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "10.25.0.201:33061"
loose-group_replication_group_seeds= "10.25.0.201:33061,10.25.0.200:33061"
loose-group_replication_bootstrap_group= off

Options: ReplyQuote


Subject
Views
Written By
Posted
2837
May 10, 2017 06:25AM
Re: Mysql group replication..
1536
May 11, 2017 12:17AM
1134
May 11, 2017 11:39AM


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.