Backups in the form of database dumps of our relational databases happen every day (usually between 12 AM and 1 AM CET/CEST). The backups will be created on the database replica server to prevent load impacts on the primary instance.
The dumps will be stored on our dedicated backup storage and kept there for 7 days (previously 30 days). Every database on our shared PostgreSQL or MariaDB Cluster get this backup strategy.
Additionally and upon request we can provide Point-In-Time-Recoverability for dedicated databases. For our shared PostgreSQL cluster PITR is available by default. Restore Points are available up to 7 days in the past.
We do not backup Redis data but let it write its data to disk in certain intervals determined by amount of data changed and a time interval. Writing data to disk is not a backup. It's not copied anywhere. It's not incremental. It's not rotated. Disk persistence in Redis is needed for replication.
In our datacenter at noris, we use. With that, the borg client is in charge of sending the data to the backup server. This way we can fully encrypt all backups with ease and even be efficient with deduplication.
All in all, the following is backed up:
We do this, in order to restore functionality completely without outside (e.g. a developer of the customer) interaction to any point within the last 7 days.
We frequently check that our backup is working as expected and we are able to restore backups: