Exploring advanced database operations
Running your database as a managed service on top of Azure has many advantages. In this section, we'll explore those benefits. We will explore restoring from a backup, how you can set up disaster recovery, and how you can access audit logs to verify who made changes to your database.
We'll begin by restoring our database from a backup.
Restoring from a backup
When you run a database within your Kubernetes cluster, high availability (HA), backups, and DR are your responsibilities. Let's take some time to explain the differences between those three concepts:
- HA: HA refers to local redundancy in a service to ensure that the service remains available in the event that a single component fails. This means setting up multiple replicas of a service and coordinating the state between them. In a database context, this means setting up a database cluster.
The Azure Database for MySQL service comes with HA built in. It offers...