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?
  • Are you currently limited by series cardinality?
  • Do you want to use SQL to query your data?
  • Do you depend on a specific cloud provider or region?
  • Are you reliant on Flux queries and Flux tasks?
• 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:

• Query data with SQL
• InfluxDB SQL reference

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