{"id":1614,"date":"2019-03-04T00:00:00","date_gmt":"2019-03-04T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql"},"modified":"2025-06-18T01:47:30","modified_gmt":"2025-06-18T08:47:30","slug":"scaling-out-read-workloads-in-azure-database-for-mysql","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/","title":{"rendered":"Scaling out read workloads in Azure Database for MySQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">For read-heavy workloads that you are looking to scale out, you can use read replicas, which are now generally available to all Azure Database for MySQL users. Read replicas make it easy to horizontally scale out beyond a single database server. This is useful in workloads such as BI reporting and web applications, which tend to have more read operations than write.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The feature supports continuous asynchronous replication of data from one Azure Database for MySQL server (the \u201cmaster\u201d server) to up to five Azure Database for MySQL servers (the \u201cread replica\u201d servers) in the same region. Read-heavy workloads can be distributed across the replica servers according to your preference. Replica servers are read-only except for writes replicated from data changes on the master.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-s-supported-with-read-replicas\">What\u2019s supported with read replicas?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You can create or delete replica servers based on your workload\u2019s needs. A master server can support up to five replica servers within the same Azure region. Stopping replication to any replica server makes it a standalone read-write server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can easily manage your replica servers using the <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/howto-read-replicas-portal\">Azure portal <\/a>and <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/howto-read-replicas-cli\">Azure CLI<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>From the Azure portal:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp\" alt=\"Replication tab in Azure portal used for managing replica servers.\" style=\"border-radius:0px\" title=\"Replication tab in Azure portal\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Use Azure Monitor to track replication with the \u201creplication lag in seconds\u201d metric:<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/88a4209d-f531-486a-bfaa-28952720687d.webp\" alt=\"Tracking replication with Azure Monitor\" style=\"border-radius:0px\" title=\"Tracking replication with Azure Monitor\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>From the Azure CLI:<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; auto-links: false; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\naz mysql server replica create -n mydemoreplica1 -g myresourcegroup -s mydemomaster\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Below are some application patterns used by our customers and partners that leverage read replicas for scaling workloads.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"bi-reporting\">BI reporting<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Data from disparate data sources is processed every few minutes and loaded into the master server. The master server is dedicated for loads and processing, not directly exposing it to BI users for reporting or analytics to ensure predictable performance. The reporting workload is scaled out across multiple read replicas to manage high user concurrency with low latency.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/bb7f28a1-1f9f-4251-ada5-1b7d099f23fa.webp\" alt=\"Process disparate data sources with read replicas used to scale out. \" style=\"border-radius:0px\" title=\"BI reporting architecture\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"microservices\">Microservices<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In this architecture pattern, the application is broken into multiple microservices, with data modification APIs connecting to the master server while reporting APIs connect to read replicas. The data modification APIs are prefixed with \u201cSet-\u201d, while reporting APIs are prefixed with \u201cGet-\u201c. The load balancer is used to route the traffic based on the API prefix.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/4d4c786e-1d69-483a-9caa-aaccd882c4f6.webp\" alt=\"Load balance read and write data changes with web services. \" style=\"border-radius:0px\" title=\"Microservices architecture\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"next-steps\">Next steps<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Get started with the service by creating your first Azure Database for MySQL server using the <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/quickstart-create-mysql-server-database-using-azure-portal\" target=\"_blank\" rel=\"noreferrer noopener\">Azure portal<\/a> or <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/quickstart-create-mysql-server-database-using-azure-cli\" target=\"_blank\" rel=\"noreferrer noopener\">Azure CLI<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Learn more about <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/concepts-read-replicas\" target=\"_blank\" rel=\"noreferrer noopener\">read replicas<\/a> and how to create them in the <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/howto-read-replicas-portal\" target=\"_blank\" rel=\"noreferrer noopener\">Azure portal<\/a> or <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/howto-read-replicas-cli\" target=\"_blank\" rel=\"noreferrer noopener\">Azure CLI<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Reach us by emailing our team <a href=\"mailto:AskAzureDBforMySQL@service.microsoft.com\">AskAzureDBforMySQL@service.microsoft.com<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">File feature requests on <a href=\"https:\/\/feedback.azure.com\/forums\/597982-azure-database-for-mysql\" target=\"_blank\" rel=\"noreferrer noopener\">UserVoice<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Follow us on Twitter <a href=\"https:\/\/twitter.com\/AzureDBMysql\" target=\"_blank\" rel=\"noreferrer noopener\">@AzureDBMySQL<\/a> to keep up with the latest features.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>For read-heavy workloads that you are looking to scale out, you can use read replicas, which are now generally available to all Azure Database for MySQL users.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473],"tags":[],"audience":[3057,3055,3056],"content-type":[1465],"product":[2913],"tech-community":[],"topic":[],"coauthors":[619],"class_list":["post-1614","post","type-post","status-publish","format-standard","hentry","category-databases","audience-data-professionals","audience-developers","audience-it-implementors","content-type-announcements","product-azure-database-for-mysql","review-flag-lever-1680286579-649"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Scaling out read workloads in Azure Database for MySQL | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"For read-heavy workloads that you are looking to scale out, you can use read replicas, which are now generally available to all Azure Database for MySQL users.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Scaling out read workloads in Azure Database for MySQL | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"For read-heavy workloads that you are looking to scale out, you can use read replicas, which are now generally available to all Azure Database for MySQL users.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-04T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-18T08:47:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp\" \/>\n<meta name=\"author\" content=\"Andrea Lam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andrea Lam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/andrea-lam\/\",\"@type\":\"Person\",\"@name\":\"Andrea Lam\"}],\"headline\":\"Scaling out read workloads in Azure Database for MySQL\",\"datePublished\":\"2019-03-04T00:00:00+00:00\",\"dateModified\":\"2025-06-18T08:47:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/\"},\"wordCount\":416,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp\",\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/\",\"name\":\"Scaling out read workloads in Azure Database for MySQL | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp\",\"datePublished\":\"2019-03-04T00:00:00+00:00\",\"dateModified\":\"2025-06-18T08:47:30+00:00\",\"description\":\"For read-heavy workloads that you are looking to scale out, you can use read replicas, which are now generally available to all Azure Database for MySQL users.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Scaling out read workloads in Azure Database for MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Scaling out read workloads in Azure Database for MySQL | Microsoft Azure Blog","description":"For read-heavy workloads that you are looking to scale out, you can use read replicas, which are now generally available to all Azure Database for MySQL users.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Scaling out read workloads in Azure Database for MySQL | Microsoft Azure Blog","og_description":"For read-heavy workloads that you are looking to scale out, you can use read replicas, which are now generally available to all Azure Database for MySQL users.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2019-03-04T00:00:00+00:00","article_modified_time":"2025-06-18T08:47:30+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp","type":"","width":"","height":""}],"author":"Andrea Lam","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Andrea Lam","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/andrea-lam\/","@type":"Person","@name":"Andrea Lam"}],"headline":"Scaling out read workloads in Azure Database for MySQL","datePublished":"2019-03-04T00:00:00+00:00","dateModified":"2025-06-18T08:47:30+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/"},"wordCount":416,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp","articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/","name":"Scaling out read workloads in Azure Database for MySQL | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp","datePublished":"2019-03-04T00:00:00+00:00","dateModified":"2025-06-18T08:47:30+00:00","description":"For read-heavy workloads that you are looking to scale out, you can use read replicas, which are now generally available to all Azure Database for MySQL users.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/03\/3a953a83-bd83-4e72-8ed7-b310bc9722d5.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/scaling-out-read-workloads-in-azure-database-for-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Scaling out read workloads in Azure Database for MySQL"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=1614"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1614\/revisions"}],"predecessor-version":[{"id":42215,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1614\/revisions\/42215"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=1614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=1614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=1614"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=1614"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=1614"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=1614"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=1614"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=1614"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=1614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}