Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

Database replication

Sumit Rawal answered on May 20, 2023 Popularity 9/10 Helpfulness 1/10

Contents


More Related Answers

  • Replication
  • Partitioning & Replication:
  • Data Replication:
  • Advantages of database replication:
  • Log Replication
  • Statement based replication#
  • Statement based replication#
  • Logical or row-based replication#

  • Database replication

    0

    Quoted from Wikipedia: “Database replication can be used in many database management systems, usually with a master/slave relationship between the original (master) and the copies (slaves)” [3].

    A master database generally only supports write operations. A slave database gets copies of the data from the master database and only supports read operations. All the data-modifying commands like insert, delete, or update must be sent to the master database. Most applications require a much higher ratio of reads to writes; thus, the number of slave databases in a system is usually larger than the number of master databases. Figure 5 shows a master database with multiple slave databases.

    Popularity 9/10 Helpfulness 1/10 Language sql
    Source: Grepper
    Tags: sql
    Link to this answer
    Share Copy Link
    Contributed on May 20 2023
    Sumit Rawal
    0 Answers  Avg Quality 2/10


    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.