{"id":34292,"date":"2024-08-15T10:56:06","date_gmt":"2024-08-15T08:56:06","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=34292"},"modified":"2024-08-15T10:56:10","modified_gmt":"2024-08-15T08:56:10","slug":"setting-up-mariadb-galera-cluster","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/","title":{"rendered":"Setting up MariaDB Galera Cluster"},"content":{"rendered":"\n<p>In this blog I will show you how you can setup a basic MariaDB Galera Cluster on Debian 11 (bullseye).<br>If you wish to have a more general overview first you can have a look here: <a href=\"https:\/\/mariadb.com\/kb\/en\/what-is-mariadb-galera-cluster\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/mariadb.com\/kb\/en\/what-is-mariadb-galera-cluster\/<\/a> <br>For this we have 3 servers: galera-cluster-1a\/b\/c. The following steps will first be executed on my first node, galera-cluster-1a still these steps have to executed on the other nodes as well to build the whole cluster.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-1-installation\">Step 1: Installation<\/h2>\n\n\n\n<p>First the servers will be prepared for the installation. This includes different packages to be installed and ports to be opened.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$ sudo apt update\ngalera-cluster-1a:~$ sudo apt-get install ufw\ngalera-cluster-1a:~$ sudo ufw enable\ngalera-cluster-1a:~$ sudo ufw allow 3306\ngalera-cluster-1a:~$ sudo ufw allow 4444\ngalera-cluster-1a:~$ sudo ufw allow 4567\ngalera-cluster-1a:~$ sudo ufw allow 4568\ngalera-cluster-1a:~$ sudo ufw allow 22\n<\/pre><\/div>\n\n\n<p>Installing MariaDB 11.3.2 and other packages<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$ sudo apt-get install libsnmp-perl -y\ngalera-cluster-1a:~$ sudo curl -LsS -O https:\/\/downloads.mariadb.com\/MariaDB\/mariadb_repo_setup\ngalera-cluster-1a:~$ sudo bash mariadb_repo_setup --os-type=debian --os-version=bullseye --mariadb-server-version=11.3.2\ngalera-cluster-1a:~$ sudo wget http:\/\/ftp.us.debian.org\/debian\/pool\/main\/r\/readline5\/libreadline5_5.2+dfsg-3+b13_amd64.deb\ngalera-cluster-1a:~$ sudo dpkg -i libreadline5_5.2+dfsg-3+b13_amd64.deb\ngalera-cluster-1a:~$ sudo apt-get update\ngalera-cluster-1a:~$ sudo apt-get install mariadb-server mariadb-client -y\ngalera-cluster-1a:~$ sudo systemctl enable mariadb\nsudo apt-get install percona-toolkit -y\n<\/pre><\/div>\n\n\n<p>Now you can login to MariaDB and check the version<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$ mariadb\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 32\nServer version: 11.3.2-MariaDB-1:11.3.2+maria~deb11 mariadb.org binary distribution\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\nType &#039;help;&#039; or &#039;\\h&#039; for help. Type &#039;\\c&#039; to clear the current input statement.\n<\/pre><\/div>\n\n\n<p>For the final touch for the basic installation of MariaDB we are going to secure it. Answering yes to all the changes it proposes.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$ sudo mariadb-secure-installation \n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-2-configuring-mariadb-server\">Step 2: Configuring MariaDB server<\/h2>\n\n\n\n<p>We recommend creating a dedicated backup user for mariabackup like this:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$ mariadb\nMariaDB &#x5B;(none)]&amp;gt; create user &#039;mariabackup&#039;@&#039;%&#039; identified by &#039;XXX&#039;;\nQuery OK, 0 rows affected (0.001 sec)\nMariaDB &#x5B;(none)]&amp;gt; GRANT RELOAD, PROCESS, LOCK TABLES, REPLICATION CLIENT ON *.* TO &#039;mariabackup&#039;@&#039;%&#039;;\nQuery OK, 0 rows affected (0.001 sec)\nMariaDB &#x5B;(none)]&amp;gt; create user &#039;mariabackup&#039;@&#039;localhost&#039; identified by &#039;XXX&#039;;\nQuery OK, 0 rows affected (0.001 sec)\nMariaDB &#x5B;(none)]&amp;gt; GRANT RELOAD, PROCESS, LOCK TABLES, REPLICATION CLIENT ON *.* TO &#039;mariabackup&#039;@&#039;localhost&#039;;\nQuery OK, 0 rows affected (0.001 sec)\nMariaDB &#x5B;(none)]&amp;gt; flush privileges;\nMariaDB &#x5B;(none)]&amp;gt; exit\n<\/pre><\/div>\n\n\n<p>Creating a dedicated directory for logs.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsudo mkdir \/var\/log\/mariadb\nsudo chown mysql:mysql \/var\/log\/mariadb \n<\/pre><\/div>\n\n\n<p>In the \/etc\/mysql\/mariadb.conf.d\/50-server.cnf file we add the following options at the end to the [mariadb-11.3] section.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n# This group is only read by MariaDB-11.3 servers.\n# If you use the same .cnf file for MariaDB of different versions,\n# use this group for options that older servers don&#039;t understand\n&#x5B;mariadb-11.3]\nlog_warnings=2\nlog_error=\/var\/log\/mysql\/mariadb.err\ngeneral_log = 1\ngeneral_log_file = \/var\/log\/mysql\/mariadb.log\n\n&#x5B;mysqldump]\nuser=dump\npassword=XXX\nmax_allowed_packet = 512M\n\n&#x5B;mariabackup]\nuser=mariabackup\npassword=XXX\ndatabases-exclude=lost+found\n<\/pre><\/div>\n\n\n<p>If you want to use mariabackup for backups and replication you will have to create the user and add the last section [mariabackup]<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-3-configuring-galera-cluster\">Step 3: Configuring Galera Cluster<\/h2>\n\n\n\n<p>Change the galera config file to the following. It is also possible to use the IPs instead of hostnames.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$ cat \/etc\/mysql\/mariadb.conf.d\/60-galera.cnf\n&#x5B;galera]\n# Mandatory settings\nwsrep_on = ON\nwsrep_cluster_name = MariaDB Galera Cluster\nwsrep_cluster_address = gcomm:\/\/galera-cluster-1a,galera-cluster-1b,galera-cluster-1c\nwsrep_provider = \/usr\/lib\/galera\/libgalera_smm.so\nbinlog_format = row\ndefault_storage_engine = InnoDB\ninnodb_autoinc_lock_mode = 2\n# Allow server to accept connections on all interfaces.\nbind-address = 0.0.0.0\n\n# Optional settings\nwsrep_slave_threads = 1\ninnodb_flush_log_at_trx_commit = 0\nwsrep_sst_auth = mariabackup:manager\nwsrep_sst_method=mariabackup\nwsrep_node_address=galera-cluster-1a\nwsrep_sst_receive_address= galera-cluster-1a\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-4-bootstrapping-galera-cluster\">Step 4: Bootstrapping Galera Cluster<\/h2>\n\n\n\n<p>Now everything is ready and we can start the MariaDB Server in cluster mode.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$  sudo systemctl stop mariadb.service\ngalera-cluster-1a:~$  sudo galera_new_cluster\n<\/pre><\/div>\n\n\n<p>Lets check if the one node cluster has successfully started. The start position on the very first start should look like the following<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$ ps -f -u mysql\nUID        PID  PPID  C STIME TTY          TIME CMD\nmysql     2081     1  0 14:37 ?        00:00:00 \/usr\/sbin\/mariadbd --wsrep-new-cluster --wsrep_start_position= 00000000-0000-0000-0000-000000000000:-1 \n<\/pre><\/div>\n\n\n<p>Login to your instance and check the cluster size<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$ mariadb\n\nMariaDB &#x5B;(none)]&amp;gt; show global status like &#039;wsrep_cluster_size&#039;;\n+--------------------+-------+\n| Variable_name      | Value |\n+--------------------+-------+\n| wsrep_cluster_size | 1     |\n+--------------------+-------+\nMariaDB &#x5B;(none)]&amp;gt; quit\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-5-setting-up-the-other-servers\">Step 5: Setting up the other servers<\/h2>\n\n\n\n<p>Repeat steps 1-3 on the other two nodes but you do not have to bootstrap these nodes.<br>Simply restart the mariadb.service at the end for them to sync with the cluster. <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1b:~$ sudo systemctl restart mariadb.service\ngalera-cluster-1c:~$ sudo systemctl restart mariadb.service \n<\/pre><\/div>\n\n\n<p>Afterwards you can check the cluster size again.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngalera-cluster-1a:~$ mariadb\nMariaDB &#x5B;(none)]&amp;gt; show global status like &#039;wsrep_cluster_size&#039;;\n+--------------------+-------+\n| Variable_name      | Value |\n+--------------------+-------+\n| wsrep_cluster_size | 3     |\n+--------------------+-------+\n<\/pre><\/div>\n\n\n<p>Check out this blog about using mariabackup to repair your replication: <a href=\"https:\/\/www.dbi-services.com\/blog\/mariadb-repair-replication-through-db-restore-mariabackup\/\">https:\/\/www.dbi-services.com\/blog\/mariadb-repair-replication-through-db-restore-mariabackup\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog I will show you how you can setup a basic MariaDB Galera Cluster on Debian 11 (bullseye).If you wish to have a more general overview first you can have a look here: https:\/\/mariadb.com\/kb\/en\/what-is-mariadb-galera-cluster\/ For this we have 3 servers: galera-cluster-1a\/b\/c. The following steps will first be executed on my first node, galera-cluster-1a [&hellip;]<\/p>\n","protected":false},"author":53,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1726],"tags":[3409,141,812],"type_dbi":[3410,3328],"class_list":["post-34292","post","type-post","status-publish","format-standard","hentry","category-mariadb","tag-galera-cluster","tag-mariadb","tag-setup","type-galera-cluster","type-mariadb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Setting up MariaDB Galera Cluster - dbi Blog<\/title>\n<meta name=\"description\" content=\"How to setup a MariaDB Galera Cluster on Debian 11. Going through the needed steps from prerequisites to full cluster creation.\" \/>\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.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting up MariaDB Galera Cluster\" \/>\n<meta property=\"og:description\" content=\"How to setup a MariaDB Galera Cluster on Debian 11. Going through the needed steps from prerequisites to full cluster creation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-15T08:56:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-15T08:56:10+00:00\" \/>\n<meta name=\"author\" content=\"Daniel Burgert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Burgert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setting-up-mariadb-galera-cluster\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setting-up-mariadb-galera-cluster\\\/\"},\"author\":{\"name\":\"Daniel Burgert\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/2b718a1932b49a1889d67f9a86a89049\"},\"headline\":\"Setting up MariaDB Galera Cluster\",\"datePublished\":\"2024-08-15T08:56:06+00:00\",\"dateModified\":\"2024-08-15T08:56:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setting-up-mariadb-galera-cluster\\\/\"},\"wordCount\":349,\"commentCount\":0,\"keywords\":[\"Galera Cluster\",\"MariaDB\",\"Setup\"],\"articleSection\":[\"MariaDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setting-up-mariadb-galera-cluster\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setting-up-mariadb-galera-cluster\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setting-up-mariadb-galera-cluster\\\/\",\"name\":\"Setting up MariaDB Galera Cluster - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2024-08-15T08:56:06+00:00\",\"dateModified\":\"2024-08-15T08:56:10+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/2b718a1932b49a1889d67f9a86a89049\"},\"description\":\"How to setup a MariaDB Galera Cluster on Debian 11. Going through the needed steps from prerequisites to full cluster creation.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setting-up-mariadb-galera-cluster\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setting-up-mariadb-galera-cluster\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setting-up-mariadb-galera-cluster\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting up MariaDB Galera Cluster\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/2b718a1932b49a1889d67f9a86a89049\",\"name\":\"Daniel Burgert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/588e7739ac2dce782acd95efdd53318b7fd00590c5bfadf19520a9ab57003e31?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/588e7739ac2dce782acd95efdd53318b7fd00590c5bfadf19520a9ab57003e31?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/588e7739ac2dce782acd95efdd53318b7fd00590c5bfadf19520a9ab57003e31?s=96&d=mm&r=g\",\"caption\":\"Daniel Burgert\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/daniel-burgert\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Setting up MariaDB Galera Cluster - dbi Blog","description":"How to setup a MariaDB Galera Cluster on Debian 11. Going through the needed steps from prerequisites to full cluster creation.","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.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/","og_locale":"en_US","og_type":"article","og_title":"Setting up MariaDB Galera Cluster","og_description":"How to setup a MariaDB Galera Cluster on Debian 11. Going through the needed steps from prerequisites to full cluster creation.","og_url":"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/","og_site_name":"dbi Blog","article_published_time":"2024-08-15T08:56:06+00:00","article_modified_time":"2024-08-15T08:56:10+00:00","author":"Daniel Burgert","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Daniel Burgert","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/"},"author":{"name":"Daniel Burgert","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2b718a1932b49a1889d67f9a86a89049"},"headline":"Setting up MariaDB Galera Cluster","datePublished":"2024-08-15T08:56:06+00:00","dateModified":"2024-08-15T08:56:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/"},"wordCount":349,"commentCount":0,"keywords":["Galera Cluster","MariaDB","Setup"],"articleSection":["MariaDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/","url":"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/","name":"Setting up MariaDB Galera Cluster - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2024-08-15T08:56:06+00:00","dateModified":"2024-08-15T08:56:10+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2b718a1932b49a1889d67f9a86a89049"},"description":"How to setup a MariaDB Galera Cluster on Debian 11. Going through the needed steps from prerequisites to full cluster creation.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-mariadb-galera-cluster\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Setting up MariaDB Galera Cluster"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2b718a1932b49a1889d67f9a86a89049","name":"Daniel Burgert","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/588e7739ac2dce782acd95efdd53318b7fd00590c5bfadf19520a9ab57003e31?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/588e7739ac2dce782acd95efdd53318b7fd00590c5bfadf19520a9ab57003e31?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/588e7739ac2dce782acd95efdd53318b7fd00590c5bfadf19520a9ab57003e31?s=96&d=mm&r=g","caption":"Daniel Burgert"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-burgert\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34292","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=34292"}],"version-history":[{"count":41,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34292\/revisions"}],"predecessor-version":[{"id":34507,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34292\/revisions\/34507"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=34292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=34292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=34292"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=34292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}