I'm trying to design a big IoT solution of millions of devices starting from zero.
That's why I need a highly scalable platform like AWS.
My devices are going to report data using AWS IoT, and that's the only thing I've
really decided. I need to store a lot of data like a temperature measure every 15 minutes
on each device so for that measures I've planned to insert those measures directly to
DynamoDB using IoT Rules, but on the other side, I need a relational structure to store
companies, temperature sensors, etc. So I thought I could store that in MySQL RDS.
After that, I need to configure a proper analysis tool, so I was thinking of Kinesis and
load the data from Redshift after ETL using Data Pipeline since AWS
https://goo.gl/n2qNUi
Glue doesn't support DynamoDB.
I'm new with some of the services so I don't know exactly what I'm doing and I
don't know if this approach is the best one. What do you think?.