美文网首页
scaling database

scaling database

作者: Zihowe | 来源:发表于2017-08-06 16:53 被阅读9次

Too much load

Replicate the master database, build more slaves database
master can keep up all the writes, slaves can keep up all the reads

downsides:

  • doesn't increase write speed
  • replication lag

Too much data

sharding database

downsides:

  • complex queries ( a range query might hit all of you machines)
  • join is difficult or impossible

Generally, the benefits outweigh the downsides

相关文章

网友评论

      本文标题:scaling database

      本文链接:https://www.haomeiwen.com/subject/ndfnlxtx.html