#1  
Old 16th June 2013, 09:56
syneka syneka is offline
Junior Member
 
Join Date: Mar 2013
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
Default ISPConfig Multiserver Setup

Hello,

We've been using ISPConfig with a two server mirror setup (as per section 3.3 in the manual)

This has been working correctly, but a database application we want to test does not allow mysql increments greater than 1.

Can we convert the mirror setup into a master -> slave relationship, while still enabling the second server as a backup? I assume that should the first server fail, we would need to migrate the second server's database to the first prior to activation.

Could we still use the second server a secondary MX record under this setup?


Thanks,

Alex
Reply With Quote
Sponsored Links
  #2  
Old 17th June 2013, 11:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

Quote:
Can we convert the mirror setup into a master -> slave relationship, while still enabling the second server as a backup? I assume that should the first server fail, we would need to migrate the second server's database to the first prior to activation.
Yes. All you have to do is to disable the mysql replication and then dont use the ispconfig interface on the second server. To ensure that its not used anymore, you should delete the ispconfig.vhost link in /etc/apache2/sites-enabled/ folder on the slave.

Quote:
Could we still use the second server a secondary MX record under this setup?
Yes.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
syneka (17th June 2013)
  #3  
Old 17th June 2013, 12:00
syneka syneka is offline
Junior Member
 
Join Date: Mar 2013
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
Yes. All you have to do is to disable the mysql replication and then dont use the ispconfig interface on the second server. To ensure that its not used anymore, you should delete the ispconfig.vhost link in /etc/apache2/sites-enabled/ folder on the slave.
Thanks Till, we're looking at re-installing the second server, so should we follow the multiserver setup, with the only difference between master -> slave instead of master -> replication?

And then remove ispconfig interface on the second server?
Reply With Quote
  #4  
Old 17th June 2013, 17:16
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

If you reinstall a server, you will loose all data replicated to that system as ispconfig will not redo that when you reattach the server, basically ISPConfig expects that all data exists on the slave while it is indeed missing after reinstall. Is there any special reason why you have reinstall it?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 17th June 2013, 17:50
syneka syneka is offline
Junior Member
 
Join Date: Mar 2013
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hi Till, mainly to have a cleaner configuration. We've got there in the end migrating ISPConfig to a new system and recommissioning the secondary server in a master -> slave arrangement.

I'm sure its on your radars already but a migration guide would be a useful addition to the manual.

Alex

Quote:
Originally Posted by till View Post
If you reinstall a server, you will loose all data replicated to that system as ispconfig will not redo that when you reattach the server, basically ISPConfig expects that all data exists on the slave while it is indeed missing after reinstall. Is there any special reason why you have reinstall it?
Reply With Quote
  #6  
Old 17th June 2013, 19:03
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

Quote:
Hi Till, mainly to have a cleaner configuration. We've got there in the end migrating ISPConfig to a new system and recommissioning the secondary server in a master -> slave arrangement.
Ok. It might work that you force the slave to rewrite the configuration with the resync tool,you find it under tools. But you will have to migrate the data (website files and databases and database contents) manually then.

Quote:
I'm sure its on your radars already but a migration guide would be a useful addition to the manual.
Yes, I've planned to wrte such a guide for the manual but did not had the time yet. I hope that we can include it in the next release of the manual.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 17th June 2013, 19:07
syneka syneka is offline
Junior Member
 
Join Date: Mar 2013
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by till View Post
Ok. It might work that you force the slave to rewrite the configuration with the resync tool,you find it under tools. But you will have to migrate the data (website files and databases and database contents) manually then.
Yes we have unison transferring /var/vmail and /var/www, with the second server as a backup MX record. The slave accepts database changes from the master and I've set server2 to mirror server1 in the ISPConfig setup.

All seems to be working correctly so thank you for your help.

Quote:
Originally Posted by till View Post
Yes, I've planned to wrte such a guide for the manual but did not had the time yet. I hope that we can include it in the next release of the manual.
I'd be happy to help with this, most of the content seems already available, its a matter of collating it and updating it where needed.


Alex
Reply With Quote
Reply

Bookmarks

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
username or password invalid on email client (multiserver setup ispconfig 3) combonix Server Operation 2 20th June 2012 20:08
Dns problems via ISPCONFIG setup daseagle Installation/Configuration 2 12th March 2012 18:53
Control Panel - E-mail Tab is empty domi-nik General 15 14th April 2011 19:17
Installing A Multiserver Setup With ISPConfig 3 mbsouth HOWTO-Related Questions 1 24th August 2010 08:21
multiserver setup IzFazt Installation/Configuration 8 8th August 2010 18:58


All times are GMT +2. The time now is 19:02.


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