Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Practical JSON in MySQL 5.7 and beyond

Practical JSON in MySQL 5.7 and beyond

 27 April - 3:00 PM - 3:50 PM @ Ballroom A
Experience level: 
50 minutes conference
Tools and Techniques


In this session, I will discuss some of the practical uses of JSON in MySQL, focusing on version 5.7 but also discussing options for previous versions, and briefly discussing MySQL 8.0. I will discuss several specific use cases, as well as some JSON antipatterns that should be avoided. Some topics I will address: - The evolution of JSON parsing in MySQL: from stored routines to UDFs to native functions - Real-life use cases: Custom fields, flexible rollups, nested objects, etc. - The power of JSON + virtual columns - Storing JSON as text versus using new JSON data types - Read/write balance considerations - Disk storage implications - Indexing JSON documents in MySQL - Additional JSON features in MySQL 8.0


Ike Walker's picture

Ike Walker

Database Architect, GitHub


Ike Walker is a Database Architect at GitHub. He has 16 years of experience with relational databases, and has been working with MySQL since 2006. Ike runs the Boston MySQL meetup, and holds a gold badge for mysql on

Share this talk