展开查看详情
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
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
10.Demo Recap…
100% Cloud IoT
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
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.
22.Bug fixed, please enjoy your MySQL toast...
