ECS database backup

Updated at:

Cloud Backup Database Backup provides automated, incremental backup and recovery for self-managed databases on Elastic Compute Service (ECS) instances.

Introduction

Cloud Backup Database Backup for ECS protects the self-managed databases on your ECS instances by backing them up to a Cloud Backup vault. If a database or ECS instance fails, or if data is lost to human error or ransomware, restore the data from the Cloud Backup vault.

Important
  • Cloud Backup does not support databases running in containers.

  • To back up multiple MySQL instances on a single machine, such as a local server or an ECS instance, create a separate backup job for each instance.

Key benefits

  • Low cost

    Cloud Backup charges no instance or configuration fees. You pay only for the backup storage you use, after deduplication and compression.

  • High performance

    Backup jobs consume minimal resources, typically less than 0.5 cores and 100 MB of memory. Real-time backups for MySQL and Oracle achieve a near-zero Recovery Point Objective (RPO).

  • Broad database support

    Supports all major versions of MySQL, Oracle, and SQL Server.

  • Easy setup

    After you grant authorization, Cloud Backup automatically detects databases on ECS instances and deploys the backup client.

  • Automated alerts

    Configure alert settings for failed tasks in the Cloud Backup console to receive notifications by email, text message, or phone call.

  • Backup lock to prevent accidental deletion

    Vault Lock prevents accidental deletion. Once a backup is locked, no account can delete it or shorten its retention period before the period expires.

How it works

In the Cloud Backup console, select the ECS instances to back up. Cloud Backup uses Cloud Assistant to push the backup client to each instance, then backs up the selected databases based on your backup plan.

When a backup job runs, the Cloud Backup client invokes the database’s native backup interface, then deduplicates, compresses, and uploads the data to the Cloud Backup vault.

Procedure

To back up ECS databases, complete the following steps:

image
Note
  • The backup procedure is the same for MySQL, Oracle, and SQL Server on ECS. This topic uses MySQL as an example.

  • Cloud Backup uses database credentials for registration. Get the username and password from your MySQL or SQL Server administrator. Oracle databases do not require a password.

  1. Activate Cloud Backup

    Activation is free. You are charged for backup vault rental and storage. Each vault includes a 30-day free trial and 100 GB of free storage per month. Beyond the free quota, tiered pricing applies. For more information, see Billing methods and billable items.

  2. Register a database

    Register a database in the Cloud Backup console. A backup client is automatically installed on the ECS instance. No charges apply until you create a backup plan.

  3. Precheck a database

    Run a precheck to identify issues that may cause backup failures.

  4. Back up a database

    Create a backup plan by specifying the vault, data source, backup cycle, retention period, and backup type (full or incremental). Cloud Backup runs the plan and continuously backs up the database.

  5. Restore a database

    Restore a database at no additional cost. You can restore data to the source database or another registered database in the same account and region based on recovery points.

Supported database versions

  • Oracle

    Supported Oracle versions and backup features:

    Database type

    Supported versions

    Supported operating systems

    Minimum backup granularity

    Backup features

    Full backup

    Incremental backup

    Log backup (periodic backup)

    Real-time backup

    Oracle

    9i

    • RHEL 4, 5

    • SLES 9

    • SUSE 9.3

    • CentOS 4.5

    Instance

    Supported

    Supported

    Supported

    Supported

    10g

    • RHEL 4, 5, 6.5, 9

    • CentOS 4.6

    • SUSE 11 SP4

    Instance

    Supported

    Supported

    Supported

    Supported

    11g

    • RHEL 5, 6, 6.5, 7

    • CentOS 6.4, 6.5

    • Oracle Enterprise Linux 6.7

    • Windows Server 2008 R2, Windows Server 2012 R2

    • Alibaba Cloud Linux 2

    Instance

    Supported

    Supported

    Supported

    Supported

    12c

    • Windows Server 2008 R2

    • RHEL 6.5, 7.5

    Instance

    Supported

    Supported

    Supported

    Supported

    18c

    • RHEL 7

    • Windows Server 2008 R2

    Instance

    Supported

    Supported

    Supported

    Supported

    19c (≤19.24)

    Oracle Enterprise Linux 7.0

    Instance

    Supported

    Supported

    Supported

    Supported

  • Oracle RAC

    Supported Oracle RAC versions and backup features:

    Database type

    Supported versions

    Supported operating systems

    Minimum backup granularity

    Backup features

    Full backup

    Incremental backup

    Log backup (periodic backup)

    Real-time backup

    Oracle RAC

    9i

    • SUSE 9.3

    • RHEL 4

    Instance

    Supported

    Supported

    Supported

    Supported

    10g

    • RHEL 5

    • Windows Server 2008 R2

    Instance

    Supported

    Supported

    Supported

    Supported

    11g

    • Windows Server 2008 R2

    • Oracle Linux 6.4

    • RHEL 5, 6.5

    • iSoft Server 3

    Instance

    Supported

    Supported

    Supported

    Supported

    12c

    • CentOS 6, 6.7

    • RHEL 6.5

    • Windows Server 2008 R2

    • Oracle Enterprise Linux 6

    Instance

    Supported

    Supported

    Supported

    Supported

    18c

    Windows Server 2008 R2

    Instance

    Supported

    Supported

    Supported

    Supported

    19c (≤19.24)

    RHEL 7.6

    Instance

    Supported

    Supported

    Supported

    Supported

  • Oracle Data Guard

    Supported Oracle Data Guard versions and backup features:

    Database type

    Supported versions

    Supported operating systems

    Minimum backup granularity

    Backup features

    Full backup

    Incremental backup

    Log backup (periodic backup)

    Real-time backup

    Oracle Data Guard

    11g

    • CentOS 6.4, 6.5, 7.6

    • RHEL 6

    • Windows Server 2008 R2

    • Alibaba Cloud Linux 2

    Instance

    Supported

    Supported

    Supported

    Supported

    12c

    Oracle Enterprise Linux 6

    Instance

    Supported

    Supported

    Supported

    Supported

  • MySQL

    Supported MySQL versions and backup features:

    Database type

    Supported versions

    Supported operating systems

    Minimum backup granularity

    Backup features

    Full backup

    Incremental backup

    Log backup (periodic backup)

    Real-time backup

    MySQL

    5.1.38 and later

    • RHEL 6, 6.5

    • SUSE 11 SP4

    Instance

    Supported

    Supported

    Supported

    Supported

    5.4

    • RHEL 6.5

    • SUSE 11 SP4

    Instance

    Supported

    Supported

    Supported

    Supported

    5.5

    • Ubuntu 12.04, 14.04

    • Debian 7.8, 8.3

    • CentOS 6.0

    • RHEL 6.5

    Instance

    Supported

    Supported

    Supported

    Supported

    5.6

    • RHEL 5, 6, 6.5

    • Ubuntu 14.04

    • CentOS 6.0, 7.2

    Instance

    Supported

    Supported

    Supported

    Supported

    5.7

    • RHEL 6, 6.5, 7

    • CentOS 7.0, 7.2

    • Ubuntu 16.04

    • Neokylin 7.0

    • Alibaba Cloud Linux 2, 3

    Instance

    Supported

    Supported

    Supported

    Supported

    8.0 to 8.0.32

    • CentOS 6.7, 7.0, 7.9

    • Ubuntu 20.04

    • RHEL 6.5

    Only for backup clients of version 8.0.42518 and later

    Instance

    Supported

    Supported

    Supported

    Supported

  • MariaDB

    Supported MariaDB versions and backup features:

    Database type

    Supported versions

    Supported operating systems

    Minimum backup granularity

    Backup features

    Full backup

    Incremental backup

    Log backup (periodic backup)

    Real-time backup

    MariaDB

    5.5, 10.0, 10.1, 10.2, 10.3

    • CentOS 7.0

    • Ubuntu 18.04

    Instance

    Supported

    Supported

    Supported

    Supported

  • SQL Server

    Supported SQL Server versions and backup features:

    Database type

    Supported versions

    Supported operating systems

    Minimum backup granularity

    Backup features

    Full backup

    Incremental backup

    Log backup (periodic backup)

    SQL Server

    2005

    Windows Server 2008 R2 SP1

    Instance

    Supported

    Supported

    Supported

    2008

    • Windows Server 2008 R2

    • Windows Server 2008 R2 SP1

    Instance

    Supported

    Supported

    Supported

    2008 R2

    Windows Server 2008 R2

    Instance

    Supported

    Supported

    Supported

    2012

    Windows Server 2012 RC

    Instance

    Supported

    Supported

    Supported

    2014

    • Windows Server 2008 R2 SP1

    • Windows Server 2016

    Instance

    Supported

    Supported

    Supported

    2016 (RTM)

    Windows Server 2012 R2

    Instance

    Supported

    Supported

    Supported

    2017

    Windows Server 2012, 2016

    Instance

    Supported

    Supported

    Supported

    2019

    Windows Server 2016

    Instance

    Supported

    Supported

    Supported

    2022

    Windows Server 2016

    Only for backup clients of version 8.0.42518 and later

    Instance

    Supported

    Supported

    Supported

  • SQL Server Always On

    Supported SQL Server Always On versions and backup features:

    Database type

    Supported versions

    Supported operating systems

    Minimum backup granularity

    Backup features

    Full backup

    Incremental backup

    Log backup (periodic backup)

    SQL Server Always On

    2012, 2016, 2017

    Windows Server 2012 R2

    Instance

    Supported

    Supported

    Supported

    2019

    Windows Server 2019, Windows Server 2022

Pricing

ECS database backup incurs two types of fees:

  • Database backup vault rental fee

    Create a database backup vault before you start database backups. Multiple databases in the same region can share a backup vault. Each vault includes a specific amount of free storage. For pricing details, see Pricing.

  • Database backup storage fee

    Storage fees apply once usage exceeds the 100 GB free quota per vault. Usage is calculated on the deduplicated and compressed data volume. For pricing details, see Pricing.

Next steps