Synchronizing MySQL databases
Backup Software / Features / MySQL Synchronization
Handy Backup is a professional data backup and synchronization software with an advanced MySQL Backup feature that lets you dump your databases into readable text files.
MySQL synchronization is a process of making two MySQL databases having identical contents. It’s a general idea that is realized differently in clustering, replication and other applications.
Basically, there are two types of synchronization:
Learn more about MySQL Backup.
Version 7.15.0, built on 10 July, 2018
MySQL clusters are built of several MySQL servers (SQL nodes) that are configured in such a way that all storage, processing and management operations are shared amongst all of them.
The storage engine used in all tables is called Network DataBase (NDB): it’s an in-memory engine which tracks changes made to any clustered server and automatically synchronizes all other servers, so at any time they have identical contents.
Synchronization in a MySQL cluster is performed automatically and doesn’t require any additional setup. It is important to remember that having a cluster does not remove the need for backups.
Clustering enables you to increase the database’s speed and availability, but it doesn’t protect from SQL injections and user mistakes. For instance, if you accidentally delete a table in one database, it will be deleted on all clustered servers too.
Version 7.15.0, built on 10 July, 2018. 164 MBBackup Software from Novosoft LLC. 249 USD per license.
To take advantage of the MySQL backup and recovery functions, you need the Small Server edition of our small business backup solutions. Try it for 30 days free of charge!
Unlike clustering, MySQL replication configuration doesn’t expect all nodes to share one in-memory storage engine and be synchronized all the time.
On the opposite, it is often recommended to set different storage engines for different servers, and distribute the roles so that one of them processes all INSERTs and UPDATEs, while the others handle all reading operations.
The reason for assigning different server roles is that storage engines perform much slower under concurrent reads and writes. Replication is a built-in feature of the database management system, in which synchronization of MySQL servers is made differently than through common SQL updates.
It is based on analyzing changes made to the Master database and reproducing them on the Slaves.
When trying to synchronize MySQL databases, the replication engine doesn’t verify that they are identical, which can lead to unexpected errors. A common approach to setting up replication is to take a full backup of the Master Server and restore it on the Slave Servers.
Handy Backup can be helpful in two aspects: it provides a fast way to perform the operation, and also creates very understandable backup files (database dumps) that can be modified by hand, which lets you easily change storage engine for your Slave Servers.
To learn more, please refer to MySQL Replication.
There is an interesting approach that enables you to backup and synchronize MySQL databases very quickly by simply stopping the DBMS and copying its binary files to a different place.
This method is often referred to as physical backup, because it doesn’t work with the database’s programming interfaces, but treats it as common HDD files.
For many businesses the cost of a downtime of several minutes may result in huge losses, and this is another situation where MySQL replication proves its worth. An example scenario of combining replication and “cold” backups could be as follows:
Among other powerful features, Handy Backup can run third-party scripts and applications prior to and after running backup tasks. In the above scenario, this function can be used to stop the MySQL server and run it after the copying is complete.
As it’s been said above, synchronization of MySQL databases can’t replace backups. The recommended way to set up automated backup of your MySQL databases is to use one of the business editions of our software.
Try MySQL Backup in Small Server and Server Network editions - 30 days trial!
To see pricing on these and other editions of our software, please refer to the Order section.
In the following video tutorial you can find how to back up and restore a MySQL database with Windows version of Handy Backup.
Download and install our software today - making your first backup will only take two minutes!
Our utility lets you back up and synchronize your MySQL databases quickly and hassle free!
Loading comments, please wait...
+1 (707) 703-13-11
Upgrade to version 7
See all volume order prices
2018/07/10 - Version 7.15: The New S3 Plug-in and Mixed Incremental Type
2018/06/27 - Version 7.14: Updated E-mail and Database Plug-ins
Cloud Synchronization Tools - read how you can apply different types of cloud synchronization
Medical Data Backup - learn about making backups of medical data with MySQL Server
Auto MySQL Backup - read about different features of our software that you may find useful when backing up MySQL
Database Backup - how to protect databases with different Database Backup plug-ins
MS SQL Server Backup - check out how to easily back up data of Microsoft SQL
Oracle Backup - learn how our software backs up and restores Oracle databases
MariaDB Backup Tool - enjoy automatic MariaDB backup with our software
© Vladimir Vaschenko
Copyright © 2004-2018 Novosoft LLC. All rights reserved. Handy Backup software.
United States, P.O.Box 535, Louisville, OH 44641 Tel.: +1 (707) 703-13-11
Back to Top