Mid SQL

Master-Slave Replication (Primary-Secondary):?

  • One database (master) handles all writes, while one or more secondary

databases (slaves) replicate the data for read queries and redundancy.

  • Advantages: Load balancing for read-heavy applications, fault tolerance.
  • Disadvantages: Writes are still a single point of failure.

More from SQL Server Tutorial

All questions for this course