Migrate from Self-Hosted SigNoz to SigNoz Cloud
Why Migrate to SigNoz Cloud?
Migrating to SigNoz Cloud offers a range of benefits that enhance your monitoring and observability experience:
Simplified Management: By moving to the cloud, you eliminate the need for manual updates, scaling, and maintenance, ensuring a hassle-free experience.
Scalability: SigNoz Cloud automatically adjusts to your growing data needs, ensuring that you can scale up or down effortlessly without worrying about infrastructure limitations.
Security and Compliance: The cloud version provides enhanced security features and compliance with industry standards, giving you peace of mind when it comes to data safety.
High Availability and Reliability: Enjoy the benefits of cloud infrastructure's built-in redundancy and uptime guarantees, ensuring your monitoring setup is always available.
Access to New Features: Get access to the latest SigNoz features and updates automatically with no need to worry about migrations.
Steps to Migrate from Self-Hosted SigNoz to SigNoz Cloud
If you're using your own OpenTelemetry Collector agent that forwards data to SigNoz self-hosted, you need to update both the endpoint and add the ingestion key.
1. Update Your OTel Collector Configuration
In your OpenTelemetry Collector configuration file (usually config.yaml
), update the exporters section:
exporters:
otlp:
endpoint: https://ingest.<region>.signoz.cloud:443
headers:
signoz-ingestion-key: <your-ingestion-key>
Replace:
2. Restart Your Collector
Restart your OpenTelemetry Collector to apply the new configuration.
Migrate Dashboards & Metadata
Regardless of your setup, you'll need to migrate your dashboards and configurations:
- SigNoz support will handle the migration of your metadata, including dashboards, alerts, views, pipelines, users, and other configurations from your self-hosted instance to the cloud.
- To begin the migration, provide the SQLite DB file from your self-hosted SigNoz instance. This can typically be found in the location where your SigNoz instance stores the database (usually
/path/to/sigNoz/database.db
). - Compress the SQLite DB file and send it to SigNoz support. Our team will manually import the necessary data from selected tables to ensure a smooth migration of your metadata.
- Once the process is complete, you will have all your dashboards and metadata in SigNoz Cloud, ready for use.
Verify Migration
- Confirm that data is flowing to SigNoz Cloud
- Verify all dashboards and metadata have been migrated correctly by checking your cloud tenant.
Estimate SigNoz Cloud bill
To estimate your SigNoz Cloud bill on the basis of your SigNoz Self-Hosted usage, follow the steps below:
- Truncate your usage tables:
truncate table signoz_metrics.usage on cluster cluster;
truncate table signoz_metrics.usage on cluster cluster;
truncate table signoz_logs.usage on cluster cluster;
Restart your SigNoz OTel collectors
Keep on running and ingesting normal volumes for over 24hrs
Now connect to ClickHouse
Follow this documentation
Run below queries to get dump of usage tables:
The below query retrieves all records from the signoz_logs.usage
table into a CSV file named logs_usage.csv
with column names as headers.
SELECT *
FROM signoz_logs.usage
INTO OUTFILE 'logs_usage.csv'
FORMAT CSVWithNames
The below query retrieves all records from the signoz_traces.usage
table into a CSV file named traces_usage.csv
with column names as headers.
SELECT *
FROM signoz_traces.usage
INTO OUTFILE 'traces_usage.csv'
FORMAT CSVWithNames
The below query retrieves all records from the signoz_metrics.usage
table into a CSV file named metrics_usage.csv
with column names as headers.
SELECT *
FROM signoz_metrics.usage
INTO OUTFILE 'metrics_usage.csv'
FORMAT CSVWithNames