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 managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master’s Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.
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