Shulou(Shulou.com)06/01 Report--

This article mainly introduces how the process of storing mysql functions is like, the contents of the articles are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand how the process of storing mysql functions is like.

This parameter is a matter of setting up stored procedures and function functions

If this parameter is not enabled in the master library, the function of the slave library may be inconsistent, and the master and slave cannot be copied.

With this parameter, binglog logs must be enabled from the slave library.

Is to make an accurate copy of function.

Both the master library and the slave library have to add this parameter.

Then open the binlog log from the library

Configuration file

Log_bin_trust_function_creators=ON

Mysql > set global log_bin_trust_function_creators=1

In addition, if you create a function on master and want to copy the function to slave by master-slave copy, you also need to set the value of the above variable to ON in the slave with log-bin turned on (the setting of the variable will not be copied from master to slave, which should be noted), otherwise master-slave copy will report an error.

After reading the above about the process of storing mysql functions, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.