Time series data visualization
Over the years, our R&D team has worked with different kind of databases ranging from MS SQL to FirebirdSQL to MongoDB. Recently we have flexed our data storage competency and added a new genre of databases, the time series ones. Time Series Databases are perfect for data visualization platforms as it is built specifically for handling events, measurements or metrics that are time stamped and are tracked, monitored and aggregated over time.
We had mentioned about Grafana development , a data visualization platform for our industrial monitoring solutions in one of our earlier blogs. We were on the scout for a good time-series database that could handle large time-series data for Grafana. Our search ended at InfluxDB, an open source time-series database which provided the perfect ally to Grafana and was pretty robust to setup and deploy. Influx does have an UI to add database if we install the .deb package. InfluxDB provides both cloud and downloadable versions and is flexible enough for complex deployments; it certainly ticked most of our IOT development team’s boxes.
We also tried to migrate few of our existing systems running in MongoDB to InfluxDB in industrial monitoring applications. Though there were some challenges few and far between, especially handling the multi-level management. But we guess that was sorted out soon and the transition was complete. One good thing about InfluxDB we noted was that it does have a real time access out of the gate and quickly identify the patterns and find value for your data. We could add more visualization instances in one of our dashboards, and while we earlier used sleepy mongoose REST interface, InfluxDB programming allowed us the luxury of connecting it directly to our live graph chart.
InfluxDB programming for sensor data
InfluxDB has a powerful engine that can handle data coming through our large IoT deployments. It supports millions of writes per second and with the help of native clustering, all single points of failure are eliminated and users can get faster & accurate real-time values. It can accept data via HTTP, TCP or UDP protocols.
Having trouble in managing millions of data churned out by the sensors? Are you struggling to find a good visualization solution for your machine data? We at Ripples IOT might just have a perfect solution for you. For more info, click here