multiple sites on multiple servers with same database

Discussion in 'Installation/Configuration' started by iqpascal, Apr 17, 2018.

  1. iqpascal

    iqpascal Member

    Hi,
    I have a site that uses 3 urls on 3 different servers.
    Server 1: Main ispconfig server with multiple websites on it
    Server 2: Server in the USA with just 1 website on it (in ISPConfig multiserver setup)
    Server 3: Server in Asia with just 1 website on it (In ISPConfig multiserver setup)
    Now all sites need access to the same database. Server 2 and 3 need read access. Server 1 writes changes (database changes a couple a times a day).
    People from different parts of the world get their own URL that is closest to their location. To minimize delay I do not want server 2 and 3 to access the database server of server 1

    How can I set this up database wise? Should I just create the same databasename/user on all 3 servers and use master->slave replication on server 2 and 3 for that specific database? Will this break things with ISPConfig?
     

Share This Page