Clustered MariaDB and Global Traffic Director (High Availability server)

Discussion in 'Installation/Configuration' started by EckyBrazzz, Aug 17, 2017.

  1. EckyBrazzz

    EckyBrazzz Member

    Hi Folks,

    I managed to get 4 clusters on different zones across the globe, Replications working perfectly.
    Now I want to install on each zone the ISPCONFIG panel, with different names to indicate the user the user zone.
    So I have them in the USA, South America, Germany, and Singapore.

    When Installing the Cpanel I bump into an error, selecting expert setup and this is what I get
    Code:
    Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: n
    
    Wrong SQL-mode. You should use NO_ENGINE_SUBSTITUTION. Add
    
        sql-mode="NO_ENGINE_SUBSTITUTION"
    
    to the mysqld-section in your mysql-config on this server and restart mysqld afterwards
    root@cpanel_us:/tmp/ispconfig3-stable-3.1-bfe71a5eeb97967874a1d2095a75b4ab55ccfc9b/install#
    
    I do have a remote database manager to delete the database made by ISPCONFIG until I reach the latest server (It's a cluster so that should be fine)

    I have to manually add some code that ISPCONFIG can work with GeoIP to select the fastest DBase.
    I also have to add Rsync to sync the /var/www directions.

    But so far I did not get because of the error above.
    Who can help? Give me a clue on how to fix it
     

Share This Page