Geek Answers Handbook

Check mysql replication type

I want to check the type of replication for my master-slave setup, regardless of whether it is based on a string or an operator. How can i do this? I am using mysql 5.6

+4
source share
1 answer

On the host computer, do:

mysql> SHOW GLOBAL VARIABLES LIKE 'binlog_format';

This variable will be either ROW, STATEMENT, or MIXED.

Note that the global default does not prevent individual beans from being changed in separate sessions, and DDL statements are always logged in STATEMENT format, regardless of what binlog_format is set for.

See http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_binlog-format

+7
source

More articles:


All Articles