ACIDic Clusters: Review of current relational databases with synchronous replication

Replication and High Availability Strategies
2 April 1:20PM - 2:10PM @ Ballroom C

Experience level: 
Intermediate
Duration: 
50 minutes conference
ACIDic Clusters: Review of current relational databases with synchronous replication. ===================================================================== This talk reviews database clusters of our time which employ synchronous replication while being ACID compliant. ACID compliance implies ability to support transactions across nodes. As part of this talk, PXC (Percona XtraDB Cluster)/Galera, Google F1 based on Spanner/CFS and MySQL Cluster will be considered. Primary objective here is to expound features of each in order to highlight differentiating factors and commonality between them. They will be reviewed on following aspects: a) Architecture: The layering that exists between different subsystems, external dependencies (like CFS in case of F1), geographical awareness. b) Relational nature: To what extent are each of these relational. Do they also support NoSQL features? How relational are they wrt. MySQL/SQL. - In addition, any APIs supported will be discussed. c) Degree of synchronicity: Synchronous replication, as we are familiar with, taxes the latency of a cluster. There are various strategies employed by each/some of them to obviate this latency. These will be discussed. - Closely related is the issue of Quorum and how it is established and preserved in cases of split-brain. d) Ease of transition: This is for those who are using MySQL async replication and want to switch to a synchronous replication. Main issue here is the amount of work required and associated changes in architecture. Architecture discussed earlier (in #a) will be recalled again. e) Sharding - Not all of them support sharding. Though sharding is not an essential requirement of a synchronous cluster, there are use cases where it may be useful, hence will be discussed. f) Operational usage; This will deal with aspects of day-to-day operation such as backup and restore, high availability mechanisms. Integration with other HA systems will also be discussed. g) Limitations: No system is without limitations. It is the these limitations which help while choosing a product to fit into higher scheme of things given above factors. These will be discussed briefly as well.


Speakers

Software Engineer, Percona
Biography: 
Raghavendra Prabhu is the Product Lead of Percona XtraDB Cluster (PXC) at Percona. He joined Percona nearly 2 years ago. Before joining, he worked at Yahoo! SDC at Bangalore for 3 years as Systems Engineer, primarily dealing with databases (MySQL). Raghavendra's main interests include databases and operating systems, specifically linux kernel. He also likes to contribute and has contributed code upstream to several FOSS projects — for more details on that visit http://wnohang.net/code. In his spare time, he likes hacking code, reading books on his kindle DX, playing games over PC and rest of the time spending time over IRC.