Production environment with database, through separation mycat did, speaking, reading and writing, and from the phone through the mysqldump total amount and the incremental backup, has opened a binary set, through
System GDB - p $(pidof mysqld) - ex "set opt_log_slave_updates=1" - batch were set up, the database shows opt_log_slave_updates=on, but their own mysql - binlog. XXXX log does not record information, this is how to return a responsibility?

CodePudding user response:

Log_slave_updates cannot open online need to restart the database

CodePudding user response:

Mysql> The set global log_slave_updates=1;
ERROR 1238 (HY000) : Variable 'log_slave_updates' is a read only Variable
-- -- -- -- -- -- -- -- -- -- -- how do you open online let it take effect?

CodePudding user response:

Online open command: system GDB - p $(pidof mysqld) - ex "set opt_log_slave_updates=1" - batch

CodePudding user response:

The online Settings will take effect in the 5.7 version of the database, but there is no effect in version 5.5 is what the devil,

CodePudding user response:

This is not the official way, so I can't guarantee the correctness

CodePudding user response:

Me to set the tested under several sets of services, although this command display version 5.5 is effective, but the actual effect wasn't working on the 5.5 version of the database is truly need to restart to take effect, but more than 5.6 and 5.7 versions can directly through the command to open,

CodePudding user response:

My is galera 3 node cluster, mysql5.7.17 version, only one node binlog, open, for the system GDB - p $(pidof mysqld) - ex "set opt_log_slave_updates=1" - batch has carried on the set, the database also shows opt_log_slave_updates=on, apparently no record two other open binlog node logs