Hello
I have set this option on a 5.6.15 PXC (customer needs it) but could not set it on the 5.6.19 async slaves which replicates from the pxc:
I tried some variations in the my.cnf:
2014-08-12 11:58:17 31360 [ERROR] /usr/sbin/mysqld: unknown option ‘–log_bin_trust_functions_creators’
2014-08-12 12:00:50 32329 [ERROR] /usr/sbin/mysqld: unknown variable ‘log_bin_trust_functions_creators=1’
2014-08-12 12:06:24 3705 [ERROR] /usr/sbin/mysqld: unknown variable ‘log-bin-trust-functions-creators=1’
2014-08-12 12:09:45 4710 [ERROR] /usr/sbin/mysqld: unknown option ‘–log-bin-trust-functions-creators’
2014-08-12 12:10:54 5633 [ERROR] /usr/sbin/mysqld: unknown option ‘–log_bin_trust_functions_creators’
2014-08-12 12:12:20 7383 [ERROR] /usr/sbin/mysqld: unknown variable ‘log_bin_trust_functions_creators=ON’
2014-08-12 12:12:56 8283 [ERROR] /usr/sbin/mysqld: unknown variable ‘log_bin_trust_functions_creators=ON’
seting it dynamically after restart without the my.cnf parameter works:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.6.19-67.0-log Percona Server (GPL), Release 67.0, Revision 618
Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> set global log_bin_trust_function_creators = 1;
Query OK, 0 rows affected (0.00 sec)
mysql>
Bug?