As we went through the journey of launching Postgres, MariaDB and MySQL as a first class services in Azure, it has been a very humbling experience learning from our customers and the community. We want to share a few learnings from this journey with you all.
Azure Database for MySQL, PostgreSQL and MariaDB are fully managed database services that provides high availability with industry leading SLA, built-in intelligence to optimize customer database performance, as well as a comprehensive set of compliance and security features. Leveraging the same technology that powers our High-Availability, Azure Database Services provides the ability to scale performance on the fly with little/no application downtime. Scaling is as simple as literally changing a slider to increase or decrease vCores, and clicking OK. Scaling effectively brings-up a new server at the new performance tier, and switches over to the storage on the previous server and maps to the existing DNS name, all in about 15-20 seconds. This means that customers do not have to worry so much about the size of the server they need coming into Azure. They can choose a SKU to start and then monitor the performance of their database server to determine if they should either scale-up or scale-down their server based on their workload. Customers can then set alerts on metrics such as CPU or Memory usage to notify them in the event they need to scale-up their server for workload spikes.
In addition, the Azure Database for PostgreSQL Hyperscale deployment option provides high-performance horizontal scaling which takes their single node PostgreSQL across hundreds of nodes – all with easy sharding.