MySQL Master Server
Backup Software / Backup Terms Glossary / Databases / MySQL Master Server
MySQL Master Server is a server in MySQL replication configuration that hosts Master Database and acts as a primary source of data. Whenever a website or a MySQL-driven application adds new rows and update existing records on the Master Server, all changes are automatically reproduced on one or several Slave Servers.
In MySQL, there are two main types of replication:
Since MySQL replication is based on change log, it is required to synchronize Master Server and Slave Server databases before running it. This can be made with the help of Handy Backup: simply back up your MySQL Master database, restore it to MySQL Slave – and then you can start it. To learn more, please refer to MySQL Replication.
Version 7.17.0, built on 14 September, 2018. 164 MBBackup Software from Novosoft LLC. 249 USD per license.
To back up your MySQL servers you need the MySQL Backup plug-in which is available in small business server backup edition of our software. Download it right now, and try free for 30 days!
MySQL Master Server and MySQL Slave Server are not required to be set up similarly. Furthermore, there are applications in which they need to have different configurations. Particularly, it is recommended to make Slave Server read-only, and use it as a source of data for backups, while leaving all writing and processing to the Master Server. The logic is as follows:
With all things considered, the idea of assigning different roles to MySQL Master and Slave servers becomes very clear.
In the following video tutorial you can learn how to back up and restore MySQL databases with Handy Backup.
Note: Instructions in this video suggest that you already have Handy Backup installed on your computer. If you still haven’t done so, don’t hesitate to download it.
Handy Backup provides an easy way of changing storage engine to set up a replication configuration. When you create a backup of your Master database, it is created as a dump file, i.e. a complete set of SQL commands that need to be run to re-create all data on an empty server. Format of the backup is human-readable and can be modified without fear. Specifically, you can find the CREATE TABLE statements and supplement them with ENGINE=MyISAM. When you restore this backup, the respective tables will have MyISAM as a storage engine. To learn more, please see MySQL Backup Software.
Version 7.17.0, built on 14 September, 2018
See all terms from Databases...
Backup Terms Glossary
Current glossary explains various terms that you may come across while working with Handy Backup or other backup software.
Handy Backup is a backup utility for Windows Servers and PCs that is famous for its flexibility and ease of use.
The glossary contains 192 terms. The current section Databases contains 18 terms.
© 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