Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 9.2

...

Note

When running MySQL database as a slave to a ClustrixDB master, ClustrixDB does not support the variable binlog_checksum, which causes the master to write checksums for events written to the binary log.

...

  • The MySQL slave must have the global gtid_mode set to OFF, OFF_PERMISSIVE, or ON_PERMISSIVE.
  • The MySQL startup option enforce-gtid-consistency should be set to OFF on the slave. See Startup Options Used with GTID Replication.

...

If more than one binary log exists, the log configured by the global variable master_status_binlog is displayed. If master_status_binlog is unset, an error is returned. This behavior is compatible with behavior of the MySQL mysqldump --master-data command.

...

  1. To list the most recent binlog, issue the SHOW MASTER STATUS command. The command returns a filename such as clustrix-bin.001903.
  2. Create a directory in the /clustrix mount on a node and cd to it.
  3. To retrieve all binlog files up to the most recent, issue the following command: 

    shell> node# repclient -addr 10.52.2.20 -dumpbinlog -logname clustrix-bin.000001 -end_logname clustrix-bin.001903
                
Note

By default, the tool outputs decoded binlog messages to stdout. To specify an output file, specify the  -dumpbinlog option. If you intend to archive the binlogs, omit -logpos, which can create gaps in the resulting binlog. By default, the utility stays connected to the master. To specify when it is to disconnect, include the -end_logname or -end_logpos option.

...

To prevent a session's statements from being inserted into any binary log, set sql_log_bin to false by issuing the following command:

...

This variable inherits the value of the identically-named global variable at the start of each session. To replicate from a ClustrixDB instance, set sql_log_bin to true.

Warning

Be careful using sql_log_bin in production. Improper use can lead to data skew between the master and the slave(s).

...