What Does Replication Mean?
Replication is the continuous copying of data changes from one database (publisher) to another database (subscriber). The two databases are generally located on a different physical servers, resulting in a load balancing framework by distributing assorted database queries and providing failover capability. The server for the subscriber database may be configured as a backup in the event of failure of the server for the publisher database.
Techopedia Explains Replication
When implementing replication, database systems use a variety of methods but use the same concept. If there is a way to frequently copy data from one database to a second, or even to a third version of the same database, two main database administration goals may be achieved: failover capability and load balancing.
After data is distributed between two or more servers, querying users are not required to connect to a primary database. If replication is set up designating the primary database as the publisher, some queries can be redirected to the subscriber. Known as load balancing, this process is useful for databases that have high user traffic.
Replication can also provided failover capability. When data is held on two separate servers, a subscriber can be set up as the default primary if the publisher becomes unavailable.
There are three different replication methods:
