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)
-   -   remove slave server from master? (http://www.howtoforge.com/forums/showthread.php?t=60202)

burlyhousetech 12th January 2013 19:46

remove slave server from master?
 
My existing config is a master server + slave. The slave node has been offline for several weeks due to failed hardware, which occurred shortly after installation. I have now prepared a new server to act as slave, which uses the same host name and IP address as the earlier.

I don't want to confuse the master server and so was thinking I should first remove references to the old slave before installing the new. How can I do this safely?

Is it okay to simply delete the relevant entry in the 'server' table? Are there any other actions I should perform to clean things up before pairing the new slave node?

burlyhousetech 12th January 2013 20:05

re: remove slave server from master?
 
Just noticed several other tables use 'server_id' column to relate with rows of 'server' table. Presuming I would also need to delete any rows which match the ID of the old slave node.

Thank you for your confirmation on whether or not this plan will work. I don't want to chance mucking up the master server as it is in production for many hosted clients.

Best,
_N

burlyhousetech 16th January 2013 22:44

re: remove slave server from master?
 
Can anyone offer insight? I feel pretty confident in the approach, but would be grateful for confirmation from someone who knows first-hand of any potential "gotchas".

The only remaining part beyond what I posted before would be to remove the related MySQL privs in mysql.user, mysql.tables_priv and mysql.columns_priv.

_N

webguyz 17th January 2013 00:16

Have you tried going into the Master and just deleting the secondary server from the list in the System menu?

burlyhousetech 17th January 2013 01:00

Haven't tried anything yet - The docs are light on disassociating a node server, so was hoping for a confirmed "best approach" before continuing.

till 17th January 2013 10:22

1) Delete all websites, mail domains and dns zones that belong to the server which shall be removed. Wait until the jobqueue has cleared. This will remove the items inside ispconfig and on the slave server. This has to be done on traditional server setups, not mirroring setups!

2) Login to the slave server and remove the server.sh cronjob from root crontab.

4) Delete the record of this server in the "server" database table of the ispconfig DB on the master.

burlyhousetech 8th March 2013 19:29

re: remove slave server from master?
 
Following up to share that the method described worked fine. Thank you!


All times are GMT +2. The time now is 18:08.

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