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 _______________________________________________ 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
