In the previous test we looked at what happened when we scaleup an Azure Database for MySQL server to sustain an heavy workload. We saw that the service interruption was minimal. Azure Database for MySQL being a fully managed DBaaS being able to scale up the service only when required by the workload is a ...continue reading "Scaling up or scaling down Azure Database for MySQL for cost optimization ..read more

In that test I would like to measure the impact of a failover of an Azure Database for MySQL. Unfortunately there is no mechanism to force the crash of the Azure Database for MySQL instance. So how can I test how long it takes to failover and what is the impact on a server activity. ...continue reading "Azure Database for MySQL failover impact on availability ..read more

In the 2 previous posts(1/3, 2/3) I gave you feedback about an experiment I made with ProxySQL and connection redirection. I used sysbench 1.1 with parameter ”reconnect=1" which force reconnect after every query. This was to represent a PHP application for which you get connection at each page. I used the script 'oltp_point_select.lua' not to have ...continue reading "ProxySQL connection redirection experiment with Azure database for MySQL/MariaDB. 3/3 ..read more

In my previous post I gave you feedback about an experiment I made with ProxySQL implementing connection redirection for Azure Database for MySQL. ProxySQL connection redirection experiment with Azure database for MySQL/MariaDB My initial test was run by injecting from my Windows10 laptop WSL linux subsystem running sysbench and ProxySQL. It went through the internet ...continue reading "ProxySQL connection redirection experiment with Azure database for MySQL/MariaDB. 2/2 ..read more

My aim here is to experiment a new approach with Azure database for MySQL/MariaDB and ProxySQL. When a connection is initiated with Azure database for MySQL/MariaDB it goes through a shared gateway. This gateway knows where the target database server is. This level of indirection is very useful to offer High Availability in a way ...continue reading "ProxySQL connection redirection experiment with Azure database for MySQL/MariaDB. 1/2 ..read more

In the previous post I mentioned a hack to make ProxySQL compatible with Azure Database for MySQL. If you want to try it you can download it from github and build a package for your target linux distribution : $ git clone https://github.com/sfrezefo/proxysql.git $ cd proxysql $ git checkout azurehack To make a usable package ...continue reading "How to build a ProxySQL compatible with Azure Database for MySQL / MariaDB ..read more

Azure Database for MySQL is a PaaS offer. It has a specific architecture that relies on a gateway. This has a huge advantage in the way it handle High availability. If a server fails it will automatically restart. The storage for the database is highly resilient and will be reconnected to the new server. You ...continue reading "Using ProxySQL with Azure Database for MySQL / MariaDB – a little hack ..read more

In previous post I used Terraform to provision a managed version of MariaDB (AWS RDS for MariaDB). There exist various managed version of MariaDB on the major cloud providers : AWS, Azure, Alibaba Cloud. All of these versions offer a simplification to rapidly deploy and operate MariaDB. You benefit from easy setup including High availability ...continue reading "Using Terraform and Kubernetes to provision MariaDB on Azure ..read more