maria-discuss team mailing list archive

[Thomas Plant <thomas@plant.systems>]

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@xxxxxxxxxxxxxxxxxxx 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