Learn Database Engineer

For data disaster recovery, ETL, and remote data access purposes, you need to implement master-slave replication between RDS for MySQL instances and your own offline MySQL instances. This lab describes how to configure master-slave replication and how it works to help you quickly get started with relevant configurations

This lab is designed to build a relational database through RDS. RDS for MySQL is used as an example

In this lab, an RDS instance is used as the database, and the following scenario is simulated: Recover the data deleted by mistake. Some data already exists on the RDS instance. Physical backup and logical backup are performed on the RDS instance, the operation of deleting data tables is simulated, and then the backup data is used to restore the RDS data that is mistakenly deleted

The main content of this lab is to explain how to migrate self-built databases based on ECS to the RDS database. The data migration process is implemented through the Data Transmission Service (DTS).

This lab demonstrates the master-slave synchronization process for MySQL databases on Alibaba Cloud ECS instances.MySQL is one of the most popular relational database management systems. Master-slave synchronization means that data can be replicated from one database server to another. During replication, one server acts as the master server, while the other servers act as slave servers.Because the replication process is asynchronous, the slave servers do not need to be connected to the m

This lab uses ApsaraDB for RDS (RDS). It describes how to back up and restore databases in the RDS console. RDS is a stable, reliable, and scalable online database service provided by Alibaba Cloud. It provides a complete solution that includes backup, recovery, and migration, and allows you to focus more on services rather than database O&M

This lab demonstrates how to migrate data from an ApsaraDB RDS for MySQL database to an Apsara PolarDB for MySQL cluster by using Apsara PolarDB. Apsara PolarDB is a next-generation relational database service developed by Alibaba Cloud. It is compatible with MySQL, PostgreSQL, and Oracle databases. With superior performance in storage and computing, Apsara PolarDB can meet the diverse requirements of enterprises. An Apsara PolarDB cluster has a maximum storage space of 100 TB and can con

This lab uses Alibaba Cloud ApsaraDB for RDS (RDS). The lab introduces the read/write splitting feature of RDS and describes how to add read-only instances. Read/write splitting implements the automatic forwarding of read/write requests through a read/write splitting address. A single instance may be unable to address the read pressure in a use case where there are few write requests but massive read requests. In this case, main services may be affected. To achieve auto scaling of