Understanding Performance in Basic Tier for Azure Database PostgreSQL and MySQL

Published Mar 13 2019 07:34 PM 3,658 Views
Microsoft
First published on MSDN on Nov 20, 2018
Azure Database for PostgreSQL and MySQL have similar architectures for performance tiers. While Microsoft recommends to choose between the General Purpose and the Memory Optimized versions, some users might consider Basic Tier servers as they believe their workload is not that aggressive against resource utilization.

Basic Tier servers were built for testing, development or small-scale infrequent used applications where the customer can get a flavor of the service and a sense of the features offered in the PaaS solution. The below table helps you to choose which service to start with for your database. Basic Tier servers are good for testing environment with a single connections. The below table explains the different Target workloads for each of the available performance tiers.



Table 1: Azure Database for PostgreSQL and MySQL Pricing Tiers Target workloads

Basic Tier servers use Azure Standard Storage. The storage you provision is the amount of storage capacity available for your Azure Database server. The storage is used for the database files, temporary files, transaction logs, and server logs. The total amount of storage you provision also defines the I/O capacity available to your server.


Table 2: Azure Database for PostgreSQL and MySQL Pricing Tiers specifications

Azure Standard Storages that are used in the Basic Tier servers have variable IOPS with no performance guarantees. For more information review Azure Database for MySQL/PostgreSQL pricing tiers.
https://docs.microsoft.com/en-us/azure/mysql/concepts-pricing-tiers
https://docs.microsoft.com/en-us/azure/postgresql/concepts-pricing-tiers


Table 3: Azure Database for PostgreSQL and MySQL IOPS comparison

More information about Azure Standard Storage: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/standard-storage

Now if you are trying to compare Azure Database for MySQL and PostgreSQL with other vendors that have shared environments and expect Azure platform to behave faster in terms of disks operations and CPU, please remember that Azure Databases for MySQL and PostgreSQL have features that are included in the service (increase the cost and degrade performance) that are not offered in Shared environment:

  1. Built-in high availability with no additional cost.
    Azure's industry leading 99.99% availability service level agreement (SLA), powered by a global network of Microsoft-managed datacenters, helps keep your app running 24/7.

  2. Predictable performance, using inclusive pay-as-you-go pricing.
    Azure Database for PostgreSQL an MySQL uses dedicated servers for each instance which guarantees that only your workload is running on the server.

  3. Scale as needed within seconds.

  4. Secured to protect sensitive data at-rest and in-motion.
    By default, the Azure Database for PostgreSQL service is configured to require SSL connection security for data in-motion across the network. Enforcing SSL connections between your database server and your client applications helps protect against "man in the middle" attacks by encrypting the data stream between the server and your application.
    The Azure Database for PostgreSQL service uses storage encryption for data at-rest

  5. Automatic backups and point-in-time-restore for up to 35 days.

  6. Enterprise-grade security and compliance.
    The built-in gateway and firewall for example adds an extra layer of authentication which increase the time for connection establishment while it is helpful for security protection and load balancing.


References:

  1. https://docs.microsoft.com/en-us/azure/mysql/overview

  2. https://docs.microsoft.com/en-us/azure/postgresql/overview

%3CLINGO-SUB%20id%3D%22lingo-sub-369142%22%20slang%3D%22en-US%22%3EUnderstanding%20Performance%20in%20Basic%20Tier%20for%20Azure%20Database%20PostgreSQL%20and%20MySQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369142%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Nov%2020%2C%202018%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20Azure%20Database%20for%20PostgreSQL%20and%20MySQL%20have%20similar%20architectures%20for%20performance%20tiers.%20While%20Microsoft%20recommends%20to%20choose%20between%20the%20General%20Purpose%20and%20the%20Memory%20Optimized%20versions%2C%20some%20users%20might%20consider%20Basic%20Tier%20servers%20as%20they%20believe%20their%20workload%20is%20not%20that%20aggressive%20against%20resource%20utilization.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Basic%20Tier%20servers%20were%20built%20for%20testing%2C%20development%20or%20small-scale%20infrequent%20used%20applications%20where%20the%20customer%20can%20get%20a%20flavor%20of%20the%20service%20and%20a%20sense%20of%20the%20features%20offered%20in%20the%20PaaS%20solution.%20The%20below%20table%20helps%20you%20to%20choose%20which%20service%20to%20start%20with%20for%20your%20database.%20Basic%20Tier%20servers%20are%20good%20for%20testing%20environment%20with%20a%20single%20connections.%20The%20below%20table%20explains%20the%20different%20Target%20workloads%20for%20each%20of%20the%20available%20performance%20tiers.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89090i1812A484816AF029%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Table%201%3A%20Azure%20Database%20for%20PostgreSQL%20and%20MySQL%20Pricing%20Tiers%20Target%20workloads%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Basic%20Tier%20servers%20use%20Azure%20Standard%20Storage.%20The%20storage%20you%20provision%20is%20the%20amount%20of%20storage%20capacity%20available%20for%20your%20Azure%20Database%20server.%20The%20storage%20is%20used%20for%20the%20database%20files%2C%20temporary%20files%2C%20transaction%20logs%2C%20and%20server%20logs.%20The%20total%20amount%20of%20storage%20you%20provision%20also%20defines%20the%20I%2FO%20capacity%20available%20to%20your%20server.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89091iE1986124DE097AB2%22%20%2F%3E%20%3CBR%20%2F%3E%20Table%202%3A%20Azure%20Database%20for%20PostgreSQL%20and%20MySQL%20Pricing%20Tiers%20specifications%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Azure%20Standard%20Storages%20that%20are%20used%20in%20the%20Basic%20Tier%20servers%20have%20variable%20IOPS%20with%20no%20performance%20guarantees.%20For%20more%20information%20review%20Azure%20Database%20for%20MySQL%2FPostgreSQL%20pricing%20tiers.%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fna01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fen-us%252Fazure%252Fmysql%252Fconcepts-pricing-tiers%26amp%3Bdata%3D02%257C01%257CBashar.Hussein%2540microsoft.com%257Cf94755c09e4e4e948f5408d63de41da5%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636764447301295552%26amp%3Bsdata%3DgSfdk%252BsyeXiC0B%252FWPqvnF9Qa5tKfPvvkFh9jRYBlMAA%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fmysql%2Fconcepts-pricing-tiers%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fpostgresql%2Fconcepts-pricing-tiers%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fpostgresql%2Fconcepts-pricing-tiers%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89092i45BFD675F6B4425D%22%20%2F%3E%20%3CBR%20%2F%3E%20Table%203%3A%20Azure%20Database%20for%20PostgreSQL%20and%20MySQL%20IOPS%20comparison%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20More%20information%20about%20Azure%20Standard%20Storage%3A%20%3CA%20href%3D%22https%3A%2F%2Fna01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fen-us%252Fazure%252Fvirtual-machines%252Fwindows%252Fstandard-storage%26amp%3Bdata%3D02%257C01%257CBashar.Hussein%2540microsoft.com%257Cf94755c09e4e4e948f5408d63de41da5%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636764447301305560%26amp%3Bsdata%3DhuHmkyuMVPqH1t2PCI%252BoMDQojPfENR0L18ml2jsANVg%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fstandard-storage%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Now%20if%20you%20are%20trying%20to%20compare%20Azure%20Database%20for%20MySQL%20and%20PostgreSQL%20with%20other%20vendors%20that%20have%20shared%20environments%20and%20expect%20Azure%20platform%20to%20behave%20faster%20in%20terms%20of%20disks%20operations%20and%20CPU%2C%20please%20remember%20that%20Azure%20Databases%20for%20MySQL%20and%20PostgreSQL%20have%20features%20that%20are%20included%20in%20the%20service%20(increase%20the%20cost%20and%20degrade%20performance)%20that%20are%20not%20offered%20in%20Shared%20environment%3A%20%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3EBuilt-in%20high%20availability%20with%20no%20additional%20cost.%20%3CBR%20%2F%3E%20Azure's%20industry%20leading%2099.99%25%20availability%20service%20level%20agreement%20(SLA)%2C%20powered%20by%20a%20global%20network%20of%20Microsoft-managed%20datacenters%2C%20helps%20keep%20your%20app%20running%2024%2F7.%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EPredictable%20performance%2C%20using%20inclusive%20pay-as-you-go%20pricing.%20%3CBR%20%2F%3E%20Azure%20Database%20for%20PostgreSQL%20an%20MySQL%20uses%20dedicated%20servers%20for%20each%20instance%20which%20guarantees%20that%20only%20your%20workload%20is%20running%20on%20the%20server.%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EScale%20as%20needed%20within%20seconds.%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESecured%20to%20protect%20sensitive%20data%20at-rest%20and%20in-motion.%20%3CBR%20%2F%3E%20By%20default%2C%20the%20Azure%20Database%20for%20PostgreSQL%20service%20is%20configured%20to%20require%20SSL%20connection%20security%20for%20data%20in-motion%20across%20the%20network.%20Enforcing%20SSL%20connections%20between%20your%20database%20server%20and%20your%20client%20applications%20helps%20protect%20against%20%22man%20in%20the%20middle%22%20attacks%20by%20encrypting%20the%20data%20stream%20between%20the%20server%20and%20your%20application.%20%3CBR%20%2F%3E%20The%20Azure%20Database%20for%20PostgreSQL%20service%20uses%20storage%20encryption%20for%20data%20at-rest%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EAutomatic%20backups%20and%20point-in-time-restore%20for%20up%20to%2035%20days.%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EEnterprise-grade%20security%20and%20compliance.%20%3CBR%20%2F%3E%20The%20built-in%20gateway%20and%20firewall%20for%20example%20adds%20an%20extra%20layer%20of%20authentication%20which%20increase%20the%20time%20for%20connection%20establishment%20while%20it%20is%20helpful%20for%20security%20protection%20and%20load%20balancing.%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%20References%3A%20%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fmysql%2Foverview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fmysql%2Foverview%20%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fpostgresql%2Foverview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fpostgresql%2Foverview%20%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-369142%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Nov%2020%2C%202018%20Azure%20Database%20for%20PostgreSQL%20and%20MySQL%20have%20similar%20architectures%20for%20performance%20tiers.%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Mar 13 2019 07:34 PM
Updated by: