Mirror MySQL Database to another Server

MySQL mirroring is an operation that creates an identical MySQL mirror table on other server than that where is a table or database origin. Often, the basic requirement is a real time server mirroring without stopping an instance from working. Handy Backup allows automating the MySQL mirroring actions.

Small Windows Logo Download for Free

Version 8.5.8 , built on October 31, 2024. 118 MB
30-day full-featured trial period

MySQL Mirroring Solutions

Creating MySQL Mirror Database with Handy Backup: Advantages

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.

Protected MySQL Mirroring

Protected MySQL Mirroring

Automatic creation of a MySQL mirror database uses a temporary vault for "dump" files, where Handy Backup stores data content during real time server mirroring. To protect such stored content, you can use internal or external encryption, dedicated vaults like S3 cloud solutions or SFTP/FTPS, etc.

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

Professional Software for Backup to Clouds & Other Storages

+ External and Local HDD, WebDAV, USB, Network

How to Mirror a Database in Handy Backup Using the "MySQL" Plug-in

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.
Creating a Configuration for MySQL Backup
  1. It will show the "Select data…" window. Double-click the string "Create a connection…".
  2. Fill up appropriate fields for connecting a MySQL server with a mirror source.
  3. Click Test connection to verify your connection, and then click OK.
 MySQL plug-in file system
  1. Now double-click on the new connection name, to see a data selection dialog.
  2. To select a table for MySQL mirroring, mark a checkbox against its name.
  3. When finishing, click OK and return to the Step 2. Click "Next".
Selecting the MySQL plug-in as storage destination
  1. Select this folder and click OK.
  2. Skip the Steps 4 and 5, there is no options in these steps for simple MySQL mirroring.
  3. On the Step 6, schedule your task to run with an exact interval between creating mirrors.

Restoration of a MySQL Mirror Table

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.
Selecting MySQL restore locations
  1. Select the "MySQL" plug-in, and create a new server configuration for MySQL mirror.
  2. Select this configuration as a new data location for a MySQL mirror database.
Changing MySQL restore paths
  1. Click OK, and then click "Next" until the Step 5, where you must schedule your task.
  2. Enter starting time and the interval for a recovery task to create a mirror from auto backup.
  3. 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.

Creating a "Physical" MySQL Mirror Database

In some cases, the method described above takes too much time to run. In this case, you can make a synchronization task, which will synchronize content between the two MySQL folders. This is a "cold-mode" technique, so stop and then restart a server before and after this type of a task!

Features of Handy Backup for working with MySQL

Who uses Handy Backup?