Mirror MySQL Database to another Server

Hot Actions

Handy Backup works with MySQL server without a need to stop an instance. This allows "hot" (unstopped) transferring of a MySQL mirror database to another server. If you need more consistent MySQL mirroring, you can also stop a server and make "cold" copies of MySQL mirror table content.

Remote Control for MySQL Mirror Table

Even single-server editions of Handy Backup, along with network editions, have a capability to provide online backup and recovery to create remote server mirroring solutions. You can connect with a MySQL server either by server name or by IP, to move MySQL database mirror to another server

The next instruction will show you how to create a pair of tasks for MySQL database mirroring step by step. Note that this example contains some optional assumptions, e.g., a simplest method of storing a temporary backup dataset in a local folder.

1. Open Handy Backup. Create a new task by calling the New Task Wizard through a button or menu.
2. On the Step 1, select a backup task and go to the Step 2.
3. On the Step 2, double-click on the MySQL plug-in at the "Database" source group on the left.

3. It will show the "Select data…" window. Double-click the string "Create a connection…".
4. Fill up appropriate fields for connecting a MySQL server with a mirror source.
5. Click Test connection to verify your connection, and then click OK.

6. Now double-click on the new connection name, to see a data selection dialog.
7. To select a table for MySQL mirroring, mark a checkbox against its name.
8. When finishing, click OK and return to the Step 2. Click "Next".

10. Select this folder and click OK.
11. Skip the Steps 4 and 5, there is no options in these steps for simple MySQL mirroring.
12. On the Step 6, schedule your task to run with an exact interval between creating mirrors.

Now create a new task as described above, but select a restore task on the Step 1. Go to the Step 2 and find a temporary folder in the "Computer" plug-in. Then follow the next steps:

1. Select a file backup.hbi in this folder. Click "Next".
2. On the Step 3, click onto the "Change Location…" button.

3. Select the "MySQL" plug-in, and create a new server configuration for MySQL mirror.
4. Select this configuration as a new data location for a MySQL mirror database.

5. Click OK, and then click "Next" until the Step 5, where you must schedule your task.
6. Enter starting time and the interval for a recovery task to create a mirror from auto backup.
7. Finally, give your new task a name related to a backup task, which is first in a pair. That is all!

Your MySQL database mirroring tasks are ready for executing. Start them manually at any time you will want.