MEAPSA

Deploy MariaDB, MySQL, and PostgreSQL on Azure

Compare Open Source Azure Database offerings with Azure SQL offerings. Configure an Open Source database and configure high availability and security options.

Database Administrator

Data Engineer

Azure

SQL Database

Module Objectives

After completing this module, you will be able to:

Understand the service tiers available for open source database platforms
Deploy MySQL, MariaDB, and PostgreSQL
Configure high availability option for MySQL and MariaDB
Configure Scale Out reads for MySQL and MariaDB
Describe the SSL Options for MySQL and MariaDB

Units

Introduction min
Describe open source offerings min
Explain how to deploy PostgreSQL to Azure min
Deploy MySQL and MariaDB to Azure min
Exercise: Deploy a PostgreSQL database server to Azure min
Knowledge check min
Summary min

Prerequisites

Experience creating and configuring resources using the Azure portal.
Experience with an Open Source data platform, such as PostgreSQL, MySQL, or MariaDB.
Ability to write SQL statements at a beginner level.