1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Benefits of a Master/Slave System?

Discussion in 'Databases' started by liamwli, Jul 18, 2013.

0
  1. #1
    I've been researching master/slave systems but I can't find anything definitive on the benefits and drawbacks of using them.

    Maybe some people here can enlighten me?
     
    liamwli, Jul 18, 2013 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,333
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    The short version is it allows read scalability... since you can have (for example) 10 slave DB servers which can all handle reads. You are still bottlenecked with writes though, and *normally* you still have a single point of failure with the master server. You can build a system for failover, but it's not inherent normally.

    If you want both read *and* write scalability (as well as automatic redundancy), you would need a setup where any slave could also handle writes.

    We use MySQL Cluster for this site, which allows us to scale the database out pretty linearly.

     
    digitalpoint, Jul 18, 2013 IP
    liamwli, ryan_uk and NameNetwork like this.