Am 24.02.2020 um 14:20 schrieb Reinis Rozitis:
we are using 'mixed logging' in the binary log so should be safe activating 'log_bin_trust_function_creators = ON'? Should be yes. Do I have to set it on the master only or slave to? If you don't plan to promote slave to a master at some later/failover time then it's needed only on master. p.s. it's a dynamic setting so if the user needs to make the triggers once you can enable it temporary with SET GLOBAL log_bin_trust_function_creators = 1; then switch off again. rr _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp Thank you very much for your help. Did activate the
SET GLOBAL log_bin_trust_function_creators = 1; on the master and will let the customer test if creating triggres now works. Greetings, Thomas