Strategies for Migrating from On-Premises FusionAuth to FusionAuth Cloud

wesley

We're in the process of transitioning from an on-premises FusionAuth instance to FusionAuth Cloud. Our current database is MySQL, but since the cloud version supports only PostgreSQL, we can't perform a straightforward export and import of configurations. We've been advised to use API calls to retrieve data from the old instance and push it into the new one. However, the process has been more time-consuming than anticipated due to the need for custom migration scripts. Are there any tools or strategies that could accelerate this, including ways to migrate our MySQL database to PostgreSQL?

wesley

There are a few approaches and tools you can consider to streamline this migration process:

Database Migration Tools:
Tools like pgloader can help automate the migration of your MySQL database to PostgreSQL.
- Be aware that direct database migration carries risks. Corrupt or incomplete data may not surface immediately, and issues could arise months later. To mitigate this, test the migration extensively and consider working with third-party experts if needed.
API-Driven Migration:
While using API calls for migration can be time-consuming, it ensures the data integrity FusionAuth requires. Automating this process with scripts and batching requests may help speed up the operation.
Terraform for Configuration Migration:
Terraform can simplify the configuration migration process by treating your infrastructure as code. This approach allows you to standardize and automate the setup of configurations in your new FusionAuth Cloud environment. It’s especially useful for managing tenants, applications, and other configurations consistently.

Important Note:
If you choose to use a database migration tool, proceed with caution:

Verify the migrated data thoroughly to ensure it matches FusionAuth’s schema and expectations.
FusionAuth cannot provide support for issues caused by manual database manipulation or corruption.

Combining API-driven data migration for sensitive information with Terraform for configuration and a reliable database migration tool can significantly reduce the time and effort required for this migration.