Oct 27, 2016
All Things Open 2016
TIME SERIES DATA, IOT (LIVE DEMO) & MYSQL
In this presentation I will talk about 1. Using Internet of Things (IoT) with MySQL 2. Storing time series data in MySQL and MongoDB. I’ve will do a live demo of using IoT sensors and storing time series data in MySQL and MongoBD (I will also demonstrate the smallest MySQL server in the world). After that I will discuss how to store time series in MySQL and typical challenges (i.e. how to store raw metrics efficiently) and data optimization technics: optimize for writes or for selects, summary tables and more. We will discuss storing time series data as a classic relational tables (name-values or value as field) as well as storing it as JSON object in MySQL 5.7.