{"id":654,"date":"2024-07-12T08:00:00","date_gmt":"2024-07-12T13:00:00","guid":{"rendered":"https:\/\/www.sqltabletalk.com\/?p=654"},"modified":"2024-07-05T22:47:55","modified_gmt":"2024-07-06T03:47:55","slug":"creating-sql-server-ags-on-linux-part-1-installing-and-configuring-pacemaker","status":"publish","type":"post","link":"https:\/\/www.sqltabletalk.com\/?p=654","title":{"rendered":"Creating SQL Server AGs on Linux: Part 1 &#8211; Installing and Configuring Pacemaker"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>Welcome to the first part of our series on setting up SQL Server availability groups on Linux. This series is designed to guide SQL Server DBAs, especially those with limited Linux experience, through the process of configuring a highly available SQL Server environment using Pacemaker on Ubuntu 20.04.<\/p>\n<p>Our goal is to set up a three-node availability group (AG) with two synchronous replicas to ensure data redundancy and high availability. In this series, we will cover the following key steps:<\/p>\n<ul>\n<li><strong>Configuring Pacemaker:<\/strong> Installing and setting up Pacemaker on all nodes to manage high availability.<\/li>\n<li><strong>Creating the Availability Group:<\/strong> Enabling High Availability Disaster Recovery (HADR) on SQL Server and creating the availability group.<\/li>\n<li><strong>Creating Resources:<\/strong> Configuring Pacemaker resources and constraints to manage the availability group.<\/li>\n<li><strong>Failover Demonstration:<\/strong> Showing how to manually failover between the nodes to ensure proper functionality.<\/li>\n<li><strong>Basic Troubleshooting:<\/strong> Discussing common issues and troubleshooting steps to maintain a healthy cluster.<\/li>\n<\/ul>\n<p>By the end of this series, you will have a fully functional SQL Server availability group on Linux, providing robust high availability for your SQL Server instances. You will need three Ubuntu 20.04 hosts with SQL Server for Linux installed and initial configuration completed. This series does not cover the installation of SQL Server on Ubuntu because we have covered this in a previous post:<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"mGjMOgSjpb\"><p><a href=\"https:\/\/www.sqltabletalk.com\/?p=72\">SQL Server on Linux: Getting Started with SQL Server 2022 on Ubuntu 22.04<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;SQL Server on Linux: Getting Started with SQL Server 2022 on Ubuntu 22.04&#8221; &#8212; SQL Table Talk\" src=\"https:\/\/www.sqltabletalk.com\/?p=72&#038;embed=true#?secret=rVcCxQH5xm#?secret=mGjMOgSjpb\" data-secret=\"mGjMOgSjpb\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<h3>Step 1: Install and Configure Pacemaker on All Nodes<\/h3>\n<p>To ensure high availability for SQL Server on Linux, we need to install Pacemaker on all our nodes. Pacemaker is a cluster resource manager that ensures your applications remain available in case of failures. Start by updating your package lists and installing the necessary Pacemaker packages. On each node, open a terminal and run the following command:<\/p>\n<pre><code>sudo apt update -y &amp;&amp; sudo apt install -y pacemaker pcs pacemaker-cli-utils resource-agents fence-agents netcat<\/code><\/pre>\n<p>This command updates the package list and installs Pacemaker along with additional tools and agents needed for managing resources and cluster communication.<\/p>\n<p>Next, set a password for the <code>hacluster<\/code> user. The <code>hacluster<\/code> user is a special user created by the Pacemaker installation, and we need to set a password for it to enable communication between cluster nodes. Run the following command:<\/p>\n<pre><code>sudo passwd hacluster<\/code><\/pre>\n<p>You will be prompted to enter a new password. For the purposes of this series, we will use &#8216;password&#8217;, but you should choose a secure password for your production environment.<\/p>\n<p>After setting the password, enable and start the <code>pcsd<\/code> service, which is responsible for managing cluster communication and configuration. Execute the following commands:<\/p>\n<pre><code>sudo systemctl enable pcsd\nsudo systemctl start pcsd<\/code><\/pre>\n<p>Finally, enable the Pacemaker service itself to ensure it starts on boot:<\/p>\n<pre><code>sudo systemctl enable pacemaker<\/code><\/pre>\n<p>Repeat these steps on all three nodes to ensure they are properly configured for Pacemaker.<\/p>\n<h3>Step 2: Create and Start the Pacemaker Cluster<\/h3>\n<p>With Pacemaker installed and configured on all nodes, the next step is to create and start the Pacemaker cluster. Begin by destroying any existing clusters to ensure a clean setup. Run this command on each node:<\/p>\n<pre><code>sudo pcs cluster destroy<\/code><\/pre>\n<p>This command ensures that any previous cluster configurations are removed, preventing potential conflicts.<\/p>\n<p>Next, authenticate the nodes to allow them to communicate securely. This step is performed only on <code>vm0<\/code>, the primary node. Execute the following command:<\/p>\n<pre><code>sudo pcs host auth vm0 vm1 vm2 -u hacluster<\/code><\/pre>\n<p>You will be prompted to enter the <code>hacluster<\/code> password for each node. This command sets up authentication for all three nodes using the <code>hacluster<\/code> user.<\/p>\n<p>Now, set up the cluster. Still on <code>vm0<\/code>, run:<\/p>\n<pre><code>sudo pcs cluster setup linuxclustersql vm0 vm1 vm2<\/code><\/pre>\n<p>This command initializes the cluster with the name <code>linuxclustersql<\/code> and includes <code>vm0<\/code>, <code>vm1<\/code>, and <code>vm2<\/code> as the cluster nodes.<\/p>\n<p>Start the cluster on all nodes with the following commands:<\/p>\n<pre><code>sudo pcs cluster start --all\nsudo pcs cluster enable --all<\/code><\/pre>\n<p>These commands start the Pacemaker cluster services and ensure they are enabled on all nodes, making the cluster operational.<\/p>\n<h3>Step 3: Configure Cluster Properties<\/h3>\n<p>With the cluster up and running, we need to configure some properties to optimize its behavior. First, disable STONITH (Shoot The Other Node In The Head). STONITH is a fencing mechanism to ensure data integrity, but for simplicity, we will disable it in this tutorial. Run this command on <code>vm0<\/code>:<\/p>\n<pre><code>sudo pcs property set stonith-enabled=false<\/code><\/pre>\n<p>Next, set the cluster recheck interval to 2 minutes. This property determines how often the cluster checks its status and performs any necessary recovery actions:<\/p>\n<pre><code>sudo pcs property set cluster-recheck-interval=2min<\/code><\/pre>\n<p>These configurations help streamline the cluster&#8217;s operation, ensuring it runs efficiently without unnecessary checks or disruptions.<\/p>\n<h3>Conclusion<\/h3>\n<p>In this first part of our series, we have successfully installed and configured Pacemaker on all nodes, created the Pacemaker cluster, and set essential cluster properties. These steps lay the foundation for building a highly available SQL Server environment on Linux. In the following posts, we will delve into enabling High Availability Disaster Recovery (HADR) on SQL Server and creating the availability group. We will also demonstrate how to manually failover between the nodes and discuss basic troubleshooting techniques to keep your cluster healthy. Stay tuned for more detailed guidance as we continue this journey towards robust SQL Server high availability on Linux.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post is the first part of a series on setting up SQL Server availability groups on Linux. It covers the installation and configuration of Pacemaker on Ubuntu 20.04, creating the Pacemaker cluster, and configuring essential cluster properties. Designed for SQL Server DBAs with limited Linux experience, this guide lays the foundation for a robust high availability environment.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[36,40,20,21],"tags":[38,189,19,187,190,131,28,188],"class_list":["post-654","post","type-post","status-publish","format-standard","hentry","category-availability-groups","category-sql-server-2022","category-sql-server-on-linux","category-tutorial","tag-availability-groups","tag-clustering","tag-linux","tag-pacemaker","tag-pacemaker-configuration","tag-sql-server","tag-sql-server-on-linux","tag-ubuntu"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating SQL Server Availability Groups on Linux: Part 1 - Installing and Configuring Pacemaker<\/title>\n<meta name=\"description\" content=\"This post is the first part of a series on setting up SQL Server availability groups on Linux. It covers the installation and configuration of Pacemaker on Ubuntu 20.04, creating the Pacemaker cluster, and configuring essential cluster properties. Designed for SQL Server DBAs with limited Linux experience, this guide lays the foundation for a robust high availability environment.\" \/>\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.sqltabletalk.com\/?p=654\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating SQL Server Availability Groups on Linux: Part 1 - Installing and Configuring Pacemaker\" \/>\n<meta property=\"og:description\" content=\"This post is the first part of a series on setting up SQL Server availability groups on Linux. It covers the installation and configuration of Pacemaker on Ubuntu 20.04, creating the Pacemaker cluster, and configuring essential cluster properties. Designed for SQL Server DBAs with limited Linux experience, this guide lays the foundation for a robust high availability environment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqltabletalk.com\/?p=654\" \/>\n<meta property=\"og:site_name\" content=\"SQL Table Talk\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-12T13:00:00+00:00\" \/>\n<meta name=\"author\" content=\"Stephen Planck\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stephen Planck\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=654#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=654\"},\"author\":{\"name\":\"Stephen Planck\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"headline\":\"Creating SQL Server AGs on Linux: Part 1 &#8211; Installing and Configuring Pacemaker\",\"datePublished\":\"2024-07-12T13:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=654\"},\"wordCount\":786,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"keywords\":[\"availability groups\",\"Clustering\",\"Linux\",\"Pacemaker\",\"Pacemaker Configuration\",\"SQL Server\",\"SQL Server on Linux\",\"Ubuntu\"],\"articleSection\":[\"Availability Groups\",\"SQL Server 2022\",\"SQL Server on Linux\",\"Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=654#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=654\",\"url\":\"https:\/\/www.sqltabletalk.com\/?p=654\",\"name\":\"Creating SQL Server Availability Groups on Linux: Part 1 - Installing and Configuring Pacemaker\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\"},\"datePublished\":\"2024-07-12T13:00:00+00:00\",\"description\":\"This post is the first part of a series on setting up SQL Server availability groups on Linux. It covers the installation and configuration of Pacemaker on Ubuntu 20.04, creating the Pacemaker cluster, and configuring essential cluster properties. Designed for SQL Server DBAs with limited Linux experience, this guide lays the foundation for a robust high availability environment.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=654#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=654\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=654#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqltabletalk.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating SQL Server AGs on Linux: Part 1 &#8211; Installing and Configuring Pacemaker\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\",\"url\":\"https:\/\/www.sqltabletalk.com\/\",\"name\":\"SQL Table Talk\",\"description\":\"Breaking Down SQL Server, One Post at a Time.\",\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqltabletalk.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\",\"name\":\"Stephen Planck\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"caption\":\"Stephen Planck\"},\"logo\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/dexterwiki.com\",\"https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI\",\"https:\/\/www.youtube.com\/linuxmate\"],\"url\":\"https:\/\/www.sqltabletalk.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating SQL Server Availability Groups on Linux: Part 1 - Installing and Configuring Pacemaker","description":"This post is the first part of a series on setting up SQL Server availability groups on Linux. It covers the installation and configuration of Pacemaker on Ubuntu 20.04, creating the Pacemaker cluster, and configuring essential cluster properties. Designed for SQL Server DBAs with limited Linux experience, this guide lays the foundation for a robust high availability environment.","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.sqltabletalk.com\/?p=654","og_locale":"en_US","og_type":"article","og_title":"Creating SQL Server Availability Groups on Linux: Part 1 - Installing and Configuring Pacemaker","og_description":"This post is the first part of a series on setting up SQL Server availability groups on Linux. It covers the installation and configuration of Pacemaker on Ubuntu 20.04, creating the Pacemaker cluster, and configuring essential cluster properties. Designed for SQL Server DBAs with limited Linux experience, this guide lays the foundation for a robust high availability environment.","og_url":"https:\/\/www.sqltabletalk.com\/?p=654","og_site_name":"SQL Table Talk","article_published_time":"2024-07-12T13:00:00+00:00","author":"Stephen Planck","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stephen Planck","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqltabletalk.com\/?p=654#article","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/?p=654"},"author":{"name":"Stephen Planck","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"headline":"Creating SQL Server AGs on Linux: Part 1 &#8211; Installing and Configuring Pacemaker","datePublished":"2024-07-12T13:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqltabletalk.com\/?p=654"},"wordCount":786,"commentCount":0,"publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"keywords":["availability groups","Clustering","Linux","Pacemaker","Pacemaker Configuration","SQL Server","SQL Server on Linux","Ubuntu"],"articleSection":["Availability Groups","SQL Server 2022","SQL Server on Linux","Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqltabletalk.com\/?p=654#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqltabletalk.com\/?p=654","url":"https:\/\/www.sqltabletalk.com\/?p=654","name":"Creating SQL Server Availability Groups on Linux: Part 1 - Installing and Configuring Pacemaker","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/#website"},"datePublished":"2024-07-12T13:00:00+00:00","description":"This post is the first part of a series on setting up SQL Server availability groups on Linux. It covers the installation and configuration of Pacemaker on Ubuntu 20.04, creating the Pacemaker cluster, and configuring essential cluster properties. Designed for SQL Server DBAs with limited Linux experience, this guide lays the foundation for a robust high availability environment.","breadcrumb":{"@id":"https:\/\/www.sqltabletalk.com\/?p=654#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqltabletalk.com\/?p=654"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqltabletalk.com\/?p=654#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqltabletalk.com\/"},{"@type":"ListItem","position":2,"name":"Creating SQL Server AGs on Linux: Part 1 &#8211; Installing and Configuring Pacemaker"}]},{"@type":"WebSite","@id":"https:\/\/www.sqltabletalk.com\/#website","url":"https:\/\/www.sqltabletalk.com\/","name":"SQL Table Talk","description":"Breaking Down SQL Server, One Post at a Time.","publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqltabletalk.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0","name":"Stephen Planck","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","caption":"Stephen Planck"},"logo":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/dexterwiki.com","https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI","https:\/\/www.youtube.com\/linuxmate"],"url":"https:\/\/www.sqltabletalk.com\/?author=1"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=654"}],"version-history":[{"count":3,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/654\/revisions"}],"predecessor-version":[{"id":675,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/654\/revisions\/675"}],"wp:attachment":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}