HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   multiserver - mysql replication question (http://www.howtoforge.com/forums/showthread.php?t=32843)

grungy 25th March 2009 16:14

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?

till 26th March 2009 09:33

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.

grungy 29th March 2009 11:41

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

till 29th March 2009 12:05

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.

grungy 30th March 2009 12:29

How does ispconfig handle replication, where can I find the rules etc etc

till 30th March 2009 12:32

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.


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

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