Azure Database for MySQL
Azure Database for MySQL is a Microsoft-hosted version of the open source MySQL relational database, built on top of the Community Edition and provided as a PaaS service. It is provided as a fully managed database-as-a-service platform; you can focus on just the database level and the data tasks you wish to perform against it with your data.
The following are some of the benefits and capabilities of Azure Database for MySQL:
- Being built on top of Community Edition, there are no compatibility issues with moving databases from on-premises environments.
- It has built-in high availability.
- Data protection is provided, with automatic backups and 35 days of point-in-time restores.
- It is monitored, secure, and up to date and provides automated maintenance for the database’s underlying platform hardware, OS, and database engine.
- Data is secured in transit and at rest.
- Three deployment modes are available; Single Server, Flexible Server, and Hyperscale (Citus).
- Elastic scaling is available; that is, horizontal scaling via the Hyperscale (Citus) deployment mode.
- Pay-as-you-go consumption pricing is available through the Basic, General Purpose, and Memory Optimized plans. The prices of these plans rise as additional resources such as CPU and memory are added.
This section looked at Azure Database for MySQL. In the next section, we will look at Azure Database for PostgreSQL.
Azure Database for PostgreSQL
Azure Database for PostgreSQL is a Microsoft hosted version of the open source MySQL relational database but provided as a fully-managed database-as-a-service platform; you can just focus on the database level and the data tasks you wish to perform against it with your data.
The following are some of the benefits and capabilities of Azure Database for PostgreSQL:
- It has built-in high availability.
- Data protection is provided, with automatic backups and 35 days of point-in-time restores.
- It is monitored, secure, and up to date, with automated maintenance of the database’s underlying platform hardware, OS, and database engine.
- Data is secured in transit and at rest.
- Three deployment modes are available; that is, Single Server, Flexible Server, and Hyperscale (Citus).
- Elastic scaling is available; that is, horizontal scaling via the Hyperscale (Citus) deployment mode.
- Pay-as-you-go consumption pricing is available through the Basic, General Purpose, and Memory Optimized plans. The prices of these plans rise as additional resources such as CPU and memory are added.
This section looked at Azure Database for PostgreSQL. In the next section, we will look at Cosmos DB.
