DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
  1. DZone
  2. Data Engineering
  3. Data
  4. Real-Time Database Backup to OSS on the OSS Console

Real-Time Database Backup to OSS on the OSS Console

This article describes how to back up databases, including the local Internet data center (IDC) databases and public network databases.

Leona Zhang user avatar by
Leona Zhang
·
Dec. 12, 18 · Tutorial
Like (1)
Save
Tweet
Share
5.66K Views

Join the DZone community and get the full member experience.

Join For Free

This article describes how to back up databases, including the local Internet data center (IDC) databases, public network databases, databases not hosted on Alibaba Cloud, Relational Database Service (RDS) databases, and Elastic Compute Service (ECS) user-created databases, to Alibaba Cloud Object Storage Service (OSS) in real time.

Alibaba Cloud OSS supports Standard, Infrequent Access (IA), and Archive storage classes. You can use the Standard storage class of OSS to store image, audio, and video files for apps and large websites. You can use the IA or Archive storage class as a low-cost solution for backup and archiving of infrequently accessed data. OSS is applicable to storage media for database backup.

Alibaba Cloud Database Backup (DBS) is a cost-effective database backup service that provides continuous, powerful protection for data in enterprise data centers, clouds of other cloud vendors, public clouds, and other environments. DBS provides an overall data backup and restoration solution, which delivers capabilities of real-time incremental backup and data restoration within seconds.

Backing Up Database to OSS on the OSS Console

For Users Who Have Subscribed to DBS

Image title

For Users Who Have Not Subscribed to DBS

Image title

Application Scenario of Database Backup to OSS

Image title

Back up or archive Alibaba Cloud RDS databases or ECS user-created databases to OSS

Image title

Back up self-built IDC databases to the cloud

Image title

Back up databases not hosted on Alibaba Cloud to OSS

Image title

Back up databases to OSS for remote disaster recovery

Image title

Benefits

Full Backup or Real-time Incremental Backup

Image title

With DBS and OSS you can perform a full backup or real-time incremental backup and second-level RPO. Based on the high performance and easy expandability features of OSS, DBS realizes in-depth optimization to allow efficient database backup to OSS.

  1. Second-level Recovery Point Objective (RPO): real-time CDP backup and log memory capture
  2. Unlocked backup, concurrent backup, and self-adaptive sharding during data pull
  3. Accurate restoration: accurate object matching and restoration of a single table, significantly reducing Recovery Time Objective (RTO)
  4. Flexible restoration: calendar- or timeline-based data restoration at any specified time

Image title

High Security and Reliability

Image title

  1. Remote disaster recovery: OSS supports cross-region data duplication, which can be used for remote disaster recovery, enhancing data security.
  2. Encrypted data transmission: Users can use SSL to encrypt data as needed, securing data transmission.
  3. Encrypted data storage: Users can encrypt data to be backed up to OSS, ensuring data privacy.
  4. Verification anytime: The validity of database backup can be verified anytime.

Cost Effectiveness

Image title

  1. Size dividend: Using OSS to store backup data reduces the storage space cost.
  2. Pay-As-You-Go billing based on the amount of storage space you use: One-time substantial investment is not required.
  3. Automatic storage classification: OSS supports Standard, IA, and Archive storage classes. Long-term archiving is applicable.
  4. Elastic expansion: OSS seamlessly supports requirements of enterprises in various development phases.

Support for Multiple Environments and Data Sources

Image title

  1. Databases including the MySQL, Oracle, Microsoft SQL Server, and MongoDB
  2. On-premises IDC databases, third-party cloud databases, ApsaraDB for RDS databases, and ECS user-created databases

Database Backup Management (DBS + OSS)

The procedure for backing up databases to OSS is as follows:

  1. Create a backup plan.
  2. Configure the backup plan.
  3. Check the backup plan configuration.
  4. Restore databases.

For more information about using Alibaba Cloud Object Storage Service, visit the official product guide.

Relational database Backup Data (computing) Console (video game CLI)

Published at DZone with permission of Leona Zhang. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • How and Why You Should Start Automating DevOps
  • PHP vs React
  • RabbitMQ vs. Memphis.dev
  • SAST: How Code Analysis Tools Look for Security Flaws

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends: