Reputation: 95
Now that Azure has started to provide Preview version of PaaS version of MySQL, how do I do an Apples to Apples comparison of Azure SQL and Azure MySQL from a Cost perspective?
In AWS RDS world, both SQL Server and MySQL are tied to compute units. While Azure SQL does Pricing Calculation based on DTUs (proportional to # of Transactions per second?) while "Azure Database for MySQL" does based on # of compute units + Storage.
Upvotes: 1
Views: 3158
Reputation: 186
Azure SQL DB uses "Database Transaction Units" for determining performance and Azure DB for MySQL uses "Compute Units". Both are a blended measure of CPU/RAM however DTUs include disk IO performance whereas Compute Units do not. Azure DB for MySQL gives you the option to choose your Disk IO performance in IOPS in the Standard and eventually Premium tiers.
Upvotes: 1