Multi/Mirror setup with HA mariadb

Discussion in 'Installation/Configuration' started by tomipnh, Feb 26, 2025.

  1. tomipnh

    tomipnh New Member

    Hi!
    I have two dedicated servers - srv1.domain.tld, srv2.domain.tld - both of them are connected via wireguard.
    Ultimately I want to have MariaDB Galera, but for now I have master<>master replication mariadb setup over wireguard.
    Load balancer will eventually be deployed in front of the web servers to make more bullet proof setup,
    right now my main srv1 server has pretty much all services and for redundancy srv2 should take role as secondary nameserver and second web server to serve web application even during problems with srv1.

    so much for the introduction - now how to do it,
    srv1 is configured serve web, mail, ftp - basically full setup
    i did mysql replication and srv2 is waiting for ispconfig installation

    I have been comparing the documents available on howtoforge and a little outdated user manual and I am having trouble with the database that replicates itself. Installator asking for access to localhost mysql and database of master server. Should I create dbispconfig2 for srv2 and setup master as dbispconfig? Or in Multi/Mirror setup instances uses same database?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Each node must have its own database. Interface connects only to the master.
     

Share This Page