Mid From PDF SQL SQL & Databases

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
Toolliyo Assistant
Ask about tutorials, ebooks, training, pricing, mentor services, and support. I use public site content only—not admin or internal tools.

care@toolliyo.com

Need callback? Share your details