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 25th March 2009, 16:14
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 152
Thanks: 13
Thanked 14 Times in 9 Posts
Default multiserver - mysql replication question

Till, Falko,

When setting up a second server in expert mode, does ispconfig3 handle all mysql replication by itself, or does the admin have to do something before that?

Is mysql replication setup by the ispconfig setup program itself?
Reply With Quote
Sponsored Links
  #2  
Old 26th March 2009, 09:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,467
Thanks: 813
Thanked 5,253 Times in 4,119 Posts
Default

The replication is builtin in ispconfig, the replication mechanism of the mysql daemon is not needed and not used.

Just make sure that you configure the mysql root user account on the master server so that a root user from the slave server IP and hostname can connect.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 29th March 2009, 11:41
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 152
Thanks: 13
Thanked 14 Times in 9 Posts
Default

Ok the socond server is setup in expert mode, everything is fine, the mysql replication works...


One question:

I want to have several 'slave' servers and would like all to have the same DNS zones as the master - the mydns data from the master shoould be repicated on all slaves, how can I do that?

tnx

grungy
Reply With Quote
  #4  
Old 29th March 2009, 12:05
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,467
Thanks: 813
Thanked 5,253 Times in 4,119 Posts
Default

Quote:
I want to have several 'slave' servers and would like all to have the same DNS zones as the master - the mydns data from the master shoould be repicated on all slaves, how can I do that?
This will be implemented in one of the next releases.

Currently you can use e.g. mysql replication for that or you connect the mydns instance on the slave server to the master database by editing mydns.conf.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 30th March 2009, 12:29
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 152
Thanks: 13
Thanked 14 Times in 9 Posts
Default

How does ispconfig handle replication, where can I find the rules etc etc
Reply With Quote
  #6  
Old 30th March 2009, 12:32
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,467
Thanks: 813
Thanked 5,253 Times in 4,119 Posts
 
Default

ISPConfig stores the data that shall be replicated in the sys_datalog table. The code for this is in the interface classes that handle the form actions and database updates and also in the server classes that handle the events for modules and plugins.
__________________
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:
grungy (30th March 2009)
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
mysql master to master replication question ubutux HOWTO-Related Questions 7 13th March 2009 17:07
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
MySQL 5 Master-Master question tfunky Server Operation 3 6th January 2008 13:40
MYSQL; setting/updating the root password question... rh-penguin HOWTO-Related Questions 2 30th January 2007 18:47
mysql ha replication question flashingcurser HOWTO-Related Questions 5 8th November 2006 07:04


All times are GMT +2. The time now is 10:36.


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