MySQL Replication

MySQL Replication

It is possible to use MySQL replication with SFX, for example, to create a failover system. When setting up replication, you must add a parameter to the my.cnf file to prevent problems with the triggers for Verde and the eBook Search index.

To add the parameter:
  1. As the sfxglb41 user, add the following line to the my.cnf file in the exlibris/sfx_ver/sfx4_1/data directory of the sfxglb41 instance in both the master and slave:

log_bin_trust_function_creators=1

  1. Restart MySQL.