•  

ACIDic Clusters

A session at Fossetcon 2014

Friday 12th September, 2014

2:40pm to 3:20pm (EST)

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. These will be discussed briefly as well.

About the speaker

This person is speaking at this event.
Raghavendra Prabhu

http://wnohang.net/about http://about.me/raghavendra.prabhu Product Lead at @Percona of Galera-based Percona XtraDB Cluster (PXC).

Sign in to add slides, notes or videos to this session

Tell your friends!

When

Time 2:40pm3:20pm EST

Date Fri 12th September 2014

Short URL

lanyrd.com/sddbdd

Official event site

fossetcon.org

View the schedule

Share

See something wrong?

Report an issue with this session