NoSQL with MySQL
Simple, fast, and scalable for certain workloads, key-value storage systems are becoming increasingly popular for internet services that require high availability and massive growth. Key-value stores can be implemented many ways, with relational database backends as a serious contender.
The Amazon Dynamo paper is truly inspirational. A similar system can be implemented as an orchestration layer on top of a key-value database (e.g., Berkeley DB), a fixed schema in a relational database (e.g., InnoDB), or a hand-rolled database. Regardless of the underlying database technology, key-value systems must include an API layer (Get, Put, Delete, etc.) and business logic such as vector clocks and read repairs. Relational databases are a proven technology and offer valuable features for key-value storage systems such as read-committed data, write-ahead logs, indexing, compression, etc. And by standardizing on relational database technology, expertise may be leveraged across both key-value and non-key-value systems.
The “NoSQL” movement is typically related to key-value systems and, lacking a formal definition, can be interpreted many ways. NoSQL discussions that focus on availability and scalability highlight ACID issues but not really SQL. These issues can be addressed in the orchestration layer separate from the underlying database technology.
This talk discusses the use of relational databases in large-scale key-value storage systems. It maintains that relational databases are a good fit and makes the larger point that the same technology and expertise can be leveraged across both key-value and non-key-value systems.
Distinguished Architect, Nokia
Peter co-founded Percona in 2006, assuming the role of CEO. Percona is the only company that delivers enterprise-class solutions for both MySQLⓇ and MongoDBⓇ across traditional and cloud-based platforms. Percona has been on the Inc. 5000 list of fastest growing companies since 2013. Back in 2000s Peter was an early employee at MySQL AB, eventually leading the company’s High Performance Group. A serial entrepreneur, Peter co-founded his first startup while attending Moscow State University where he majored in Computer Science.
As CEO of Percona, Peter enjoys mixing business leadership with hands on technical expertise. Peter is co-author of High Performance MySQL published by O’Reilly, one of the most popular books on MySQL performance. Peter blogs regularly on Percona Performance Blog and speaks frequently at conferences all over the world. Peter lives in North Carolina with his wife and two children. In his spare time, Peter enjoys travel and spending time outdoors.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts