Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th November 2012, 17:03
frederic frederic is offline
Junior Member
 
Join Date: Jan 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default multiple databank servers / migration

Hello,

We are using a multiserver configuration:
a- 1 main ispconfig for the adminpanel (A)
b- 1 mysql DB server (B)
c- 4 slave ispconfigs who are configured to be a mirror of the main ispconfig. (C)
d- 2 mysql DB servers that are using drbd. (D)

What we trying to do is using D as a second database server for our client & in time do a migration of B to D.

I have 2 questions:
1) in current setup, B & D are known in ispconfig as standard dbs servers. With the ispconfig-admin user i can create a databank to B, and one to D.

However, a client can only create a databank to B. There is no drop down option to select which databank server you want. Cann't a client use multiple databankservers ? There are no permission about this. You can only choose a default databank server to a client.

2) In time we want a migration of databank server B to D.
We can do a mysql dump from B and do a import to D.
B and D have different ipadresses.

How will our main ispconfig recognize that there are suddenly more databases on D? Is there a way to update all the B-links in the main ispconfig's mysql so B becomes D?

Best Regards,
Frederic

Last edited by frederic; 26th November 2012 at 17:07. Reason: typo
Reply With Quote
Sponsored Links
  #2  
Old 29th November 2012, 07:40
ITG ITG is offline
HowtoForge Supporter
 
Join Date: Nov 2012
Location: Alabama
Posts: 18
Thanks: 1
Thanked 1 Time in 1 Post
 
Default

Are you wanting to setup mysqld replication between the two servers?

If you do this, then when someone creates a database/table/record it would automatically replicate those changes from server B to server D.

You could also setup 2 way replication between the two servers, so then if you start using D as your primary server, it would also replicate back to B.
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
How to host a forum with multiple web servers? itwillcome Technical 3 11th February 2011 01:26
Multiple email servers icemannz Installation/Configuration 5 26th April 2010 04:21
Multiple Servers ahagadorn Developers' Forum 5 9th February 2010 14:38
ISPConfig 3.0.0.5 on Multiple Servers diablorick Installation/Configuration 13 10th October 2009 15:14
Unable send receive emails vassilis3 Installation/Configuration 15 19th May 2007 14:34


All times are GMT +2. The time now is 07:39.


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