All Products
Search

This Product

    Select a backup method

    Document Center

    Select a backup method

    Last Updated: Mar 24, 2020

    DBS is a cost-effective database backup service that provides continuous protection for data. DBS provides three backup methods: logical backup, physical backup, and dump backup. This topic describes how to select a backup method.

    Backup method

    Logical backup Physical backup
    MySQL
    • Full backup (periodic, day-level RPO)
    • Incremental backup (real-time, second-level RPO)
    • Full backup (periodic, day-level RPO)
    • Incremental backup (real-time, 10-minute RPO)
    SQL Server
    • Full backup (periodic, day-level RPO)
    • Full backup (periodic, day-level RPO)
    • Incremental backup (periodic, 10-minute RPO)
    PostgreSQL
    • Full backup (periodic, day-level RPO)
    		 Not supported
    PPAS
    • Full backup (periodic, day-level RPO)
    		 Not supported
    Oracle
    • Full backup (periodic, day-level RPO)
    • Full backup (periodic, day-level RPO)
    • Incremental backup (periodic, 10-minute RPO)
    Redis
    • Full backup (periodic, day-level RPO)
    • Incremental backup (periodic, 10-minute RPO)
    		 Not supported
    MongoDB
    • Full backup (periodic, day-level RPO)
    • Incremental backup (periodic, 10-minute RPO)
    		 Not supported

    On-premises user-created database

    Database instance type Database type Network requirement Backup scene Recommended backup method
    On-premises user-created database MySQL The database can be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Logical backup
    On-premises user-created database MySQL The database is connected to the Internet. Back up an on-premises database to the cloud. Physical backup
    On-premises user-created database SQL Server The database can be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Physical backup
    On-premises user-created database SQL Server The database is connected to the Internet. Back up an on-premises database to the cloud. Physical backup
    On-premises user-created database Oracle The database can be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Physical backup
    On-premises user-created database Oracle The database is connected to the Internet. Back up an on-premises database to the cloud. Physical backup
    On-premises user-created database PostgreSQL, Redis, and MongoDB The database can be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Logical backup
    On-premises user-created database Oracle, PostgreSQL, Redis, and MongoDB The database is connected to the Internet but cannot be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Not supported
    On-premises user-created database Not limited The database is not connected to the Internet. Back up an on-premises database to the cloud. Not supported

    ECS-hosted database

    Database instance type Database type Network requirement Backup scene Recommended backup method
    ECS-hosted database MySQL, PostgreSQL, Redis, and MongoDB Not limited Back up an ECS-hosted database. Logical backup
    ECS-hosted database Oracle Not limited Back up an ECS-hosted database. Physical backup
    ECS-hosted database SQL Server Not limited Back up an ECS-hosted database. Physical backup

    ApsaraDB

    Database instance type Database type Network requirement Backup scene Recommended backup method
    ApsaraDB for RDS MySQL 5.7 High-Availability Edition with SSD, and MySQL 5.6 Not limited Remote backup Dump backup
    ApsaraDB for RDS MySQL (other) Not limited Remote backup Logical backup
    ApsaraDB for RDS MySQL Not limited Flexible backup Logical backup
    ApsaraDB for RDS SQL Server Not limited Remote backup and flexible backup Logical backup
    ApsaraDB for RDS PostgreSQL Not limited Remote backup and flexible backup Logical backup
    ApsaraDB for RDS PPAS Not limited Remote backup and flexible backup Logical backup
    ApsaraDB for POLARDB MySQL Not limited Remote backup and flexible backup Logical backup
    ApsaraDB for POLARDB PostgreSQL Not limited Remote backup and flexible backup Logical backup
    ApsaraDB for POLARDB Oracle Not limited Remote backup and flexible backup Logical backup
    ApsaraDB for Redis Not limited Not limited Remote backup and flexible backup Logical backup
    ApsaraDB for MongoDB Not limited Not limited Remote backup and flexible backup Logical backup

    For more information about dump backup and flexible backup, see What is the difference between DBS and the backup capability of ApsaraDB for RDS.

    Free Trial Free Trial