Backup Software / Features / Database Backup Software / MySQL Backup / Mirror MySQL Database
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.
Version 8.2.1, built on 15 January 2021 112 MB
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.
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.
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.
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.
Version 8.2.1, built on 15 January 2021. 112 MBBackup Software from Novosoft LLC. 249 USD per license.
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!
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:
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!
To mirror a MySQL database, you must backup and then restore tables automatically. Please watch the following video example, to learn how easily and quickly you can create a MySQL mirror with Handy Backup software!
Note: To recover a backup as a MySQL mirroring base, please create a recovery task in an advanced mode. Then, on Step 3, please click "Change Location" and select another MySQL server for recovering tables as a mirror.
Try Handy Backup to create your own MySQL server mirroring solutions! Download a newest version now for a 30-day free trial!
Copyright © 2004-2021 Novosoft LLC. All rights reserved. Handy Backup software.10685-B Hazelhurst Dr., Houston, TX 77043, United States Tel.: +1 (707) 703-13-11
Back to Top