Mirror MySQL Database to another Server

MySQL Mirroring Solutions

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.

Download Handy Backup

Version 8.0.6, built on 2 October, 2019
105 MB

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

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.

Your OneDrive backup task is ready for executing. Start it manually at any time you will want, or wait for a scheduled period or event to run it automatically. You can also create tasks using OneDrive as backup source, with selecting and configuring OneDrive access at the Step 2 instead of the Step 3.

Recommended Solution

Handy Backup Small Business

Version 8.0.6, built on 2 October, 2019. 105 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup Small Business

The ultimate edition for a single server, the Small Business solution is capable for MySQL mirroring out of the box, utilizing local and online MySQL server connections and storage!

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!

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!

Video Tutorial: MySQL Mirroring

In the following video tutorial you can learn how to back up and restore MySQL databases with Handy Backup software.

Note: Instructions in this video suggest that you already have Handy Backup installed on your computer.

Download Handy Backup

Version 8.0.6, built on 2 October, 2019
105 MB

Try Handy Backup to create your own MySQL server mirroring solutions!
Download a newest version now for a 30-day free trial!

0 comments

    Who uses our backup software?