{"id":146,"date":"2014-05-04T16:48:13","date_gmt":"2014-05-04T11:18:13","guid":{"rendered":"http:\/\/blog.wnohang.net\/?p=146"},"modified":"2014-12-29T00:30:32","modified_gmt":"2014-12-28T19:00:32","slug":"slides-plmce-2014-breakout-session","status":"publish","type":"post","link":"https:\/\/blog.wnohang.net\/index.php\/2014\/05\/04\/slides-plmce-2014-breakout-session\/","title":{"rendered":"Slides from PLMCE 2014 breakout session"},"content":{"rendered":"Reading Time: <\/span> 2<\/span> minutes<\/span><\/span>

As many of you already know, PLMCE<\/a> is an annual MySQL
\ncommunity conference and Expo organized by Percona in the month of April
\n(usually). It is a great conference, not only to meet new and eminent people in
\nMySQL and related database fields, but also to attend interesting talks, and
\nalso to give some.<\/p>\n

This year I spoke about synchronous replication at a higher level. The talk was
\ntitled “ACIDic Clusters: Review of current relational databases with synchronous replication”<\/a>. Having previously given talks with boring titles (but interesting content), this time I decided to go with an interesting title, and it seemed to fit well with topic being discussed.
\n<\/p>\n

In short, the talk was about ACID-compliant databases supporting relational
\nsemantics (essentially, SQL) while providing synchronous replication. The talk
\nwas not about why we need all three in a database, but it was on why some of
\nthem may depend on each other. In this review, I looked at various aspects and
\nfeatures of databases like Galera\/PXC, MySQL NDB, Google F1 and FoundationDB,
\nwhile also discussing the topic of synchronous replication and its family in
\ngeneral.<\/p>\n

One of my primary motivations for this talk was so that people truly understand
\nwhat they are using, specifically in my case, the product that I manage\/develop
\n– Percona XtraDB Cluster (PXC), based on Galera replication. There are plenty
\nof misconceptions on what a synchronous replication needs to be, and what it
\ndoesn’t, and on the overheads\/latencies associated with them. It was also
\ninteresting learning how other systems like F1\/Spanner are built, and how they
\nhandle latencies for instance or have constraints like atomic clocks. The issues
\nassociated with transactions involving optimistic concurrency control than
\npessismistic locking are also interesting to look at.<\/p>\n

Here are the slides of the talk:<\/p>\n