MySQL Replication on Linux

MySQL replication on Linux is an important task for several users, as the growing world of Linux actively includes MySQL data in many individual and commercial applications. To cope with this growing demand, Handy Backup has two different mechanisms of using MySQL replication on Linux computers.


Trivia

MySQL replication on Linux using Handy Backup has no principal differences with this action undertaken from Windows-based machine. The MySQL feature will help equally in both cases. These are some considerations that may be noted before you will attempt to organize MySQL replication on Linux machine.

  • Format compatibility. MySQL files and folders are not specific for particular operating system, as these files and folders have no attributes and can be moved from one OS to another without restrictions. See the next note for reading advanced information about backup compatibility between different SQL servers.
  • Statement-based backups. MySQL backups take a form of SQL statements giving MySQL server all necessary information for creating databases from zero when you restore it. So if a particular MySQL database engine has some unique traits, just re-write SQL statements to meet all requirements.
  • Overall stability. Network-based editions of Handy Backup have native clients for Linux (see below), guaranteeing stability when you attempt MySQL replication on Linux. Standalone editions can be executed under Wine (or some more complex Windows emulator such as VirtualBox), and this may compromise a stability of task execution.

Running MySQL Replication on Linux Using Wine

Wine is a popular Windows emulator among Linux users, and, typically, Handy Backup can be run as Windows application under Wine without an effort. To use MySQL replication on Linux-based computer when Handy Backup is executed under Wine, just use the MySQL feature for organizing replication, as Handy Backup was started under Windows.

Note: Both Linux and Wine are open-source programs subjected to unexpected modifications and changing of features. As a result, sometimes you can’t process some data or use some Handy Backup’s functions correctly under Wine. It is a matter of Wine compatibility only, not a fault of Handy Backup! Using Windows software on Linux machine, be patient for slight inconsistencies and hope for a better future, anywhere.


MySQL Replication on Linux Distros Installed on Network Machines

Another way of organizing MySQL replication on Linux machines is using specialized Linux client named Network Agent for Linux, available with Handy Backup for Workstations. Currently, these Network Agents are designed for Red Hat/Fedora-type distros (.rpm package) and Debian/Ubuntu-based distributives (.deb package), making a mainstay of modern Linux world.

No source codes for Network Agents are available, as Handy Backup is a proprietary utility; this policy completely excludes native setup of Network Agent on Gentoo. For other distros with exotic packages such as YAST, you can contact with Handy Backup tech supporting crew; a popular package manager can be utilized in future for re-packing Network Agents under its format.

To make MySQL replication on Linux using Network Agent, select the machine with installed MySQL server from the Management Panel and then run all the necessary operations for replication (according to User Manual) on this machine.

See also:

See all terms from Databases...

Backup Terms Glossary

Contact Us

support@handybackup.net

sales@handybackup.net

Read More

Windows 7 Backup - learn about backing up Windows 7 files and folders

Windows 8 Backup - learn how the software works with common Windows data and Microsoft technologies

MySQL Login Scripts

Who uses our backup software?