Data loss is an error condition in information systems. This can occurs when valuable and sensitive information on a computer is compromised due to theft, human error, viruses, malware, or power failure.
Data backup is one of the method to prevent data loss and it is the process of copying or archiving of data to another location for the purpose of being able to restore them in case of data loss.
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.