{"id":19025,"date":"2017-02-17T09:00:00","date_gmt":"2017-02-17T17:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=19025"},"modified":"2024-01-22T22:50:44","modified_gmt":"2024-01-23T06:50:44","slug":"sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/","title":{"rendered":"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups"},"content":{"rendered":"<p>This post was authored by Mihaela Blendea, Senior Program Manager, SQL Server<\/p>\n<p>In keeping with our goal to enable the same High Availability and Disaster Recovery solutions on all platforms supported by SQL Server, today Microsoft is excited to announce the preview of Always On Availability Groups for Linux in SQL Server v.Next Community Technology Preview (CTP) 1.3. This technology adds to the HADR options available for SQL Server on Linux, having previously enabled shared disk failover cluster instance capabilities.<\/p>\n<p>First released with SQL Server 2012 and enhanced in the 2014 and 2016 releases, Always On Availability Groups is SQL Server&#8217;s flagship solution for HADR. It provides High Availability for groups of databases on top of direct attached storage, supporting multiple active secondary replicas for integrated HA\/DR, automatic failure detection, fast transparent failover, and read load balancing. This broad set of capabilities is enabling customers to meet the strictest availability SLA requirements for their mission- critical workloads.<\/p>\n<p>Here is an overview of the scenarios that Always On Availability Groups are enabling for SQL Server v.Next:<\/p>\n<h2>Run mission-critical application using SQL Server running on Linux<\/h2>\n<p>Always On Availability Groups make it easy for your applications to meet rigorous business continuity requirements. This feature is now available on all Linux OS distributions SQL Server v.Next supports \u2014 Red Hat Enterprise Linux, Ubuntu and SUSE Linux Enterprise Server. Also, all capabilities that make Availability Groups a flexible, integrated and efficient HADR solution are available on Linux as well:<\/p>\n<ul>\n<li><b><i>Multidatabase failover<\/i><\/b> \u2013 an availability group supports a failover environment for a set of user databases, known as availability databases.<\/li>\n<li><b><i>Fast failure detection and failover<\/i><\/b> \u2013 as a resource in a highly available cluster, an availability group benefits from built-in cluster intelligence for immediate failover detection and failover action.<\/li>\n<li><b><i>Transparent failover using availability group listener<\/i><\/b> \u2013 enables client to use single connection string to primary or secondary databases that does not change in case of failover.<\/li>\n<li><b><i>Multiple sync\/async secondary replicas<\/i><\/b> \u2013 an availability group supports up to eight secondary replicas. The availability mode determines whether the primary replica waits (synchronous replica) or not (asynchronous replica) to commit transactions on a database until a given secondary replica has written the transaction log records to disk.<\/li>\n<li><b><i>Manual\/automatic failover with no data loss <\/i><\/b>\u2013 failover to a synchronized secondary replica can be triggered automatically by the cluster or on demand by the database administrator.<b><i><\/i><\/b><\/li>\n<li><b><i>Active secondary replicas available for read\/backup workloads<\/i><\/b> \u2013 one or more secondary replicas can be configured to support read-only access to secondary databases and\/or to permit backups on secondary databases.<\/li>\n<li><b><i>Automatic seeding<\/i><\/b> \u2013 SQL Server automatically creates the secondary replicas for every database in the availability group.<\/li>\n<li><b><i>Read-only routing<\/i><\/b> \u2013 SQL Server routes incoming connections to an availability group listener to a secondary replica that is configured to allow read-only workloads.<\/li>\n<li><b><i>Database level health monitoring and failover trigger<\/i><\/b> \u2013 enhanced database-level monitoring and diagnostics.<\/li>\n<li><b><i>Disaster Recovery<\/i><\/b> <b><i>configurations<\/i><\/b> \u2013 with Distributed Availability Groups or multisubnet availability group setup.<\/li>\n<\/ul>\n<p>Here is an illustration of a HADR configuration that an enterprise building a mission-critical application using SQL Server running on Linux can use to achieve: application-level protection (two synchronized secondary replicas), compliance with business continuity regulations (DR replica on remote site) as well as enhance performance (offload reporting and backup workloads to active secondary replicas):<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px;padding-left: 0px;padding-right: 0px;border-width: 0px\" title=\"clip_image002\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png\" alt=\"clip_image002\" width=\"1186\" height=\"864\" border=\"0\" \/><\/a><\/p>\n<p><i>Fig. 1<\/i> <i>Always On Availability Groups as an Integrated and Flexible HADR Solution on Linux<\/i><\/p>\n<p>On Windows, Always On depends on Windows Server Failover Cluster (WSFC) for distributed metadata storage, failure detection and failover orchestration. On Linux, we are enabling Availability Groups to integrate natively with your choice of clustering technology. For example, in preview today SQL Server v.Next integrates with Pacemaker, a popular Linux clustering technology. Users can add a previously configured SQL Server Availability Group as a resource to a Pacemaker cluster and all the orchestration regarding monitoring, failure detection and failover is taken care of. To achieve this, customers will use the SQL Server Resource Agent for Pacemaker available with the <b><i>mssql-server-ha<\/i><\/b> package, that is installed alongside <b><i>mssql-server<\/i><\/b>.<\/p>\n<h2>Workload load balancing for increased scale and performance<\/h2>\n<p>Previously, users had to set up a cluster to load balance read workloads for their application using readable secondary replicas. Configuring and operating a cluster implied a lot of manageability overhead, if HA was not the goal.<\/p>\n<p>Users can now create a group of replicated databases and leverage the fastest replication technology for SQL Server to offload secondary read-only workloads from the primary replica. If the goal is to conserve resources for mission-critical workloads running on the primary, users can now use read-only routing or directly connect to readable secondary replicas, without depending on integration with any clustering technology. These new capabilities are available for SQL Server running on both Windows and Linux platforms.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image008_thumb1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px;padding-left: 0px;padding-right: 0px;border-width: 0px\" title=\"clip_image008\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image008_thumb1.png\" alt=\"clip_image008\" width=\"1186\" height=\"503\" border=\"0\" \/><\/a><\/p>\n<p><i>Fig. 2 Group of Read-Only Replicated Databases to Load Balance Read-Only Workloads<\/i><\/p>\n<p>Note this is not a high-availability setup, as there is no \u201cfabric\u201d to monitor and coordinate failure detection and automatic failover. For users who need HADR capabilities, we recommend they use a cluster manager (WSFC on Windows or Pacemaker on Linux).<\/p>\n<h2>Seamless cross-platform migration<\/h2>\n<p>By setting up a cross-platform Distributed Availability Group, users can do a live migration of their SQL Server workloads from Windows to Linux or vice versa. We do not recommend running in this configuration in a steady state as there is no cluster manager for cross-platform orchestration, but it is the fastest solution for a cross-platform migration with minimum downtime.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image010_thumb1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px;padding-left: 0px;padding-right: 0px;border-width: 0px\" title=\"clip_image010\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image010_thumb1.png\" alt=\"clip_image010\" width=\"1186\" height=\"623\" border=\"0\" \/><\/a><\/p>\n<p><i>Fig. 3 Cross-Platform Live Migration Using Distributed Availability Groups<\/i><\/p>\n<p>Please visit our <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-business-continuity-dr\">reference documentation on business continuity<\/a> for SQL Server on Linux for more specifics on how integration with Pacemaker clustering is achieved in all supported OS flavors and end-to-end functional samples.<\/p>\n<p>Today\u2019s announcement marks the first preview of new Always On Availability Groups capabilities: Linux platform support for HADR as well as new scenarios like creating a cluster-independent group of replicated databases for offloading read-only traffic. Availability Groups are available on all platforms and OS versions that SQL Server v.Next is running on. In upcoming releases, we are going to enhance these capabilities by providing high-availability solutions for containerized environments as well as tooling support for an integrated experience. Stay tuned!<\/p>\n<h2>Get started<\/h2>\n<p>You can get started with many of these capabilities today:<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-business-continuity-dr\">Business Continuity for SQL Server on Linux guide<\/a><\/li>\n<\/ul>\n<h4><\/h4>\n<h2>Learn more<\/h2>\n<ul>\n<li>Read <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/\">detailed documentation<\/a>.<\/li>\n<li><a href=\"https:\/\/info.microsoft.com\/sql-server-on-linux-town-hall-high-availability-register.html\">Register<\/a> for next Engineering Town Hall with focus on High Availability and Disaster Recovery in SQL Server on Linux.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This post was authored by Mihaela Blendea, Senior Program Manager, SQL Server In keeping with our goal to enable the same High Availability and Disaster Recovery solutions on all platforms supported by SQL Server, today Microsoft is excited to announce the preview of Always On Availability Groups for Linux in SQL Server v.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2409],"content-type":[2421],"topic":[2469],"coauthors":[2487],"class_list":["post-19025","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2017-on-linux","content-type-announcements","topic-high-performance-database","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-alway-1593580309-407","review-flag-and-o-1593580423-560"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server on Linux: Mission-critical HADR with Always On Availability Groups - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This post was authored by Mihaela Blendea, Senior Program Manager, SQL Server In keeping with our goal to enable the same High Availability and Disaster Recovery solutions on all platforms supported by SQL Server, today Microsoft is excited to announce the preview of Always On Availability Groups for Linux in SQL Server v.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-17T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups\",\"datePublished\":\"2017-02-17T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/\"},\"wordCount\":1078,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/\",\"name\":\"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png\",\"datePublished\":\"2017-02-17T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png\",\"width\":1186,\"height\":864,\"caption\":\"clip_image002_thumb8.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups - Microsoft SQL Server Blog","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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups - Microsoft SQL Server Blog","og_description":"This post was authored by Mihaela Blendea, Senior Program Manager, SQL Server In keeping with our goal to enable the same High Availability and Disaster Recovery solutions on all platforms supported by SQL Server, today Microsoft is excited to announce the preview of Always On Availability Groups for Linux in SQL Server v.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2017-02-17T17:00:00+00:00","article_modified_time":"2024-01-23T06:50:44+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png","type":"","width":"","height":""}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups","datePublished":"2017-02-17T17:00:00+00:00","dateModified":"2024-01-23T06:50:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/"},"wordCount":1078,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/","name":"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png","datePublished":"2017-02-17T17:00:00+00:00","dateModified":"2024-01-23T06:50:44+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/02\/clip_image002_thumb8.png","width":1186,"height":864,"caption":"clip_image002_thumb8.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/02\/17\/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server on Linux: Mission-critical HADR with Always On Availability Groups"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/19025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=19025"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/19025\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=19025"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=19025"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=19025"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=19025"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=19025"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=19025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}