CiviCRM Community Forums (archive)

I want to have civicrm logging enabled, AND binary logging in the database because of our master/slave setup.
I do not want SUPER privilege, because of security.

When I look in MYSQL documentation there seems to be a way out
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_log_bin_trust_function_creators

"It controls whether stored function creators can be trusted not to create stored functions that will cause unsafe events to be written to the binary log. "
This also applies for triggers.

Does anyone know if the civicrm triggers used for logging (and probably multi-language) are safe regarding the binary log?
Here's some more information
http://dev.mysql.com/doc/refman/5.1/en/stored-programs-logging.html

The triggers should be "deterministic".

If civicrm can confirm this we should be able to use variable "log_bin_trust_function_creators"

Thank you.

I will use this variable on a test environment.

Will let you the results.