Internet of things

1 .

2 . About Me Alexander Rubin, Principal Architect, Percona • Working with MySQL for over 10 years – Started at MySQL AB, Sun Microsystems, Oracle (MySQL ConsulDng) – Joined Percona in 2013 

3 .

4 . Level of Light Every plant comes with one – a liOle plasDc label tucked into the pot with an icon on it that lets you know what level of light it needs. 

5 .Cost ($35 +) Size Need to add Wifi module 

6 .Particle Photon $19 hOps://store.parDcle.io 

7 .Intel Edison ~$60 hOp://www.intel.com/ content/www/us/en/ do-it-yourself/ edison.html 

8 .WiFi Module - ESP8266 $6 hOps:// www.sparkfun.com/ products/13678 

9 .Particle Demo… 

10 .Demo Recap… 100% Cloud IoT 

11 .console.parDcle.io 

12 .Measurement Results… 

13 . Storing data in MySQL: wide table CREATE TABLE `sensor_wide` ( `id` int(11) NOT NULL AUTO_INCREMENT, `light` int(11) DEFAULT NULL, `temp` double DEFAULT NULL, `humidity` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 + Storage is good - Alter table is a hard, not flexible 

14 . Storing data in MySQL: key/value CREATE TABLE `cloud_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `data` varchar(255) DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11106 DEFAULT CHARSET=latin1 + Flexible - High overhead on storage 

15 . Storing data in MySQL 5.7: JSON store CREATE TABLE `event_stream_json` ( `doc` json DEFAULT NULL, `_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$._id'))) STORED NOT NULL, `name` varchar(255) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.name'))) VIRTUAL, UNIQUE KEY `_id` (`_id`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 + Very Flexible + indexes - Some overhead on storage 

16 .Edison Demo… 

17 .

18 .http://bugs.mysql.com/bug.php?id=2 [12 Sep 2002 5:26] Mark Matthews Description: Other JDBC drivers I have used make toast for breakfast. MySQL Connector/J doesn't make toast, it can only pour a bowl of froot loops. When I ask it to make toast, the "NoToast" exception is thrown. I think you should look into this. 

19 .Fixing MySQL Bug#2 

20 .

21 .

22 .Bug fixed, please enjoy your MySQL toast...