Oct 27, 2016
  All Things Open 2016
   Alexander Rubin

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.


About the Author

Alexander Rubin

Alexander joined Percona in 2013. Alexander worked with MySQL since 2000 as DBA and Application Developer. Before joining Percona he was doing MySQL consulting as a principal consultant for over 7 years (started with MySQL AB in 2006, then Sun Microsystems and then Oracle). He helped many customers design large, scalable and highly available MySQL systems and optimize MySQL performance. Alexander also helped customers design Big Data stores with Apache Hadoop and related technologies.