Home

What does Optimizations On Write mean in case of Azure MySQL versus Azure Maria DB (Write path)

• MariaDB Galera is not available in Azure so cannot be a differentiator here
• Memory storage engine (MariaDB) INSERTs can be up to 24% faster
• Advanced thread pool - up to 200K connections a time - validation for Azure is required
• Updates can also be done 2x faster compared to the traditional MySQL - validation for Azure is required

Sources:

• https://www.guru99.com/mariadb-vs-mysql.html#3
• https://db-engines.com/en/system/MariaDB%3BMicrosoft+Azure+SQL+Database%3BMySQL
• https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/