For the thousands of organizations around the world that use MySQL or PostgreSQL to manage critical data stores and support their apps and services, database stability is a top priority. For administrators responsible for maintaining performance in such high-stakes environments, the prospect of migrating database structures to a new cloud solution may seem like playing with fire—even when the potential benefits of the cloud for operational efficiency and future growth are appealing. Cloud database migration can be a smoother process than many database admins may imagine, but success requires selecting the right cloud service model and pairing it with proven best deployment practices. 

Microsoft Azure offers two cloud service models—Platform as a Service (PaaS) and Infrastructure as a Service (IaaS)—that can provide distinct advantages for MySQL and PostgreSQL database deployment and management. PaaS provides a managed platform for customers to develop, host, and manage applications without having to manually build, maintain, and secure the underlying infrastructure. IaaS provides a highly customizable cloud environment where businesses can have complete control over IT resources like storage, networking, and compute power on demand. Both services present administrators with a wide range of VM choices, storage configurations, scalability, monitoring tools, security, and high availability options. 

To help decision makers understand whether an Azure PaaS or IaaS cloud service model would be the right choice for their organization, we put together an in-depth report on the features and capabilities of each cloud service in a database context—complete with detailed migration guides—for both MySQL and PostgreSQL environments. Each report covers VM selection, deployment procedures, monitoring and maintenance, storage considerations, database configuration considerations, and backup and restore processes. 

By offering the simplicity of PaaS or the maximum control available with IaaS solutions for MySQL and PostgreSQL, Azure allows customers to select the model that best suits their database management needs while continuing to use familiar Microsoft and Azure tools. 

For more in-depth information about using Microsoft Azure IaaS and PaaS to deploy MySQL and PostgreSQL, check out the detailed reports—complete with migration guides—below.