Practical Tips for Using MySQL as a Scalable Key-Value Store

Trends in Architecture and Design
23 April 11:30am - 12:20pm @ Ballroom G

These days, it seems like all the "cool kids" are using trendy NoSQL solutions for data storage. Unfortunately, many of these solutions come with relaxed transaction, durability and recovery guarantees. In this presentation, we provide tips for using MySQL efficiently to provide SQL functionality and reliability with NoSQL design and performance. We begin by reviewing a flexible key-value schema design, including optimization techniques such as schema extraction and row-level data compression using binary JSON and LZF, efficient versioning, and data access techniques to avoid the perils of UUID-randomized table access. Since Key-Value storage is seldom enough for real-world applications, we also take a look at optimization techniques for range queries and secondary indexes, materialized aggregations (think: counters and drill-downs) and full-text integration.


Sunny Gleason
Founder, SunnyCloud
Sunny Gleason is founder and Distributed Systems Engineer at SunnyCloud, a company providing high-performance application development and hosting and high-availability distributed storage solutions using Amazon Web Services, Rackspace, and Google Compute Cloud. Previously, he worked on cloud platform system design and implementation at and Ning. LinkedIn: Twitter: GitHub: