Database Migration

Databases, like other PaaS objects, cannot be automatically migrated to a different type of SDN, but they can be recreated in the new network.

Before starting the DB migration in the project:

1. Perform the network infrastructure migration, if it has not been done yet.
2. Perform the balancer migration.
3. Update the public DNS A-records.
4. Put the DB in read-only mode, or stop all applications with write permissions to this database.

To migrate the database to the Sprut SDN:

1. Create a DB snapshot. You can also perform a backup using the pg_dump program or other built-in DB backup tools.
2. Restore the DB from the backup in the new network.
3. (Optional) Configure the network connectivity of virtual machines with the source and restored databases using the advanced router, so that applications do not lose access to the DB during migration.
4. Configure the connection using the new address in the applications working with the migrated DB.
5. (Optional) Start the applications working with the migrated DB, if you stopped them before starting the DB migration.
6. Make sure that the migration was successful.
7. Delete the source database if you no longer need it.