Azure DB for MySQL – Replication

No doubt there will be a need for you to split off your analytical queries from the main database for performance reasons.

Continue reading

Azure DB for MySQL – Storage v1 vs v2

When it comes to MySQL and storage you will normally have to decide on 3 options: basic, general purpose v1 or v2.

Basic does support up to 1TB and is low-cost option but has no IOPs guarantee, not really recommended for production systems. General purpose v2 should be the one used because it uses latest storage infrastructure which can support up to 16-TB and 20000 IOPs a shown below.

Continue reading

Azure Database for MySQL

SQL Server is not the only database you build and deploy into Azure. Another very popular option is MySQL. Going back many years, this was actually my first database technology that I ever used so its great seeing it within the Azure eco-system, it has always been a popular choice as seen below.

Continue reading