[MXS-2580] Clarify requirements of binlog router secondary masters Created: 2019-06-27 Updated: 2021-01-25 Resolved: 2021-01-25 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | binlogrouter, Documentation |
| Affects Version/s: | None |
| Fix Version/s: | 2.5.7 |
| Type: | Task | Priority: | Major |
| Reporter: | Johan Wikman | Assignee: | Johan Wikman |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||||||
| Epic Link: | Pinloki Project | ||||||||||||||||||||||||
| Description |
|
https://mariadb.com/kb/en/mariadb-maxscale-23-binlogrouter/#using-secondary-masters |
| Comments |
| Comment by Geoff Montee (Inactive) [ 2019-06-27 ] | ||||||||||||||||
|
I have a suggestion for this. In the case of Galera Cluster, there are two GTID domains--gtid_domain_id and wsrep_gtid_domain_id. Only the domain defined by wsrep_gtid_domain_id is used for transactions that are replicated by Galera Cluster. The domain defined by gtid_domain_id is only used for transactions that are local to the node. This means that gtid_domain_id is likely to get out of sync between cluster nodes for all sorts of reasons. I would suggest updating the documentation, so that DO_DOMAIN_IDS = (<wsrep_gtid_domain_id>) is set in the CHANGE MASTER command. https://mariadb.com/kb/en/library/change-master-to/#do_domain_ids However, it looks like MaxScale 2.3.8 doesn't support the DO_DOMAIN_IDS option yet, so it would have to be implemented first. I created i.e. if wsrep_gtid_domain_id=2, then the command for the primary master would be:
And the command for the secondary master would be:
| ||||||||||||||||
| Comment by Geoff Montee (Inactive) [ 2019-10-02 ] | ||||||||||||||||
|
If MariaDB Server supported something like | ||||||||||||||||
| Comment by Niclas Antti [ 2021-01-25 ] | ||||||||||||||||
|
The new binlogrouter has an option "select_master" which allows it to use a master of a cluster monitored by maridbmon or galeramon. |