去哪兒網(wǎng)數(shù)據(jù)庫架構(gòu)變遷v1

1、去哪兒網(wǎng)數(shù)據(jù)庫架構(gòu)變遷技術(shù)創(chuàng)新，變革未來Qunar數(shù)據(jù)庫總監(jiān)Oracle ACE（MySQL）ACMUG主席團(tuán)成員目錄去哪兒MySQL架構(gòu) 對Galera集群的疑問 Galera架構(gòu)Galera復(fù)制寫集Galera的并發(fā)控制Galera有啥坑？ 架構(gòu)升級終極架構(gòu)3mQmhaGaleraGalera Cluster introduction集群化大趨勢何謂galera cluster?高一致，低延遲，多點(diǎn)寫入Architecturemulti-mastersynchronous replicationNo replication relayconcurrency controlswitch ov

2、er as willstate transfer automaticallyso-easy for dbamore or lessServergalera APIgalera logicgalera messagenetworkArchitectureArchitectureGalera Write-SetGalera Write-SetGalera Write-Setwhy to certificate？what is certificating failure？two Write-Sets come from different nodestwo Write-Sets have the s

3、ame keysthe older GTID is invisible to new transactionGalera Write-Setlocal certification, replicate, which first? anyquestions?how to deal with certification failure？and execution ?Galera Write-SetGalera Concurrency Controlwrite-set replicationwrite-set local certificationwrite-set slave applywrite

4、-set commitdefinitionfunctionstate transferwhat size to setinfluencetheoryHAInside Galera GcacheHave many problems?DDL result in whole cluster hang ？DDL result in deadlock？how to cancel DDL execution？flow controlBig TranscationGalera cluster slow? really?galera concurrency controllocal certificationwait GTIDsynchronous replicationmulti node write架構(gòu)升級架構(gòu)再升級三思！大規(guī)模MySQL運(yùn)維陷阱之基于MyCat的偽分布式架構(gòu)分享終極架構(gòu)理論及需求Redo并行復(fù)制彈性擴(kuò)縮容秒級快照備份存儲(chǔ)與計(jì)算徹底分離(具有分布式彈性擴(kuò)容的SSD)節(jié)省資源(一臺機(jī)器即可部署)分布式(現(xiàn)階段最流行的做法)分布式高可用復(fù)