A BUSINESS ORGANIZATION WHO WANTS TO SET UP A HIGH AVAILABILITY FAILOVER SYSTEM
A MySQL replication server can maintain a near real-time secondary database to which applications can switch with minimal downtime if the primary site fails. MySQL replication protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby. In case of a failure the takeover by the standby database can be carried out quickly since the standby database server is already up and running.
WHO USES MySQL REPLICATION AND WHY?
A BUSINESS ORGANIZATION THAT WANTS TO BUILD A DISTRIBUTED SYSTEM
Data distribution is a tool that helps companies put necessary data in the hands of local decision-makers yet maintain irm central control over the data. With MySQL replication, data can be shared and replicated between databases, allowing system designers to put the data where it is needed.
A BUSINESS ORGANIZATION THAT WANTS TO HAVE ADDITIONAL BACKUP STRATEGY
In conjunction with backup, MySQL replication strategies seek to complement traditional approaches by providing alternative levels of data protection and integrity, while minimizing user disruptions. Replication creates a point-in-time copy of the data to be used as the backup source.