Replication is a set of technologies for copying and distributing data from one database server to another server and then synchronizing between databases to maintain consistency and avoid data loss
Master Slave :Master/slave or primary/replica is a model of communication where one device or process has unidirectional control over one or more other devices. In some systems a master is selected from a group of eligible devices, with the other devices acting in the role of slaves.
Multi Master : Multi-master replication is a method of database replication which allows data to be stored by a group of computers, and updated by any member of the group.
Queries (involving relation R) can be continued to be processed in spite of the failure of one site.queries (involving relation R) can be continued to be processed in spite of the failure of one site.
The sites containing relation R can process queries (involving relation R) in parallel This leads to faster query execution.
The more replicas of, a relation are there, the greater are the chances that the required data is found where the transaction is executing and reduces movement of data among sites & increases speed of processing
Optimize workload distribution across multiple computing resources, making them individually more resilient to activity spikes that would otherwise cause slowdowns and other disruptions
System’s ability to avoid loss of service by minimizing downtime. It’s expressed in terms of a system’s uptime, as a percentage of total running time as 99.999% uptime.
Ensuring that all the information and data in a business that could have been lost is recovered from site Backup & database replications so as to assist in future needs.