Skip to content

Create database backup

This guide walks through you to setup of backups for your cloud database. You can create your backups yourself or use our managed backup solution for cloud databases.

Managed backups

To enable managed backups, navigate to your cloud database cluster and click on 'Enable Managed Backup'. With managed backups, you can select a retention policy that suits your needs, specifying both the frequency and duration for which your backups are stored. For added security, managed backups are stored in a separate data center from where your cloud database is hosted, ensuring that your data is protected against loss.

Create a backup container job

To create a manual backup or store your backups on your own storage, you will need to configure a container job. The container job will execute a series of commands. For your convenience we have created a container image that contains all the tools you might need to create a backup.

Note

Please be aware that creating backups to a volume will limit the size of your backups to max 100Gb. If you require more storage, please contact our support team or consider using an external backup storage solution.

  1. Choose a container name, so you can identify your backup job.
  2. Fill the image you want to use. We recommend using ghcr.io/nexaa-cloud/database_dumps:3. This is a public image.
  3. Registry can be set to public
  4. Select a number of resources, This depends on your database size.

  5. Enter your database credentials. We recommend using a secret for your password. Screen shot showing secret environment variable

    1
2
3
4
    PASSWORD=<your-password>
USER=<backup-user>
HOST=<database-host>
DATABASE=<yourdatabase>

    1
2
3
4
    PGPASSWORD=<your-password>
USER=<backup-user>
HOST=<database-host>
DATABASE=<yourdatabase>

    Info

    You can use the bulk import option to create multiple environment variables quickly

  6. Configure the container CMD

    1
    "mysql_dump -h $HOST -U $USER -d $DATABASE -p$PASSWORD -f /dbdump/mysql_dump_$(date -u +%Y%m%d_%H%M).sql"

    1
    "pg_dump -h $HOST -U $USER -d $DATABASE -f /dbdump/pg_dump_$(date -u +%Y%m%d_%H%M).sql"

  7. Add a volume to your container to store the dump.

    Info

    Although dumping data to a volume is possible, we strongly recommend uploading your dump to a separate location for added security and flexibility.

  8. Configure your backup schedule as needed. In this example, a backup is generated every 12 hours. You can adjust this frequency to suit your specific requirements. Screen shot showing backup schedule

To finalize your setup, press "Add container job". This will complete the configuration of your database backups, and you can now rely on your scheduled backups to ensure the integrity and availability of your data.

Note

If you are new to our api we recommend reading the automation article about our api first.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
mutation MyMutation {
    containerJobCreate(
        scheduledJob: {
            name: "backup-job"
            namespace: "demo"
            resources: CPU_250_RAM_500
            image: "ghcr.io/nexaa-cloud/database_dumps:3"
            schedule: "5 0,12 * * *"
            command: "\"mysql_dump -h $HOST -U $USER -d $DATABASE -p$PASSWORD -f /dbdump/mysql_dump_$(date -u +%Y%m%d_%H%M).sql\""
            environmentVariables: [
                {
                name: "PASSWORD", 
                value: "<your-password>"
                secret: true
                },
                {
                name: "USER", 
                value: "<your-user>"
                }
                {
                name: "HOST", 
                value: "<your-database-host>"
                }
                {
                name: "DATABASE", 
                value: "<database-user>"
                }
            ],
            mounts: {
                path: "/dbdump", 
                volume: {
                name: "backups",
                autoCreate: true,
                size: 10
                }
            }
        }
    ) {
        name
    }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
mutation MyMutation {
    containerJobCreate(
        scheduledJob: {
            name: "backup-job"
            namespace: "demo"
            resources: CPU_250_RAM_500
            image: "ghcr.io/nexaa-cloud/database_dumps:3"
            schedule: "5 0,12 * * *"
            command: "\"pg_dump -h $HOST -U $USER -d $DATABASE -f /dbdump/pg_dump_$(date -u +%Y%m%d_%H%M).sql\""
            environmentVariables: [
                {
                name: "PASSWORD", 
                value: "<your-password>"
                secret: true
                },
                {
                name: "USER", 
                value: "<your-user>"
                }
                {
                name: "HOST", 
                value: "<your-database-host>"
                }
                {
                name: "DATABASE", 
                value: "<database-user>"
                }
            ],
            mounts: {
                path: "/dbdump", 
                volume: {
                name: "backups",
                autoCreate: true,
                size: 10
                }
            }
        }
    ) {
        name
    }
}