Hello, I have a setup that uses multiserver environment. Server1: main ispconfig db Server2: mail + dns (NFS storage) Server3: web etc.... I have noticed problems with my "Server 2" mail server. The virtual machine was mulfanctioning. So I have created "Server 4" a new VPS and added it to the environment. I have configured it as "Mirror of Server 2" and mounted the NFS /var/vmail folder. Now that Server2 has a full running mirror I would like to disable the bad server and make my mirror the main server. My idea is to make sure that both servers are synced ( their databases are up to date ) and then just turn off "Server 2" and change the value of 'server_id' on the "Mirror server" replacing it with the id of "Server2". What do you think - is this a good idea? Regards, MC
Maybe a better idea would be also to dump the database from Server2 and import it on Server4 so that everything is in place. And then set the server_id on Server4 to Server2.
Only the original master database contains all data in a mirror setup, this means that you have to take care that the original master database remains the master after your changes, a slave database can not become the master. So if you need to change servers, take care that the original DB of the server with ID 1 remains the master db and that all slaves connect to the server with that database after you finished your server change.