[MXS-2472] BinlogRouter's "Using secondary masters" documentation is incomplete Created: 2019-05-08  Updated: 2019-05-09  Resolved: 2019-05-09

Status: Closed
Project: MariaDB MaxScale
Component/s: binlogrouter, Documentation
Affects Version/s: 2.3.6
Fix Version/s: 2.3.7

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MXS-1980 Support Galera cluster nodes as maste... Closed

 Description   

The following documentation section appears to be incomplete:

Using secondary masters

From MaxScale 2.3 onwards it is possible to specify secondary masters that the binlog router can use in case the connection to the default master fails.

Note: This is only supported in conjunction with a Galera cluster and provided the following holds: @@log_slave_updates is enabled on all servers, all nodes in the Galera cluster have the same server_id, and all nodes in the Galera cluster use the same* basename for the binlog files (specified in the server config file with log_bin=basename).

https://mariadb.com/kb/en/mariadb-maxscale-23-binlogrouter/#using-secondary-masters

This section does not mention:

  • That wsrep_gtid_mode=ON needs to be set on all nodes.
  • That wsrep_gtid_domain_id needs to be set to the same value on all nodes.
  • And even if all of these are set properly, wsrep_gtid_mode is imperfect, and GTIDs can get out of sync within a cluster.

I think the section should read more like this:

Using secondary masters

From MaxScale 2.3 onwards it is possible to specify secondary masters that the binlog router can use in case the connection to the default master fails.

Note: This is only supported in a Galera Cluster environment in which:



 Comments   
Comment by Johan Wikman [ 2019-05-09 ]

GeoffMontee Thanks for this clarification. I will update the documentation accordingly.
Johan

Generated at Thu Feb 08 04:14:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.