MySQL master never supports storage engine

Recently encountered a problem in MySQL master server executed a storage engine, resulting in master-slave synchronization failure. It turns out that MySQL does not support the use of the storage engine from the master. To support this, you need to modify the MySQL configuration as follows:

“”

MySQL master-slave on function process synchronization problem

Found MySQL master and slave The same step is always wrong for the function process

MySQL Create function problem analysis:

Depending on the system prompts, the cause of this error may be a configuration of security settings, the manual log_bin_trust_function_creators parameter default 0, is not allowed to synchronize the function.
In general, when we configure the repliaction, we forget to focus on this parameter, so after the master update funtion, slave will report an error, and then slave stoped.
MySQL Create function problem handling process:
Log in to MySQL database
> Set global log_bin_trust_function_creators = 1;
> Start slave;
Track MySQL startup log, slave normal operation, problem solving.
Continuous tracking, after one night, the Bin-relay-log data are all synchronized. Add it directly inside the MY.CNF
Log_bin_trust_function_creators = 1

“”

The first time you encounter this problem, you should pay more attention to it later.

This article is from "Constant line Mowgli's blog" blog, please be sure to keep this source http://liheng2011.blog.51cto.com/3091246/1639379

MySQL master never supports storage engine