Create recurring scheduled backups and snapshots of a database with Serverless Jobs and the Scaleway CLI

• serverless
• jobs
• instance
• snapshot
• backup
• image
• disk
• storage
• cli
• schedule
• cron
• recurring

Scaleway Serverless Jobs allows you to create and automate recurring tasks. This tutorial will guide you through the process of creating backups and snapshots of a Managed Database on a recurring schedule using a serverless job.

Serverless Jobs are perfectly adapted for these autonomous tasks, as we do not need autoscaling or exposure via a web server. Refer to the documentation on differences between jobs, containers, and functions for more information.

Before you startLink to this anchor

To complete the actions presented below, you must have:

• A Scaleway account logged into the console.
• Owner status or IAM permissions allowing you to perform actions in the intended Organization.
• Created a managed database.

Creating the job definitionLink to this anchor

1. In the Scaleway console, click Jobs in the Serverless section of the side menu. The jobs page displays.

2. Click Create job. The job creation wizard displays.

3. For Container Image, select External, and in Image URL, set: scaleway/cli:latest.

4. Enter a name or use the automatically generated one.

5. Select the region in which your job will be created.

6. Keep the default resources values, as this job requires little compute capability.

7. Set cron schedule to 0 18 * * * and select the relevant time zone to run the job every evening at 18:00. Refer to the cron schedules documentation for more information.

8. Define the following environment variables:

   • SCW_ACCESS_KEY: your API access key.
   • SCW_SECRET_KEY: your API secret key.
   • SCW_DEFAULT_PROJECT_ID: your Project ID.
   • SCW_DEFAULT_ORGANIZATION_ID: your Organization ID.
   • SCW_DEFAULT_REGION: concerned region.
   Note

   We recommend using Secret Manager to store the SCW_ACCESS_KEY and SCW_SECRET_KEY.

   For more details about variables used by cli, refer to the CLI config documentation.

9. In the Execution tab, define the command below, and replace the placeholder with the ID of your Database Instance:

   • Backup
   • Snapshot

   scw rdb backup create instance-id=11111111-1111-1111-1111-111111111111 database-name=YOUR_DB_NAME
   

10. Click Create job.

Running the jobLink to this anchor

From the Overview tab of the Serverless job you just created, click Actions, then select Run job from the contextual menu.

The execution appears in the Job runs section. You can access the logs of your job by clicking «See more Icon» next to the job run ID, and selecting See on Cockpit.

Possible improvementsLink to this anchor

This tutorial is a lightweight example of how to create recurring backups and snapshots of a Managed Database for PostgreSQL and MySQL. You can go further by:

• Using it to manage all your Databases’ backups and snapshots
• Creating other recurring database operations
• Setting up an alerting system in case of unexpected behavior
• Explore scaleway/serverless-examples repository for advanced automation examples

Additional resourcesLink to this anchor

• Serverless Jobs Documentation
• Other methods to deploy Jobs
• API keys documentation
• CRON schedule reference