Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2472

BinlogRouter's "Using secondary masters" documentation is incomplete

    XMLWordPrintable

Details

    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:

      Attachments

        Issue Links

          Activity

            People

              johan.wikman Johan Wikman
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.