Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    SFX
    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. SFX
    3. Product Documentation
    4. Version 4.0
    5. SFX System Administration Guide
    6. SFX Environment
    7. MySQL Replication

    MySQL Replication

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. 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.
    View article in the Exlibris Knowledge Center
    1. Back to top
      • SFX Maintenance Tasks
      • Security
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Documentation
      Language
      English
      Product
      SFX
    2. Tags
      This page has no tags.
    1. © Copyright 2026 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved