1、Qunar数据库总监Oracle ACE(MySQL)ACMUG主席团成员Qunar mysql architecturequestions to galera clustergalera architecturegalera Write-Setgalera concurrency controlinside galera gcachedoes galera cluster have many problems?galera cluster is slow? really?3mQmhaGaleraGalera Cluster introductionArchitecturemulti-mast
2、ersynchronous replicationNo replication relayconcurrency controlswitch over as willstate transfer automaticallyso-easy for dbamore or lessArchitectureServergalera APIgalera logicgalera messagenetworkArchitectureGalera Write-SetGalera Write-SetGalera Write-Setwhy to certificate?what is certificating
3、failure?two Write-Sets come from different nodestwo Write-Sets have the same keysthe older GTID is invisible to new transactionGalera Write-Setlocal certification, replicate, which first? any questions?how to deal with certification failure?and execution ?Galera Concurrency Controlwrite-set replicat
4、ionwrite-set local certificationwrite-set slave applywrite-set commitInside Galera Gcachedefinitionfunctionstate transferwhat size to setinfluencetheoryHAHave 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架构升级架构再升级终极架构