--- title: Scaling Database Availability Without Disruptio | daily.dev description: SingleStore's Online AZ Migration allows databases to switch between single-AZ and multi-AZ deployments without downtime or application disruption. Unlike... canonical: https://daily.dev/posts/scaling-database-availability-without-disruptio-vsm7mgcus twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Scaling Database Availability Without Disruptio | daily.dev og:description: SingleStore's Online AZ Migration allows databases to switch between single-AZ and multi-AZ deployments without downtime or application disruption. Unlike... og:url: https://daily.dev/posts/scaling-database-availability-without-disruptio-vsm7mgcus og:image: https://api.daily.dev/og/posts/vsM7MgCUS.png og:image:alt: Scaling Database Availability Without Disruptio og:image:width: 1200 og:image:height: 630 og:locale: en --- [SingleStore](https://daily.dev/sources/singlestore) [Read post](https://api.daily.dev/r/vsM7MgCUS) # [Scaling Database Availability Without Disruptio](https://api.daily.dev/r/vsM7MgCUS "Go to post") SingleStore's Online AZ Migration allows databases to switch between single-AZ and multi-AZ deployments without downtime or application disruption. Unlike traditional databases that tie availability topology to a single primary server, SingleStore distributes data across independently managed partitions. This means changing availability configuration is simply a matter of redistributing partitions across nodes while queries, transactions, and connections continue uninterrupted. The feature works in both directions — upgrading to multi-AZ for business-critical workloads or downgrading to single-AZ to cut costs on dev/test environments. The post argues this is an architectural advantage of distributed SQL over traditional primary-replica database designs. [#database](/tags/database "Check all #database posts")[#backend](/tags/backend "Check all #backend posts")[#singlestore](/tags/singlestore "Check all #singlestore posts") Jul 21•7m read time•From [singlestore.com](https://api.daily.dev/r/vsM7MgCUS "singlestore.com") [](https://api.daily.dev/r/vsM7MgCUS "Go to post") Table of contents [Availability in Traditional Databases](https://api.daily.dev/r/vsM7MgCUS?a=availability-in-traditional-databases "Availability in Traditional Databases")[Distributed SQL Changes What "The Database" Means](https://api.daily.dev/r/vsM7MgCUS?a=distributed-sql-changes-what-the-database-means "Distributed SQL Changes What "The Database" Means")[Partition Distribution and Leaf Fanout Failover](https://api.daily.dev/r/vsM7MgCUS?a=partition-distribution-and-leaf-fanout-failover "Partition Distribution and Leaf Fanout Failover")[Online AZ Migration](https://api.daily.dev/r/vsM7MgCUS?a=online-az-migration "Online AZ Migration")[Why Enterprise Customers Care](https://api.daily.dev/r/vsM7MgCUS?a=why-enterprise-customers-care "Why Enterprise Customers Care")[More Than a Feature](https://api.daily.dev/r/vsM7MgCUS?a=more-than-a-feature "More Than a Feature") 2K Impressions1 Upvote Comment Bookmark Copy Share your thoughtsPost [](https://daily.dev/sources/singlestore) [SingleStore](https://daily.dev/sources/singlestore "https://daily.dev/sources/singlestore") SingleStore Blog offers insights, tutorials, and updates on SingleStore, a distributed SQL database ... Read more 54 Followers • 866 Upvotes #### Would you recommend this post? Copy link WhatsApp Facebook X New Squad Copy linkShare with your friends 1 ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Scaling Database Availability Without Disruptio","url":"https://daily.dev/posts/scaling-database-availability-without-disruptio-vsm7mgcus","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/scaling-database-availability-without-disruptio-vsm7mgcus"},"datePublished":"2026-07-21T16:04:19.283Z","dateModified":"2026-07-21T16:04:40.891Z","description":"SingleStore's Online AZ Migration allows databases to switch between single-AZ and multi-AZ deployments without downtime or application disruption. Unlike...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/5157980586bf7b62ea73fe9de07fec09?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/5157980586bf7b62ea73fe9de07fec09?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"SingleStore","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"SingleStore","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/e2118b72d715435c84d6060bbe11d275","url":"https://daily.dev/sources/singlestore"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/scaling-database-availability-without-disruptio-vsm7mgcus","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,backend,singlestore","timeRequired":"PT7M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"SingleStore","item":"https://daily.dev/sources/singlestore"},{"@type":"ListItem","position":3,"name":"Scaling Database Availability Without Disruptio"}]} ```