去哪儿网数据库架构变迁v1

1、去哪儿网数据库架构变迁技术创新，变革未来Qunar数据库总监Oracle ACE（MySQL）ACMUG主席团成员目录去哪儿MySQL架构 对Galera集群的疑问 Galera架构Galera复制写集Galera的并发控制Galera有啥坑？ 架构升级终极架构3mQmhaGaleraGalera Cluster introduction集群化大趋势何谓galera cluster?高一致，低延迟，多点写入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架构升级架构再升级三思！大规模MySQL运维陷阱之基于MyCat的伪分布式架构分享终极架构理论及需求Redo并行复制弹性扩缩容秒级快照备份存储与计算彻底分离(具有分布式弹性扩容的SSD)节省资源(一台机器即可部署)分布式(现阶段最流行的做法)分布式高可用复