Suggest an editImprove this articleRefine the answer for “What is replication in SQL?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)**Replication** in SQL is the process of copying data from one database server to another: it's used to improve reliability (data survives on the copy if the primary server fails), spread the load (the primary server handles writes, copies handle read requests), and speed up access (users in different regions can reach the nearest replica). **Key point:** there are usually two types - **synchronous replication** (changes are written to the replica immediately, slower but safer) and **asynchronous replication** (data is saved on the primary server first and then copied over, faster but with a possible delay).Shown above the full answer for quick recall.Answer (EN)Image**Replication** in SQL is the process of copying data from one database server to another. It's used to: - **improve reliability**, if the primary server fails, the data survives on the copy; - **spread the load**, the primary server handles writes, while the copies (replicas) handle read requests; - **speed up access**, users in different regions can reach the nearest replica. There are usually two types: - **Synchronous replication**, changes get written to the replica immediately (slower, but safer). - **Asynchronous replication**, data is saved on the primary server first and then copied to the replica (faster, but with a possible delay). Replication helps a database run faster, more reliably, and more safely.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.