分布式数据库设计及反范式设计

2020-02-27 82浏览

  • 1.h"p://Weibo.com/caoz0h"p://web.4399.com/job0
  • 2.• – – – – • – • – • –
  • 3.• – – – • i/o • – 3000 – 1500 – 300 –
  • 4.• – • – • – • • • – – – i/o
  • 5.• – • – • i/o • • – • •
  • 6.• – • • • – • • • – – – • amoeba
  • 7.• – • • – • • – • – Sync-binlog, innodb_flush_log_at_trx_commit
  • 8.• – • – A • – B,C,D – D – • A,B,C • D1,D2,D3 • d1,d2,d3
  • 9.• – • – • • – • • – • •
  • 10.• – – • – – • • – • ip
  • 11.• – – • – – – – • – – i/o
  • 12.• – – – – • fromuid,touid,msg,dateline • fromuname,fromusex
  • 13.• – 1 • • – 2 • • id – – uid, uname,upass, email,qq,intro,….. uname,uid – key,keytype,uid • – gameid uid
  • 14.• – count, sum – – • • – • Select count(*) from gamescore where score>’$score’ • • Redis zset
  • 15.• i/o – • i/o • – • • – – – pk top refer top url
  • 16.• – – – – i/o • – – – • – i/o
  • 17.
  • 18.
  • 19.