How To Understand Galera Replication

Replication and High Availability Strategies
12 November 5:00pm - 5:50pm @ Sentosa 5-8
Experience level: 
50 minutes conference
Galera was conceived from the ground up to be the simplest replication solution possible. And it really is very simple. But it is also very different from traditional replication approaches, and thus may be non-trivial to grasp at first sight. If you looked at Galera replication for MySQL (Percona XtraDB Cluster, MariaDB Galera Cluster), even tried it, and asked one of the following questions, it means you are thinking in terms of old-school MySQL replication or some other replication technology other than Galera: * What happens when the primary node dies? * Does Galera use 2 phase commit? * What happens when a transaction is committed on the master but fails on the slave? * When all nodes have certified the transaction, do they then "approve" the commit back to the master? * How can I setup read-only slaves? * How do I promote another node to master? How does failover happen? * How do I change the number of nodes in the cluster? * If a node is disconnected from the cluster, how can I prevent my application from writing to it to avoid inconsistent slave issues? If you are trying to ask the above questions about Galera, then you should attend this talk - it will help you to make sense out of it all.


Co-Founder, Codership
Alex is the Co-Founder of Codership and started his professional software development career in 2003 at Continuent where he was hooked up on synchronous replication. After that he joined R&D team at Meshcom, Inc learning the ways of mesh networking, embedded SW development and Scrum process management. There he got this crazy idea that running a software company can be fun. In his former life, he held a Masters Degree in Astronomy from SUNY at Stony Brook and worked as a software engineer at Budker Institute for Nuclear Physics.