MySQL Forums
Forum List  »  InnoDB clusters

FOSDEM2019: MySQL and the CAP theorem: relevance & misconceptions
Posted by: Edwin Desouza
Date: February 04, 2019 11:32AM

https://fosdem.org/2019/schedule/event/mysql_cap/

MySQL and the CAP theorem: relevance & misconceptions
Dissecting, affirming and refuting CAP assumptions in real production systems.

The CAP theorem is often used to describe the tradeoffs of available versus consistent systems. But the CAP theorem is often misunderstood and misrepresented. In this session we investigate the CAP properties of various MySQL replication setups, and show that it is impossible to claim a setup is AP or that it is CP. We will see how the properties can be non binary, and change across time, geography and workload. We will also observe where CAP's terms can be made irrelevant. This session takes the practical engineer's perspective and shows how we can gain the upper hand with reasonable tradeoffs.

video:
https://ftp.heanet.ie/mirrors/fosdem-video/2019/UA2.118/mysql_cap.webm

slides:
https://speakerdeck.com/shlominoach/mysql-and-the-cap-theorem-relevance-and-misconceptions-d277c84b-230e-4429-a7cf-16c31330b3ed

Options: ReplyQuote


Subject
Views
Written By
Posted
FOSDEM2019: MySQL and the CAP theorem: relevance & misconceptions
233
February 04, 2019 11:32AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.