Mirror MySQL Database to another ServerMySQL 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. Free Download Version 8.4.5, built on March 14, 2023 ![]() Creating MySQL Mirror Database with Handy Backup: AdvantagesHot ActionsHandy 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 MirroringAutomatic 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 TableEven 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-inThe 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. Recommended Solution![]() Version 8.4.5, built on March 14, 2023. 116 MB Handy Backup Small BusinessThe 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 TableNow 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:
![]()
![]()
Creating a "Physical" MySQL Mirror DatabaseIn 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 MySQLMySQL Mirroring Trivia: VideoTo 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. Free Download Version 8.4.5, built on March 14, 2023 Try Handy Backup to create your own MySQL server mirroring solutions! |
0 comments