5. Change Master MySQL Server

The following steps are required to transfer master MySQL servers to another computer:

Select menu item 3. Configure MySQL servers > 5. Change master MySQL server.
Note: This menu item will appear only when at least 1 MySQL slave server will be created via menu 3. Configure MySQL servers > 4. Create slave MySQL server.
Enter host name for future master MySQL server from the list of available slave servers (for example, server2):
Wait until the task of master MySQL server change is completed.
As a result, the following MySQL servers will be available: master (server2) and two slaves (server1 and server3):

Ultimately, master MySQL server is transferred from the computer with server1 to server2.

Attention! Task execution may take a rather long time (up to 2-3 hours and more) depending on the task complexity, data volume used in such tasks, capacity and server load. You can check the currently executed tasks by using menu item 5. Background tasks in the pool > 1. View running tasks. If task completion log files are needed to be reviewed, they are located in the following directory /opt/webdir/temp.

Bitrix Virtual Appliance