FusionAuth
    • Home
    • Categories
    • Recent
    • Popular
    • Pricing
    • Contact us
    • Docs
    • Login

    How are database migrations handled for FusionAuth Cloud instances?

    Scheduled Pinned Locked Moved Solved
    Frequently Asked Questions (FAQ)
    cloud saas upgrade database migration
    1
    2
    197
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • F
      FASupportBot
      last edited by

      I noticed a new FusionAuth release (1.70.0) requires a database migration to be run out of band. For FusionAuth Cloud (SaaS) instances, how are these database migrations handled?

      Do customers need to:

      • Run the migrations manually through the FusionAuth UI?
      • Execute them via command line or API?
      • Or are they automatically applied by the FusionAuth Cloud team during upgrades?

      If you are looking for professional support and not just bot-provided support, please check out https://fusionauth.io/pricing and pick a plan that fits your needs.

      1 Reply Last reply Reply Quote 0
      • F
        FASupportBot
        last edited by

        For FusionAuth Cloud (SaaS) instances, database migrations are automatically applied as part of the upgrade process. You do not need to take any action.

        The FusionAuth Cloud team handles all required database migrations when upgrading your hosted instance to a new version. This is managed on your behalf as part of the cloud service. When you initiate an upgrade through your FusionAuth Account dashboard, the migrations run automatically during the upgrade process.

        For HA Cloud (multi-node) deployments, nodes are upgraded one at a time. When the first upgraded node connects to the database, it locks the database and runs the required migrations while other nodes continue serving traffic, resulting in only seconds of downtime.

        For Basic/Business Cloud (single-node) deployments, the entire instance goes offline during the upgrade, with downtime ranging from 5 to 60 minutes depending on the amount of data and schema changes required.

        If you are running a self-hosted FusionAuth instance, you would need to follow the upgrade guide and apply any required out-of-band migrations manually (or configure Silent Mode for automatic migrations). However, for cloud-hosted instances, this is handled automatically by FusionAuth.

        Note: You cannot downgrade a FusionAuth Cloud deployment version after upgrading, so it's recommended to test upgrades in a non-production environment first if possible.

        Related Documentation

        • FusionAuth Cloud - Upgrading a Deployment - Details on the Cloud upgrade process and downtime expectations
        • Upgrade FusionAuth - Upgrade Options - Overview of different upgrade strategies including HA deployments
        • Out-of-Band Database Upgrades - Information on manual migrations for self-hosted instances
        • Silent Mode - Automatic migration handling for self-hosted deployments

        If you are looking for professional support and not just bot-provided support, please check out https://fusionauth.io/pricing and pick a plan that fits your needs.

        1 Reply Last reply Reply Quote 0
        • danD dan has marked this topic as solved
        • danD dan moved this topic from Staged
        • First post
          Last post