Mysql Master/Slave about function Process Synchronization

Mysql Master/Slave always has an error in the function process.
 
Analysis of MySQL function creation problems:
According to the system prompt, the cause of this error may be a security configuration. The log_bin_trust_function_creators parameter in the manual is 0 by default, and function synchronization is not allowed.
Generally, when configuring repliaction, we forget to pay attention to this parameter. In this way, after the master updates the funtion, slave reports an error and slave stoped.
MySQL function creation process:
Log on to the mysql database
> Set global log_bin_trust_function_creators = 1;
> Start slave;
Tracking mysql startup logs. slave runs normally and the problem is solved.
Continuous tracking. After one night, all bin-relay-log data is synchronized. Add it directly in my. cnf
Log_bin_trust_function_creators = 1
 
 
========================================================== ======================================
When creating a function
Error message:
ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is enabled (you * might * want to use the less safe log_bin_trust_function_creators variable)
 
Cause:
If bin-log is enabled, you must specify whether our function is
1 DETERMINISTIC
2 no SQL does not have SQL statements, and of course data will not be modified
3 reads SQL DATA only READS DATA, and certainly does not modify the DATA
4 modifies SQL DATA to modify DATA
5 contains SQL statements

In function, only DETERMINISTIC, no SQL, and reads SQL DATA are supported. If bin-log is enabled, we must specify a parameter for our function.
 
Solution:
SQL code
Mysql> show variables like '% func % ';
+ --------------------------------- + ------- +
| Variable_name | Value |
+ --------------------------------- + ------- +
| Log_bin_trust_function_creators | OFF |
+ --------------------------------- + ------- +
1 row in set (0.00sec)
Mysql> set global log_bin_trust_function_creators = 1;
Query OK, 0 rows affected (0.00sec)
Mysql> show variables like '% func % ';
+ --------------------------------- + ------- +
| Variable_name | Value |
+ --------------------------------- + ------- +
| Log_bin_trust_function_creators | ON |
+ --------------------------------- + ------- +
1 row in set (0.00sec)
Mysql>
 
 
This method is very effective.