Friday 12th September, 2014
2:40pm to 3:20pm
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
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.
- 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
- 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
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. These will be discussed briefly as well.
Sign in to add slides, notes or videos to this session