Clustered MariaDB and Global Traffic Director (High Availability server)

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

  1. EckyBrazzz

    EckyBrazzz Member

    Hi,

    I have a cluster MariaDB cluster with for now 4 Cluster servers in 4 different continents. So if someone enters a thing in Cluster 1 it appears automatically in all the other Clusters.
    I also have 4 servers (in the same zones) until now I don´t know how where to install ISPCONFIG. The servers have the name, for example,
    control-eu, control-us etc. and also have a little MariaDB installed,

    Here I get stuck a bit. Should I install the ISPCONFIG into the Cluster or on the 4 other servers.
    Do I have to do something like this on the Cluster or on the other servers

    Code:
    CREATE USER 'root'@'192.168.0.109' IDENTIFIED BY 'myrootpassword';
    GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.0.109' IDENTIFIED BY 'myrootpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;CREATE USER 'root'@'mail.example.tld' IDENTIFIED BY 'myrootpassword';
    GRANT ALL PRIVILEGES ON * . * TO 'root'@'cluster1.example.tld' IDENTIFIED BY 'myrootpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
    
    Thanks for looking into it !

    Greetings

    EckyBrazzz
     

Share This Page