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.5.0 , built on September 19, 2023. 116 MB
30-day full-featured trial period
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
+ External and Local HDD, WebDAV, USB, Network
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.
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:
Your MySQL database mirroring tasks are ready for executing. Start them manually at any time you will want.
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!