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)
-   -   Database Mirror (http://www.howtoforge.com/forums/showthread.php?t=55683)

DKLeader 8th January 2012 23:10

Database Mirror
 
Hi,

My system id running a multiserver setup on Debian Lenny using version 3.0.4.1.

I would like to have a mirror running of my database server.
Installed a server as described in the multiserver setup guide.
In my CP I selected the "is a mirror of".
Created a new database and it was only created on the first database server and not on the mirror.

Is it not possible to do this? And if it is - how do I get all existing databases sync with the mirror? (as it is already possible with the dns)

till 9th January 2012 08:20

Quote:

Created a new database and it was only created on the first database server and not on the mirror.
There is most likely a mysql permission problem so that ispconfig slave can not connect to the mysql database of the master. Try to connect with the mysql command from the slave to the master by using the master connection details from the ispconfig config.inc.php file.

Quote:

And if it is - how do I get all existing databases sync with the mirror? (as it is already possible with the dns)
There are several technologies available for that. E.g. mysql master/master replication or a mysql cluster. Thereare tutorials on these topics available here at howtoforge.


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

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