Tell me something about master and slave? Replication and it's working

Question

Accepted Answer

Master and slave are terms used in database replication. Master is the primary database and slave is a copy of it.

Master database is the primary database that is used for read and write operations.
Slave database is a copy of the master database that is used for read-only operations.
Replication is the process of copying data from one database to another.
Replication can be one-way or two-way.
In one-way replication, changes made to the master database are copied to the slave database.
In two-way replication, changes made to either the master or slave database are copied to the other database.
Replication can be synchronous or asynchronous.
In synchronous replication, changes made to the master database are immediately copied to the slave database.
In asynchronous replication, changes made to the master database are copied to the slave database at a later time.
Replication can be used for load balancing, disaster recovery, and reporting purposes.

Popular interview questions of MS SQL DBA