Splitting up ISPC installation to more servers...

Discussion in 'Tips/Tricks/Mods' started by radim_h, Aug 25, 2012.

  1. radim_h

    radim_h Member HowtoForge Supporter

    maybe someone has been solving this and may help me with some issues. I want to split my ISPConfig setup, there is hundreds of sites, so it must be done all in once

    Todays setup:
    server1: ISPConfig webinterface, DNS, oldwebserver
    server2: mailserver, dbserver

    Final setup will be:
    server1: ISPconfig webinterface, DNS
    server2: mailserver
    server3: newwebserver
    server4: newdbserver

    PART I. splitting webserver, moving it from server1 to server3

    i did some testing allready, so here is how i did it:

    1.Install new ISPConfig server, connect it to master server and set as webserver
    according to http://www.howtoforge.com/multiserv...se-servers-on-debian-squeeze-with-ispconfig-3

    2. Change webserver assigned to users
    UPDATE client SET default_webserver

    3. Change webserver assigned to web domains
    UPDATE web_domain SET server_id

    4. Change webserver assgined to FTP users
    UPDATE ftp_user SET server_id

    5. Change DNS records
    UPDATE dns_rr SET 'new.ip.add.ress' WHERE 'old.ip.add.ress'

    6. On new webserver rsync web sites
    rsync -aHAXv [email protected]:/var/www/* /var/www

    7. Use resync tools on master server
    Tools=>Sync Tools=>Resync Websites & Resync FTP users & Resync DNS records

    It works, sites are moved, but not everything is done, so before i do it on production server, i have some

    - how to sync changes in client table to second server, as there is no sync tool?
    - how to sync web_traffic table to second server ?

    - did i miss something more ?
    Last edited: Aug 25, 2012
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    I recommend that you start with a copy of the dbispconfig records from the old master on all new servers.
  3. radim_h

    radim_h Member HowtoForge Supporter

    do you mean, make copy of whole database ?
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes. When you copy the database, you might have more data on the slaves then the normal replication system would copy, but this does not hurt. If you want to remove some data on the slaves, then you can safely delete all data were the server_id of the record does not match the server_id of the server or server_id != 0 as records with server_id = 0 have to be replicatde to all servers. If a database table has no serevr_id column, then its saver to not delete any data in that table.

Share This Page