important
This is a contributors guide and NOT a user guide. Please visit these docs if you are using or evaluating SuperTokens.
Restoring API/Saas related DBs using automated backups
#
Database - Development API Server- get the latest automated backup of the production server db
- use restore snapshot option
- make sure while restoring, the db instance type, security groups and all other configuration (including the root password) are same as the old db cluster
- update the route 53 entry related to this db (dev-mysql.supertokens.dns)
- once the restoration is finished, update the following:
- development node api server config
- restart development node api server containers
- remove old cluster
#
Database - Production API Server- get the latest automated backup of the production server db
- use restore snapshot option
- make sure while restoring, the db instance type, security groups and all other configuration (including the root password) are same as the old db cluster
- update the route 53 entry related to this db (production-mysql.supertokens.dns)
- once the restoration is finished, update the following:
- production node api server config
- db configuration on retool site
- db configuration on metabase site
- restart production node api server containers
- remove old cluster
#
Database - API Saas DB (saas users db used to store active users)- get the latest automated backup of the saas db
- use restore snapshot option
- make sure while restoring, the db instance type, security groups and all other configuration (including the root password) are same as the old db cluster
- update the route 53 entry related to this db (production-saas-users-mysql.supertokens.dns)
- once the restoration is finished, update the following:
- production node api server config
- restart production node api server containers
- remove old cluster
Restoring Saas users' containers related DBs using automated backups
#
Database - Saas Postgresql DB (any region)- get the latest automated backup of the saas db
- use restore snapshot option
- make sure while restoring, the db instance type, security groups and all other configuration (including the root password) are same as the old db cluster
- once the restoration is finished, update the db cluster info in api server production DB (table: aurora_servers)
- find and restart all the containers which are associated with the old cluster (which is being replaced)
- remove old cluster