Introduction:​

Today, we're thrilled to unveil a groundbreaking addition to the Voltmetrix platform, set to transform how you interact with your data. Introducing Voltmetrix WaveStream – a powerful, easy-to-use, and cost-effective solution for storing data from any source.

We're building more than just a database. Our vision is a database tailored for data from any source, capable of scaling effortlessly, and offered at a fraction of the cost of other solutions. A database primed for the future of data streaming.

This will lay the foundation for future products and services. It's not just the bedrock of our platform but of our vision for the future.

What is Voltmetrix WaveStream?​

WaveStream is a state-of-the-art NoSQL database. Constructed atop Apache Arrow, a columnar in-memory analytics layer built to supercharge analytical processing and interchange, WaveStream uniquely enables data querying using SQL, even as it stores data in the highly efficient parquet file format. This fusion bridges the best of SQL and NoSQL, marking it a preferred choice for diverse applications.

Key Features so far...​

Here are some pivotal features of WaveStream that we've integrated so far:

• Line Protocol Compatibility: WaveStream supports InfluxDB's line protocol, simplifying data migration and integration with existing InfluxDB tools.

• OpenTelemetry Compatibility: WaveStream embraces OpenTelemetry, a universal standard for gathering telemetry data from cloud-native software.

• SQL Querying: Our solution seamlessly merges SQL querying, marrying the strengths of both SQL and NoSQL databases.

• Efficient Storage: WaveStream entrusts all data to parquet files, a columnar storage format fine-tuned for analytics.

• High Performance: With an amalgam of in-memory and disk storage, WaveStream stands out as a high-performance database. There's no need to load all data into memory anymore.

• Storage Engine: WaveStream capitalizes on Apache Arrow, a columnar in-memory analytics layer aimed at amplifying analytical processing and interchange.

• Storage Tiering: WaveStream's storage tiering allows for differentiated data storage based on requirements. Instead of universally relying on hot storage, data can be delegated to cold storage, thereby trimming costs.

• Data Retention: WaveStream incorporates data retention, enabling automatic data deletion post a stipulated duration.

Availability​

Our journey with WaveStream is just beginning. Preliminary tests hint at performance outpacing other databases, but we acknowledge the extensive road ahead, laden with triumphs, setbacks, and myriad learning opportunities. We envision WaveStream becoming your go-to platform for analytics and data streaming use cases.

Curious about a launch date? We anticipate roughly six months of development before a version becomes available for testing. That positions our trial release around late Q1 of 2024.

Stay in the loop​

Our journey is just kicking off. While WaveStream has miles to cover, we're eager to share this expedition with you. To this end, we've initiated a Google Group for updates on our progress. Feel free to join us here.

Conclusion​

As we continue to evolve and innovate, WaveStream marks a significant milestone in our commitment to delivering exceptional solutions to our valued users. We aim to be a significant player in the data streaming and analytics space, and WaveStream is the first step in that direction.

Introduction:​

Today, is a big day, we're thrilled to unveil an exciting addition to the Voltmetrix platform that is set to revolutionize the way you interact with our services. Introducing Voltmetrix Launchpad – your gateway to a more streamlined, efficient, and powerful user experience.

What is Voltmetrix Launchpad?​

Four months ago when we announced Voltmetrix, we promised to deliver a platform that is intuitive, powerful, and easy to use. With Voltmetrix Launchpad, we're taking that promise to the next level as we announced in the roadmap of Q3. Voltmetrix Launchpad is a web-based interface that allows you to manage your Voltmetrix account and services. You can use Voltmetrix Launchpad to create services, add balance to your account, running resizes, terminate services, and more.

Voltmetrix Launchpad is designed to empower you with enhanced control, visibility, and convenience, making your journey through our platform more intuitive and productive. Whether you're a seasoned user or just getting started, Voltmetrix Launchpad is here to elevate your experience.

Availability​

We're excited to announce that Voltmetrix Launchpad is now available to all our users. Simply log in to your Voltmetrix account and experience the future of platform interaction. You don't need to create a new account, you can use the same credentials that you use to login to the CLI or the API. If you don't have an account yet, you can create one here.

Experience the Next Level of Platform Interaction​

With Voltmetrix Launchpad, we're redefining how you engage with our platform, putting more power and control at your fingertips. Elevate your experience, streamline your tasks, and unlock the full potential of your data-driven initiatives.

What's Next?​

We're just getting started. Voltmetrix Launchpad is the first of many exciting additions to our platform. We're working on a number of new features and enhancements that will be released in the coming months. Stay tuned for more updates.

Conclusion​

As we continue to evolve and innovate, Voltmetrix Launchpad marks a significant milestone in our commitment to delivering exceptional solutions to our valued users. Join us on this exciting journey and discover the limitless possibilities that Voltmetrix Launchpad brings to your fingertips.

Ready to experience the future of platform interaction? Log in to your Voltmetrix account and explore Voltmetrix Launchpad today!

Photo by Luke Chesser on Unsplash

Introduction​

In today's interconnected world, the reliance on data insights for optimizing operations and delivering exceptional user experiences is more critical than ever. Observability, a practice centered around monitoring and analyzing system behavior and performance, has risen as a pivotal tool for ensuring seamless operations across industries. As complexities grow, hosted and managed observability services are emerging as game-changers, offering comprehensive solutions for handling intricate data analysis.

Navigating Complexity with Observability​

Modern systems are intricately woven, with countless interdependencies that can make it exceptionally challenging to detect performance issues in a timely manner. Observability addresses this complexity by providing organizations with comprehensive insights into system behavior. By doing so, it becomes easier to identify bottlenecks, pinpoint areas for improvement, and ensure the overall health of complex systems.

The Power of Managed Observability​

While observability itself is invaluable, the power of managed observability services truly shines. These services take the burden of complexity off organizations by providing specialized tools and the expertise necessary to handle intricate data flows and analyses. This, in turn, empowers businesses to focus on their core activities and strategic initiatives, knowing that the intricacies of data management are in capable hands.

Streamlined Resource Utilization​

Among the many benefits of managed observability is the optimization of resource utilization. In-house management of observability data can be resource-intensive and detract from other vital tasks. With managed services, a team of experts handles data collection, storage, and analysis, allowing businesses to direct their attention and resources toward mission-critical activities.

Instant Insights and Swift Responses​

In today's fast-paced digital landscape, real-time insights are paramount. Managed observability services offer continuous monitoring, which enables prompt responses to anomalies and potential issues. This minimizes downtime, maximizes system efficiency, and helps businesses maintain a high level of operational readiness.

Seamless Scalability​

As businesses grow and evolve, so do their observability needs. Managed observability services offer the advantage of seamless scalability. This means that as your requirements change, whether due to increased demands or shifting priorities, the service can easily adapt to accommodate those changes without the need for extensive reconfigurations or disruptions.

Round-the-Clock Expert Support​

Technical challenges can arise at any hour, and having access to expert support is crucial. Managed observability services provide 24/7 support, ensuring that assistance is readily available whenever it's needed. This not only adds a layer of reassurance but also helps businesses navigate unexpected challenges effectively.

Cost-Efficient Solution​

Building and maintaining in-house observability solutions can be cost-prohibitive. Managed services offer a cost-efficient alternative, often following a subscription-based model. This allows businesses to accurately forecast costs, eliminate surprise expenses, and allocate resources more strategically.

Security and Compliance Assurance​

Observability involves the handling of sensitive data, which underscores the importance of robust security measures. Managed observability services prioritize security and compliance, adhering to industry standards and implementing best practices to safeguard data from potential breaches or unauthorized access.

Conclusion​

In conclusion, managed observability services play a pivotal role in helping businesses navigate the complexities of data analysis and system performance. These services offer a streamlined, expert-driven approach that empowers organizations to optimize resource utilization, gain instant insights, ensure scalability, and foster innovation. At Voltmetrix, we recognize the paramount importance of observability, and our managed services are designed to deliver meaningful insights without the burdens of complex infrastructure management. Contact us today to learn how Voltmetrix can enhance your observability strategy and drive operational excellence.

Elevate your observability strategy with Voltmetrix. Reach out to us today.

Photo by Austin Distel on Unsplash

San Francisco, CA, August 10, 2023

Announcing a Strategic Partnership Between Voltmetrix and Fusion​

Voltmetrix, a leading provider of advanced observability tools, is thrilled to announce a strategic partnership with Fusion, a pioneering technology solutions provider. This partnership, effective as of August 8, 2023, marks a significant step forward in delivering cutting-edge observability solutions to businesses across industries.

Voltmetrix's innovative platform empowers organizations to gain real-time insights into their systems, applications, and infrastructure. With a focus on enhancing system performance, streamlining troubleshooting, and enabling proactive anomaly detection, Voltmetrix has become a trusted partner for businesses seeking to optimize their operations. Fusion, known for its expertise in delivering transformative technology solutions, brings a wealth of experience in implementing and integrating state-of-the-art tools to drive business success. By collaborating with Voltmetrix, Fusion aims to provide its clients with a comprehensive observability solution that ensures operational excellence, improved reliability, and enhanced customer experiences.

"This partnership with Fusion represents a strategic alignment of our shared vision to empower businesses with the best open source tools they need to achieve unparalleled observability," said Sherman Urrutia, CEO of Voltmetrix. "Together, we are dedicated to equipping organizations with the insights necessary to make informed decisions, resolve issues proactively, and drive innovation." "We are excited to join forces with Voltmetrix in this strategic partnership," commented Rodrigo Yañez, CRO of Fusion. "By integrating Voltmetrix's advanced observability capabilities with our expertise in delivering technology solutions, we are poised to deliver unmatched value to our clients, enabling them to thrive in today's dynamic business landscape." Through this collaboration, Voltmetrix and Fusion are set to provide a holistic observability solution that empowers businesses to stay ahead of the curve, enhance operational efficiency, and achieve long-term success. Clients can expect seamless integration, tailored support, and a commitment to innovation that addresses their unique observability needs.

For more information about this partnership and the observability solutions offered by Voltmetrix and Fusion, please visit https://voltmetrix.com and https://fusion.com.ar

About Voltmetrix​

Voltmetrix is a leading provider of advanced observability tools that empower organizations to gain deep insights into their systems, applications, and infrastructure. With a focus on enhancing performance, streamlining troubleshooting, and enabling proactive anomaly detection, Voltmetrix is committed to helping businesses optimize their operations and drive innovation.

For more information, visit www.voltmetrix.com.

About Fusion​

Fusion is a pioneering technology solutions provider that specializes in delivering transformative technology solutions to businesses across industries. With a commitment to innovation and a focus on driving operational excellence, Fusion partners with organizations to implement and integrate cutting-edge tools that enhance efficiency, reliability, and customer experiences. For more information, visit www.fusion.com.ar

Photo by Ian Taylor on Unsplash

Introduction​

Tracking vessels is a crucial aspect of the maritime industry as it provides information about a vessel's position, speed, heading, and more. In this article, we will explore how to track vessels using Voltmetrix.

As someone who is passionate about tracking and fascinated by movement, I decided to track vessels using a public API, store the data in a TimescaleDB database, and visualize it on a map using Grafana.

The API​

For this project, I discovered the [AisStream.io](https:// aisstream.io) API, which offers free access to information about specific Geoboxes or individual vessels. The API is user-friendly; you only need an API Key, which can be generated on their website.

Tracking Choices​

I chose to track vessels in two distinct locations: the port of Buenos Aires, Argentina, and the port of San Francisco, United States. These ports were selected due to their high activity levels and my personal experience visiting them.

The database​

For this project, I opted for TimescaleDB. My familiarity with the database and its integration with PostgreSQL drove this choice. TimescaleDB is a time-series database that builds upon PostgreSQL's capabilities, making it a powerful choice.

To deploy TimescaleDB on Voltmetrix, I followed these steps:

voltmetrix deploy \
--cloud gcp \
--database timescaledb \
--org_id your-org_id \
--token your-awesome-token \
--size e2-small \
--region us-east1

Data visualization​

I selected Grafana for data visualization due to its user-friendly interface and powerful capabilities. To deploy Grafana on Voltmetrix, I executed the following command:

voltmetrix deploy \
--cloud gcp \
--database grafana \
--org_id your-org_id \
--token your-awesome-token \
--size e2-small \
--region us-east1

Once the database and visualization tool are deployed, they need to be connected. To achieve this, create a datasource in Grafana by navigating to the settings, clicking on "Data Sources," selecting PostgreSQL as the database type, and completing the form with the necessary details.

The code​

The code responsible for this project is written in Python and is relatively simple. The code performs two primary tasks: establishing a WebSocket connection to the API and inserting the retrieved data into the TimescaleDB database.

Create a requirements.txt file with the following contents:

asyncio
websockets
json
datetime
psycopg

Then you should have a file called main.py with the following content:

import asyncio
import websockets
import json
from datetime import datetime, timezone
import psycopg as pg
import os

conn_str = f'user=postgres password={os.environ.get("PASSWORD")} host=gcp72ff3b9c2.customers.voltmetrix.io port=5432 dbname=tsdb'

conn = pg.connect(conn_str)

# Create table

create_table_query = '''CREATE TABLE IF NOT EXISTS ais_data (
    ts timestamp with time zone NOT NULL,
    ship_id INTEGER,
    latitude REAL,
    longitude REAL,
    speed REAL,
    heading REAL,
    nav_status TEXT
);'''

conn.cursor().execute(create_table_query)
conn.commit()

# Create hypertable

create_hypertable_query = "SELECT create_hypertable('ais_data', 'ts', create_default_indexes => FALSE);"
conn.cursor().execute(create_hypertable_query)
conn.commit()

# Connect to AIS stream and insert data into timescaledb
async def connect_ais_stream():

    async with websockets.connect("wss://stream.aisstream.io/v0/stream") as websocket:
        subscribe_message = {
            "APIKey": os.environ.get("AISAPIKEY"),  # Required !
            "BoundingBoxes": [
                # Buenos Aires, Argentina
                [[-34.811548,-58.537903], [-34.284453,-57.749634]],
                # San Francisco, USA
                [[36.989391,-123.832397], [38.449287,-121.744995]],
            ],
            "FilterMessageTypes": ["PositionReport"],
        }

        subscribe_message_json = json.dumps(subscribe_message)
        await websocket.send(subscribe_message_json)

        async for message_json in websocket:
            message = json.loads(message_json)
            message_type = message["MessageType"]

            if message_type == "PositionReport":
                # the message parameter contains a key of the message type which contains the message itself
                ais_message = message["Message"]["PositionReport"]
                print(f"[{datetime.now(timezone.utc)}] ShipId: {ais_message['UserID']} Latitude: {ais_message['Latitude']} Longitude: {ais_message['Longitude']} Speed: {ais_message['Sog']} Heading: {ais_message['Cog']} NavStatus: {ais_message['NavigationalStatus']}")
                # Insert data into timescaledb
                insert_query = '''INSERT INTO ais_data (ts, ship_id, latitude, longitude, speed, heading, nav_status) VALUES (%s, %s, %s, %s, %s, %s, %s);'''
                conn.cursor().execute(insert_query, (datetime.now(timezone.utc), ais_message['UserID'], ais_message['Latitude'], ais_message['Longitude'], ais_message['Sog'], ais_message['Cog'], ais_message['NavigationalStatus']))
                conn.commit()

if __name__ == "__main__":
    asyncio.run(connect_ais_stream())

Before running the code, you need to convert the table into a hypertable. For doing that you need to run the following command:

psql -h gcp72ff3b9c2.customers.voltmetrix.io -p 5432 -U postgres -d tsdb -c "SELECT create_hypertable('ais_data', 'ts', create_default_indexes => FALSE);"

Now, you can run the code with the following command:

python3 main.py

If everything goes well, you can see the data in the database. First connect to the database with the following command:

psql -h gcp72ff3b9c2.customers.voltmetrix.io -p 5432 -U postgres -d tsdb -c "Select * from ais_data;"

The result should be something like this:

              ts               |  ship_id  |  latitude  |  longitude  | speed | heading | nav_status
-------------------------------+-----------+------------+-------------+-------+---------+------------
 2023-08-05 14:24:26.800649+00 | 367425230 |  37.781433 |  -122.38651 |     0 |    14.9 | 0
 2023-08-05 14:24:29.347571+00 | 563001700 |   37.39222 |  -123.14578 |   9.5 |   352.4 | 0
 2023-08-05 14:24:29.838122+00 | 538004682 |   37.75017 | -122.344345 |     0 |   201.4 | 1
 2023-08-05 14:24:30.550313+00 | 538009135 |  37.770645 |  -122.35081 |     0 |    23.3 | 1
 2023-08-05 14:24:32.866905+00 | 367085940 |  37.870697 | -122.494446 |   5.9 |   145.4 | 15
 2023-08-05 14:24:33.326184+00 | 366862670 |  37.775505 |  -122.39174 |   0.3 |    50.4 | 0

Now, we can create a dashboard in Grafana to visualize the data. For doing that we need to go to the settings of Grafana and then click on the option "Dashboards" and then click on the button "Manage". Once we are there we need to click on the button "New Dashboard" and then click on the button "Add new panel". Once we are there we need to click on the button "Add query" and then we need to select the database that we created before. Then we need to write the following query:

SELECT ship_id, latitude, longitude, heading, speed, nav_status, ts 
FROM ais_data
WHERE ts >= NOW() - INTERVAL '5 minutes'
GROUP BY ship_id, latitude, longitude, heading, speed, nav_status, ts;

This is sample query that is going to graph in a Map the position of the ships that are in the database. The result should be something like this:

Have in mind that I'm taking the data from the last 5 minutes. That's why you can see the "breadcrumbs" of the ships in the map. If you don't want to see that, you can reduce the time to one minute or less.

The dashboard​

In my case, I created a dashboard with two panels, one watching the data from San Francisco and the other one watching the data from Buenos Aires. The result is the following:

You can notice that I'm using two types of maps, this is only for showing you the two types of maps that you can use. The first one is a map that is using the "Worldmap Panel" plugin and the second one is a map that is using the "OpenStreetMap" plugin that draw maritime routes. You can use the one that you like the most.

Conclusion​

This article provided a comprehensive guide on using Voltmetrix for real-time AIS data analysis. You learned how to create a database, connect to an AIS stream, and insert data into the database using Python. Additionally, you discovered how to create an informative Grafana dashboard for data visualization. I hope this article inspires you to explore the possibilities of Voltmetrix further. If you have any questions, feel free to contact me through social media or our contact form.

Photo by Marek Piwnicki on Unsplash

Introduction​

One of Voltmetrix's main goals is to continuously evolve its platform and improve its services to provide the best experience for its customers. In this article, we will cover the new features and improvements introduced in Voltmetrix Engine v2.2.

The Voltmetrix Engine serves as the heart of our platform. It manages the lifecycle of services deployed within the platform, including provisioning, scaling, and deprovisioning. Additionally, it handles the billing system and access control for the platform.

New Features​

New Cloud Provider: Google Cloud​

As announced a few days ago, Voltmetrix now supports Google Cloud as a new cloud provider. This means you can deploy your services on Google Cloud. For more information about this new feature, refer to this blog post.

Adding Balance to Your Account​

You can now add balance to your account using the CLI. We have partnered with Stripe to provide a secure and straightforward way to add balance to your account. How does it work? It's simple! Just run the following command:

voltmetrix add-balance \
    --org_id <your-org-id> \
    --token <your-access-token>

This command will return a URL that you can use to add balance to your account. Please ensure you use the email address that you have registered on the platform when adding balance. If you use a different email address, the balance will not be added automatically. In that case, please reach out to [email protected] to have the balance added to your account.

Improvements​

Simplified Login​

We have simplified the login process. You can now log in using your email address and password, without the need to provide the organization ID anymore. The new login command looks like this:

voltmetrix login \
    --email <your-email-address> \
    --password <your-password>

Upon successful login, you will receive the org_id and the token, which you can use to interact with the platform.

Conclusion​

At Voltmetrix, we are committed to working hard to enhance our platform and provide the best possible experience to our customers. We hope you enjoy the new features and improvements introduced in this release. If you have any questions or comments, feel free to reach out to [email protected].

Photo by Kirill Tonkikh on Unsplash

Introduction​

The Internet of Things (IoT) has transformed the way we interact with technology, enabling a vast network of interconnected devices that collect, exchange, and analyze data. As IoT adoption continues to grow across industries, businesses are seeking efficient ways to harness the power of IoT without the complexities of managing infrastructure. Hosted and managed services have emerged as a game-changer in the IoT landscape, offering businesses the opportunity to focus on innovation while leaving the complexities of infrastructure management to experts.

In this blog post, we will delve into the importance of hosted and managed services for IoT deployments. We will explore the benefits, challenges, and real-world applications that showcase the value of embracing such services. Let's dive in!

Simplified Deployment and Scalability​

Hosted and managed services for IoT provide businesses with a simplified deployment process. Instead of investing in building and maintaining their infrastructure, organizations can leverage these services to quickly and easily set up IoT solutions. Moreover, these services offer scalability, allowing businesses to expand their IoT deployments as their needs grow, without worrying about infrastructure limitations.

Reduced IT Burden​

By opting for hosted and managed services, businesses can offload the burden of maintaining and managing complex IoT infrastructure. This shift enables organizations to focus on their core competencies and strategic initiatives, leaving the technical aspects to specialized service providers. This reduction in the IT burden allows businesses to optimize resource allocation and better allocate their expertise.

Enhanced Security and Compliance​

Security is a critical concern in the IoT landscape, as interconnected devices create a vast attack surface for potential threats. Hosted and managed services often come with robust security measures and protocols to safeguard data, devices, and applications. Additionally, service providers stay up-to-date with the latest security standards and compliance requirements, ensuring that businesses adhere to regulatory frameworks.

Cost-Efficiency and Predictable Expenses​

By choosing hosted and managed services, businesses can benefit from cost-efficiency. Instead of large upfront investments, they can adopt a pay-as-you-go model, which enables predictable expenses and better cost control. This approach empowers organizations to manage their budgets more effectively and allocate resources strategically.

Continuous Monitoring and Support​

With hosted and managed services, businesses receive round-the-clock monitoring and support. Service providers proactively monitor the IoT infrastructure, identifying potential issues and resolving them before they escalate. This ensures the continuous availability and optimal performance of IoT applications.

Real-World Applications​

To illustrate the significance of hosted and managed services for IoT, let's explore real-world applications where businesses have experienced tangible benefits:

Smart Manufacturing​

In the manufacturing industry, IoT plays a vital role in optimizing production processes and ensuring operational efficiency. With hosted and managed services, manufacturers can seamlessly deploy IoT devices across their facilities, collect real-time data, and analyze it for predictive maintenance and process optimization. This approach enables manufacturers to minimize downtime, reduce maintenance costs, and increase overall productivity.

Smart Cities​

The concept of smart cities relies heavily on IoT technology to improve urban living conditions and enhance public services. Hosted and managed services facilitate the deployment of IoT sensors and devices across a city's infrastructure, such as traffic management, waste management, and public safety systems. This approach enables city authorities to make data-driven decisions, reduce traffic congestion, and improve overall livability for citizens.

Healthcare​

In the healthcare sector, IoT has the potential to transform patient care and medical operations. Hosted and managed services allow healthcare providers to deploy IoT-enabled devices for remote patient monitoring, asset tracking, and medication management. This not only enhances patient outcomes but also streamlines medical workflows and improves the overall efficiency of healthcare facilities.

Conclusion​

Hosted and managed services have emerged as a critical enabler for successful IoT deployments. By simplifying deployment, reducing the IT burden, enhancing security, and providing continuous support, these services empower businesses to unlock the full potential of IoT without the complexities of infrastructure management. From manufacturing to smart cities and healthcare, the real-world applications of hosted and managed services showcase their transformative impact on various industries.

As businesses continue to embrace IoT to drive innovation and gain a competitive edge, the importance of hosted and managed services becomes even more evident. By partnering with experienced service providers, organizations can embark on a seamless IoT journey, focusing on leveraging the data-driven insights and strategic advantages that IoT offers.

At Voltmetrix, we understand the unique challenges that businesses face when implementing IoT, Observability, and Analytics solutions. That's why we offer a comprehensive hosted and managed platform, specifically designed to cater to your IoT needs. Our platform not only provides the infrastructure required for IoT deployments but also ensures continuous monitoring, top-notch security, and expert support.

With Voltmetrix's hosted and managed platform, businesses can accelerate their IoT projects, improve operational efficiency, and unlock valuable insights from their data. Whether you're looking to streamline manufacturing processes, build smart cities, or enhance patient care in healthcare, Voltmetrix is here to support you every step of the way.

In conclusion, hosted and managed services for IoT are not just a convenience; they are a strategic imperative for organizations seeking to harness the true power of the Internet of Things. With Voltmetrix's platform, businesses can confidently navigate the complexities of IoT, Observability, and Analytics, and pave the way for a connected and data-driven future. Let us partner with you on your IoT journey and bring your vision to life.

Photo by Anton Repponen on Unsplash

Introduction​

We are excited to announce the integration of Voltmetrix's platform with Google Cloud! This collaboration brings a new level of IoT, Observability and Data Analytics capabilities to businesses that want to deploy their workloads in this leading cloud provider. In this blog post, we'll explore how Voltmetrix's platform integration in Google Cloud empowers organizations to unlock the full potential of their data and drive actionable insights. Let's dive in!

A Seamless Data Analytics Solution​

Voltmetrix's platform is designed to provide a seamless data analytics solution for businesses. With our support for Google Cloud, you can deploy InfluxDB, TimescaleDB, QuestDB, Grafana, Grafana Loki, and Metabase in this leading cloud provider. Our platform is designed to scale seamlessly in the Google Cloud environment, empowering organizations to leverage the power of data and drive actionable insights.

Unlocking IoT and Time Series Potential​

With Voltmetrix's platform integrated into Google Cloud, businesses can harness the power of IoT and time series data for advanced analytics. The platform provides robust features for ingesting, storing, analyzing, and visualizing time series data, empowering organizations to make data-driven decisions and uncover valuable insights. Leverage Voltmetrix's tools such as InfluxDB, Grafana, Grafana Loki, and more to build scalable IoT and time series solutions within the Google Cloud environment.

Flexible Deployment Options​

Voltmetrix's integration with Google Cloud offers flexible deployment options tailored to businesses' specific needs. Whether you're starting a new project or migrating existing infrastructure, Voltmetrix's platform is designed to scale seamlessly in the Google Cloud environment. Leverage the power of Google Cloud's infrastructure and managed services while benefiting from Voltmetrix's intuitive interface and robust analytics capabilities.

Driving Actionable Insights​

With Voltmetrix's platform integrated into Google Cloud, organizations gain access to advanced data analytics tools and capabilities. By harnessing the power of data, businesses can uncover actionable insights, optimize operations, and drive innovation. Voltmetrix's platform empowers organizations to make data-driven decisions and propel their business forward in today's competitive landscape.

Get Started Today!​

If you're ready to take your data analytics initiatives to new heights, Voltmetrix's platform is the perfect solution. With our support for Google Cloud, you can deploy InfluxDB, TimescaleDB, QuestDB, Grafana, Grafana Loki, and Metabase in this leading cloud provider. Our platform is designed to scale seamlessly in the Google Cloud environment, empowering organizations to leverage the power of data and drive actionable insights. Get started today using our CLI tool:

voltmetrix deploy \
--cloud gcp \
--database metabase \
--org_id your-org_id \
--token your-awesome-token \
--size e2-standard-2 \ 
--region us-east1

One more thing...​

The availability of Voltmetrix's platform in Google Cloud is just the beginning. Also, now, we are part of the Google Partner Program in the level Partner in the Build category Google Cloud Partner Advantage Program. This program is designed to help partners build and grow their Google Cloud business. We are excited to be part of this program and look forward to working with Google Cloud to deliver innovative solutions for our customers.

Conclusion​

The integration of Voltmetrix's platform in Google Cloud marks an exciting milestone in delivering IoT, Observability, and Data Analytics solutions. With seamless integration and a wide range of tools at your disposal, organizations can leverage Voltmetrix's platform to unlock the full potential of their data within the Google Cloud ecosystem. Embrace the power of Voltmetrix's integrated platform and take your data analytics initiatives to new heights in Google Cloud!

Introduction​

At Voltmetrix, we are dedicated to providing our customers with a robust and scalable platform for their data analytics, IoT, and observability needs. To cater to our European customers, we are excited to announce our extensive region support in Europe for deploying InfluxDB, TimescaleDB, QuestDB, Grafana, Grafana Loki, and Metabase. In this blog post, we'll explore the European regions where you can leverage our these data tools and unlock the full potential of your data. Let's dive in!

Our presence in Europe​

When we talk about empowering data, we mean it. Our support for European regions is a testament to our commitment to providing our customers with the best data tools and services. With our extensive region support, you can deploy InfluxDBv1, InfluxDBv2, TimescaleDB, QuestDB, Grafana, Grafana Loki, and Metabase in the following Cloud Providers and regions:

Google Cloud​

Google Cloud is a leading cloud provider that offers a wide range of services, including compute, storage, networking, and more. With our support for Google Cloud our data stack can be deployed in the following regions:

• Europe-North1 (Hamina, Finland)
• Europe-Central2 (Warsaw, Poland)
• Europe-Southwest1 (Madrid, Spain)
• Europe-West1 (St. Ghislain, Belgium)
• Europe-West2 (London, UK)
• Europe-West3 (Frankfurt, Germany)
• Europe-West4 (Eemshaven, Netherlands)
• Europe-West6 (Zurich, Switzerland)
• Europe-West8 (Milan, Italy)
• Europe-West9 (Paris, France)
• Europe-West12 (Turin, Italy)

Amazon Web Services​

• eu-west-1 (Ireland)
• eu-west-2 (London, UK)
• eu-central-1 (Frankfurt, Germany)
• eu-central-2 (Zurich, Switzerland)
• eu-west-3 (Paris, France)
• eu-north-1 (Stockholm, Sweden)
• eu-south-1 ( Milan, Italy)
• eu-south-2 (Spain)

DigitalOcean​

• lon1 (London, UK)
• ams3 (Amsterdam, Netherlands)
• fra1 (Frankfurt, Germany)

Conclusion​

We want you unleash the full potential of your data. Our architecture (API, Control Plane) is capable to deploy the data stack that we offer in any region of the world. Reach out to us to learn more about our region support and how we can help you with your data needs.

Photo by Mathew Schwartz on Unsplash

Introduction​

Are you currently using InfluxDB Cloud and considering a switch to InfluxDB hosted by Voltmetrix? We've got you covered! In this blog post, we'll guide you through the seamless process of exporting your data from InfluxDB Cloud and importing it into InfluxDB hosted by Voltmetrix. This transition ensures uninterrupted access to your valuable data while taking advantage of the advanced capabilities offered by Voltmetrix's managed solution. Let's dive in!

Deploying InfluxDB Hosted by Voltmetrix​

The first thing you need to do is deploy an InfluxDB hosted by Voltmetrix instance. This can be done by following the simple steps outlined below:

voltmetrix deploy \
--cloud aws \
--database influxdbv2 \
--org_id your-org_id \
--token your-awesome-token \
--size t2.small \
--region us-east-1

Once you have deployed your InfluxDB hosted by Voltmetrix instance, change the default password to a strong one according to this guide.

Mirror your InfluxDB Cloud instance​

The next step is to make sure that you have the buckets, with the retention policies, configurations, etc. For this, we going to use a tool called InfluxDB Cloud > Voltmetrix Migration Tool. This tool allows you to export dashboards, buckets, labels, telegraf configurations, alerts, etc. from InfluxDB Cloud and import them into InfluxDB hosted by Voltmetrix.

To use this tool, you need to install the influxdb-client library:

pip3 install influxdb_client

Then, you need to clone the repository:

git clone [email protected]:voltmetrixdotcom/InfluxDB-Cloud-Voltmetrix-Migration-Tool.git

Inside the folder created, you will find a file called values.py. Modify the following parameters:

# Define the source
src_instance = "" # Enter your InfluxDB Cloud URL (Ex: https://us-west-2-1.aws.cloud2.influxdata.com).
src_bucket = "" # Enter the bucket that you want to download data.
src_org = "" # Enter your organization.
src_token = "" # Enter your token and make sure that the token has permission to read the bucket.
src_time = "-2h" # Define how much data you want to export. Can be -1m, -6h, -2d, -30d, etc.

# define the destination
dst_instance = "" # Enter your InfluxDB hosted by Voltmetrix instance. (Ex: https://544657bw2.customers.voltmetrix.io:8086).
dst_bucket = "" # Enter the destination bucket. Needs to be created previously.
dst_org = "" # Enter your organization, this can be your org id or the email address used to register to InfluxDB Cloud.
dst_token = "" # Enter your destination token and make sure that it has permission to write in the bucket.

Once you have the parameters set, you can run the tool by executing the following command:

python3 main.py

A prompt will welcome you and ask what we want to migrate, in this case, it is going to be dashboards, labels, telegraf configurations, alerts, etc., so, we will enter 1 and press enter.

##################################################################
###### Welcome to InfluxDB Cloud > Voltmetrix migration tool #####
##################################################################

I'm going to help you to export your entire stack from InfluxDB Cloud to InfluxDB hosted by Voltmetrix

What do you want to do?

Press 1 to export Dashboards, Labels, Telegraf configuration, alerts, etc.
Press 2 to export data.
Press 99 to do both.

Enter your choice: 1

You will output like this. You need to confirm that you want to export the resources, by typing y and pressing enter.

I'm exporting your resources...
It's done

Now, I'm importing this to your InfluxDB Cloud instance. You need to confirm...
LABELS    +add | -remove | unchanged
+-----+------------------------------+------------------+-----------------------+---------+-------------+
| +/- |        METADATA NAME         |        ID        |     RESOURCE NAME     |  COLOR  | DESCRIPTION |
+-----+------------------------------+------------------+-----------------------+---------+-------------+
|     | agreeing-bartik-80300b       | 074f68a47d2a7000 | experimental          | #BF3D5E |             |
+-----+------------------------------+------------------+-----------------------+---------+-------------+
+-----+------------------------------+------------------+-----------------------+---------+-------------+
|     | beautiful-matsumoto-403011   | 0722670a30759000 | inputs.net            | #326BBA |             |
+-----+------------------------------+------------------+-----------------------+---------+-------------+
|                                                                                  TOTAL  |     2      |
+-----+------------------------------+------------------+-----------------------+---------+-------------+

BUCKETS    +add | -remove | unchanged
+-----+----------------------------+------------------+-------------------+------------------+-------------+
| +/- |       METADATA NAME        |        ID        |   RESOURCE NAME   | RETENTION PERIOD | DESCRIPTION |
+-----+----------------------------+------------------+-------------------+------------------+-------------+
|     | pensive-ardinghelli-803001 | 29acb10e1026c604 | covid             | 0s               |             |
+-----+----------------------------+------------------+-------------------+------------------+-------------+
+-----+----------------------------+------------------+-------------------+------------------+-------------+
|     | practical-matsumoto-803009 | 4b6a833c119ea6b7 | public-count      | 0s               |             |
+-----+----------------------------+------------------+-------------------+------------------+-------------+
|                                                                                TOTAL       |      2      |
+-----+----------------------------+------------------+-------------------+------------------+-------------+

CHECKS    +add | -remove | unchanged
+-----+---------------------------+------------------+---------------+-------------+
| +/- |       METADATA NAME       |        ID        | RESOURCE NAME | DESCRIPTION |
+-----+---------------------------+------------------+---------------+-------------+
|     | hardcore-zhukovsky-c03001 | 074f68a482e63000 | memory km-usa |             |
+-----+---------------------------+------------------+---------------+-------------+
|                                                          TOTAL     |      1      |
+-----+---------------------------+------------------+---------------+-------------+

DASHBOARDS    +add | -remove | unchanged
+-----+--------------------------+----+-----------------+--------------------------------+------------+
| +/- |      METADATA NAME       | ID |  RESOURCE NAME  |          DESCRIPTION           | NUM CHARTS |
+-----+--------------------------+----+-----------------+--------------------------------+------------+
| +   | tasty-ramanujan-403001   |    | COVID19         |                                | 57         |
+-----+--------------------------+----+-----------------+--------------------------------+------------+
|                                                                     TOTAL              |     1      |
+-----+--------------------------+----+-----------------+--------------------------------+------------+

TELEGRAF CONFIGURATIONS    +add | -remove | unchanged
+-----+------------------------+----+--------------------------+-------------+
| +/- |     METADATA NAME      | ID |      RESOURCE NAME       | DESCRIPTION |
+-----+------------------------+----+--------------------------+-------------+
| +   | pedantic-cerf-403007   |    | K8S Configuration        |             |
+-----+------------------------+----+--------------------------+-------------+
+-----+------------------------+----+--------------------------+-------------+
| +   | zealous-wescoff-803001 |    | Fortnite Telegraf config |             |
+-----+------------------------+----+--------------------------+-------------+
|                                              TOTAL           |      2      |
+-----+------------------------+----+--------------------------+-------------+

VARIABLES    +add | -remove | unchanged
+-----+-------------------------------+------------------+---------------+-------------+----------+-------------------------------------------------------------+
| +/- |         METADATA NAME         |        ID        | RESOURCE NAME | DESCRIPTION | ARG TYPE |                         ARG VALUES                          |
+-----+-------------------------------+------------------+---------------+-------------+----------+-------------------------------------------------------------+
+-----+-------------------------------+------------------+---------------+-------------+----------+-------------------------------------------------------------+
|     | sleepy-tharp-003013           | 0722670a3a61b000 | linux_host    |             | query    | language="flux" query="import                               |
|     |                               |                  |               |             |          | \"influxdata/influxdb/v1\"\nv1.measurementTagValues(bucket: |
|     |                               |                  |               |             |          | v.bucket, measurement: \"cpu\", tag: \"host\")"             |
+-----+-------------------------------+------------------+---------------+-------------+----------+-------------------------------------------------------------+
|                                                                                         TOTAL   |                              1                              |
+-----+-------------------------------+------------------+---------------+-------------+----------+-------------------------------------------------------------+

LABEL ASSOCIATIONS    +add | -remove | unchanged
+-----+---------------+-------------------------------+-------------------+------------------+---------------------------+-----------------------+------------------+
| +/- | RESOURCE TYPE |      RESOURCE META NAME       |   RESOURCE NAME   |   RESOURCE ID    |    LABEL PACKAGE NAME     |      LABEL NAME       |     LABEL ID     |
+-----+---------------+-------------------------------+-------------------+------------------+---------------------------+-----------------------+------------------+
|     | buckets       | amazing-driscoll-803005       | env-fn_bucket     | 38f0e3e744b18055 | objective-williams-c03003 | fortnite              | 074f68a47e6a7000 |
+-----+---------------+-------------------------------+-------------------+------------------+---------------------------+-----------------------+------------------+
|                                                                                                                                  TOTAL         |        1         |
+-----+---------------+-------------------------------+-------------------+------------------+---------------------------+-----------------------+------------------+

Confirm application of the above resources (y/n): y

If everything is ok, you will see the following message:

stack ID: 075eced136149000
You're ready to roll!

Start to write data to your InfluxDB Hosted by Voltmetrix instance​

To ensure a clean migration, one step is to start doing dual write. This means that you will write data to both InfluxDB Cloud and InfluxDB hosted by Voltmetrix. This will allow you to ensure that new data is written in the new instance.

Exporting the historical data from InfluxDB Cloud​

Now that we have the new data pumped into InfluxDB hosted by Voltmetrix, we can start to export the historical data from InfluxDB Cloud. We are going to use the same tool that we use to move dashboards, but now, we are going to export data.

Exporting data​

Let's run the tool once again...

python3 main.py

A prompt will welcome you and ask what we want to migrate, in this case data, so, we will enter 2 and press enter.

##################################################################
###### Welcome to InfluxDB Cloud > Voltmetrix migration tool #####
##################################################################

I'm going to help you to export your entire stack from InfluxDB Cloud to InfluxDB hosted by Voltmetrix

What do you want to do?

Press 1 to export Dashboards, Labels, Telegraf configuration, alerts, etc.
Press 2 to export data.
Press 99 to do both.

Enter your choice: 2

That will start the process of exporting the data to a CSV file. The tool will show you the progress of the export.

Downloading bucket `telegraf` to exported.csv

When the download is done, You will be asked to confirm the data upload to your InfluxDB hosted by Voltmetrix instance.

The size of the file is: 0.6846990585327148 MB
Do you want to continue: y/n: y

The following message will be shown:

Uploading the data can take some time depending on the size of your file: 0.68 MB

When the upload is done, you will see the following message:

Done, go to your instance https://544657bw2.customers.voltmetrix.io:8086, log in, and explore the bucket, you should see the information there.

Starting now, you can begin to query the data in your InfluxDB hosted by Voltmetrix instance.

Verifying and Testing​

Once the import process is complete, it's crucial to verify the successful transfer of your data. Perform data integrity checks, run queries, and validate the results to ensure the accuracy and completeness of the imported data. This step helps in ensuring a smooth transition and a seamless continuation of your analytics and observability workflows.

If you have more than one bucket, you need to repeat the process for each bucket.

Enjoy the Benefits of InfluxDB Hosted by Voltmetrix​

Congratulations! You've successfully exported your data from InfluxDB Cloud and imported it into InfluxDB hosted by Voltmetrix. Now, you can take advantage of the powerful features and benefits offered by Voltmetrix's managed InfluxDB solution. Benefit from enhanced performance, scalability, reliability, and simplified management, allowing you to focus more on extracting meaningful insights from your data.

Support​

If you need help with the migration process, please contact us at [email protected]. We will be happy to help you.

Conclusion​

Migrating your data from InfluxDB Cloud to InfluxDB hosted by Voltmetrix is a straightforward process that ensures uninterrupted access to your valuable data while leveraging the benefits of a managed solution. By following the steps outlined in this blog post, you can seamlessly transition to Voltmetrix's platform and unlock the full potential of your time-series data. Start your journey today and experience the power of InfluxDB hosted by Voltmetrix!