Replication Server

Replication server is a server that is configured to act either as a source of data for other servers (Master Server), or to receive data from the central server (Slave Server). Replication configuration enables you to improve performance of your applications, increase data security, distribute data geographically, and much more.

It is important to understand difference between replication servers and cluster servers. All clustered servers are supposed to share the same configuration and act as one, while replication servers can be different. Furthermore, in many situations it is recommended to set up Slave Servers differently than the Masters, so when applications interact with the database, they can choose an appropriate server for each task.

A lot of server software – particularly, database management software like MySQL or MS SQL – come with the replication feature out of the box. Database replication is based on tracking all modifications made to the Master Server, and performing identical operations on Slaves, asynchronously or in real time. Before enabling replication, you need to synchronize the Master and all Slaves: this is where Handy Backup comes into play. Our software lets you easily back up databases hosted on the Master Server, and then restore it to Slave Servers. To learn more, please see MySQL Replication.

Handy Backup Small Server

Version 7.9.2, built on 13 July, 2017. 65.8 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup Small Server

Setting up replication servers requires you to synchronize two databases first. You can do it for MySQL, Oracle, MS SQL and other DBMS with the help of the Small Server edition of our software. Try free for 30 days!

Using Replication Servers for Backup

A common difficulty with backing up databases is that database management systems significantly slow down when exporting large sets of data. This is where replication comes into play: you can set up a replication server and distribute the roles so that the Master Server handles all writing operations and the Slave Server is used for reading and backups.

Another thing that you may want to do to a replication server is change its storage engine. For example, in MySQL there is a general purpose engine called InnoDB which is ACID-compliant, supports transactions and is used by default, and MyISAM which is not transaction-safe and lacks many important features, but excels in data retrieval tasks. A common MySQL Backup scenario includes setting up a Slave replication server, changing the storage engine of all tables to MyISAM, and then using it for backups. To learn more, please see MySQL Backup.

Video Example

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.

Replication and Recovery

Recovering Master database after a data loss event requires you to change your Slave Server to act as a Master (so the application continues working), restore the Master, and then change the configuration back. Recovery scenario is specific to each database management system, but there is a common recommendation that can be used in all cases:

  • It is recommended to have dynamic DNS names for each replication server, and use the respective host name in your replication configuration. This enables you to quickly change Master and Slave servers by means of DNS software, which can save a lot of time and efforts.

To learn about recovering MySQL databases, please refer to MySQL Recovery.

Version 7.9.2, built on 13 July, 2017
65.8 MB

See also:

See all terms from Databases...

Backup Terms Glossary

Contact Us

support@handybackup.net

Term of the Day

  • Compact Flash
    “ Compact Flash (also CF, CompactFlash) is a solid-state flash memory card unit, somewhat bulkier but sturdier than more popular...”

Backup Software 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 227 terms. The current section Databases contains 18 terms.

Other “Databases” Terms

  • Primary Key in a Database
    “Primary key is a characteristic of values stored in a database table that allows using these values to uniquely address records to which they belong...”
  • Shared-Nothing Architecture
    “Shared-nothing architecture (SNA) is a pattern used in distributing computing in which a system is based on multiple self-sufficient nodes that have...”
  • MySQL Slave Server
    “MySQL Slave Server is a server in MySQL replication configuration that continuously tracks all modifications of the Master Server’s database...”

Who uses our backup software?