Migrate data to the InfluxDB IOx storage engine
Migrate data to InfluxDB Cloud backed by InfluxDB IOx from other InfluxDB instances backed by TSM including InfluxDB OSS 1.x, 2.x, InfluxDB Enterprise, and InfluxDB Cloud.
- Should you migrate?
- Data migration guides
Should you migrate?
There are important things to consider with migrating to InfluxDB Cloud backed by InfluxDB IOx. The following questions will help guide your decision to migrate.
Are you currently limited by series cardinality?
Yes, you should migrate. Series cardinality is a major limiting factor with the InfluxDB TSM storage engine. The more unique series in your data, the less performant your database. The IOx storage engine supports near limitless series cardinality and is without question, the better solution for high series cardinality workloads.
Do you want to use SQL to query your data?
Yes, you should migrate. InfluxDB Cloud backed by InfluxDB IOx lets you query your time series data with SQL. For more information about querying your data with SQL, see:
Do you depend on a specific cloud provider or region?
You should maybe migrate. InfluxDB Cloud instances backed by InfluxDB IOx are available from the following providers:
- Amazon Web Services (AWS)
- US East (Virginia)
- EU Frankfurt
If your deployment requires other cloud providers or regions, you may need to wait until the IOx storage engine is available in a region that meets your requirements. We are currently working to make InfluxDB IOx available on more providers and in more regions around the world.
Are you reliant on Flux queries and Flux tasks?
You should maybe migrate. Flux queries are less performant against the IOx storage engine. Flux is optimized to work with the TSM storage engine, but these optimizations do not apply to the on-disk structure of InfluxDB IOx.
To maintain performant Flux queries against the IOx storage engine, you need to update Flux queries to use a mixture of both SQL and Flux—SQL to query the base dataset and Flux to perform other transformations that SQL does not support. For information about using SQL and Flux together for performant queries, see Use Flux and SQL to query data.
Data migration guides
Migrate data from TSM to IOx in InfluxDB Cloud
To migrate data from a TSM-backed InfluxDB Cloud organization to an InfluxDB IOx-backed organization, query the data in time-based batches and write the queried data to an IOx bucket in your InfluxDB Cloud organization.
Migrate data from InfluxDB 1.x to IOx in InfluxDB Cloud
To migrate data from a TSM-backed InfluxDB 1.x (OSS or Enterprise) to an InfluxDB Cloud IOx-backed organization, export the data as line protocol and write the exported data to an IOx bucket in your InfluxDB Cloud organization.
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.