Qualitypoint Technologies
http://qualitypointtech.net/forum/

What is MySQL replication?
http://qualitypointtech.net/forum/viewtopic.php?f=14&t=8562
Page 1 of 1

Author:  karthika [ Fri Jul 01, 2016 7:56 am ]
Post subject:  What is MySQL replication?

MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database.

MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in synchronize.

This can helpful for many reasons including facilitating a backup for the data,a way to analyze it without using the main database, or simply as a means to scale out.

Replication enables data from one MySQL database server (the master) to be copied to one or more MySQL database servers (the slaves).

Replication is asynchronous by default; slaves do not need to be connected permanently to receive updates from the master. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.

There are two core types of replication format, Statement Based Replication (SBR), which replicates entire SQL statements, and Row Based Replication (RBR), which replicates only the changed rows. You can also use a third variety, Mixed Based Replication (MBR).

Replication is controlled through a number of different options and variables.

This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

Advantages of replication in MySQL:
Analytics - live data can be created on the master, while the analysis of the information can take place on the slave without affecting the performance of the master.

Data security- it is possible to run backup services on the slave without corrupting the corresponding master data.

Author:  KarenJain [ Thu Oct 20, 2016 11:27 am ]
Post subject:  Re: What is MySQL replication?

MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database.

Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/