Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th August 2012, 14:19
radim_h radim_h is offline
Senior Member
 
Join Date: Jan 2007
Location: Prague, Czech
Posts: 426
Thanks: 34
Thanked 26 Times in 21 Posts
Send a message via ICQ to radim_h
Default Splitting up ISPC installation to more servers...

Hello,
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/multiserve...th-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 root@oldwebserver1:/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

Questions:
- 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 by radim_h; 25th August 2012 at 14:31.
Reply With Quote
Sponsored Links
  #2  
Old 26th August 2012, 14:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,995
Thanks: 840
Thanked 5,649 Times in 4,459 Posts
Default

I recommend that you start with a copy of the dbispconfig records from the old master on all new servers.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 27th August 2012, 00:42
radim_h radim_h is offline
Senior Member
 
Join Date: Jan 2007
Location: Prague, Czech
Posts: 426
Thanks: 34
Thanked 26 Times in 21 Posts
Send a message via ICQ to radim_h
Default

do you mean, make copy of whole database ?
Reply With Quote
  #4  
Old 27th August 2012, 10:41
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,995
Thanks: 840
Thanked 5,649 Times in 4,459 Posts
 
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Tags
ispc, multi, split, split installation, splitting

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cisco, Solaris and LACP Mark_NL Technical 1 14th December 2011 10:57
How to split ISPC installation to more servers? radim_h Installation/Configuration 2 25th November 2011 16:25
Installation without replicate db servers tucanit Installation/Configuration 4 26th January 2011 23:06
ISPC3 on CentOS 5.5 64 Bit - Installation fails with Path Errors & DB not imported kweitzel Installation/Configuration 10 17th July 2010 23:27
Problem with my ISPconfig installation Purposite Installation/Configuration 2 13th June 2009 19:54


All times are GMT +2. The time now is 16:00.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.