{"id":1671,"date":"2018-03-25T13:08:47","date_gmt":"2018-03-25T06:08:47","guid":{"rendered":"https:\/\/www.routecloud.net\/blog\/?p=1671"},"modified":"2018-03-25T17:33:50","modified_gmt":"2018-03-25T10:33:50","slug":"high-availability-database-menggunakan-galera-cluster","status":"publish","type":"post","link":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/","title":{"rendered":"High-Availability Database menggunakan Galera Cluster"},"content":{"rendered":"<p>Salah satu point penting dalam sebuah aplikasi\/website adalah database server. Banyak admin yang membuat environment server mereka hanya dengan 1 (single) database karena kesulitan untuk maintain multi database server. Membuat Master-Slave atau Master-Master replication pada database adalah hal yang cukup tricky, untuk instalasi cukup mudah namun implementasi\/penyesuaian ke aplikasi terkadang lupa dilakukan.<\/p>\n<p>Untuk menghilangkan hal-hal seperti itu, lebih mudah untuk implementasi high-availability databases menggunakan galera cluster, karena semua database server akan menjadi server aktif yang dapat melayani read\/write ke database.\u00a0 di artikel ini akan dibahas secara jelas bagaimana membangun high-availability database menggunakan galera cluster.<\/p>\n<p>Pada tutorial ini yang akan dibuat adalah galera cluster dengan menggunakan 3 nodes menggunakan <strong>MariaDB 10.1<\/strong> pada <strong>CentOS 7<\/strong> seperti gambar 1.<\/p>\n<p><a href=\"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png\"><img loading=\"lazy\" class=\"size-full wp-image-1672 aligncenter\" src=\"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png\" alt=\"\" width=\"371\" height=\"300\" srcset=\"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png 371w, https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication-300x243.png 300w, https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication-200x162.png 200w\" sizes=\"(max-width: 371px) 100vw, 371px\" \/><\/a><\/p>\n<p style=\"text-align: center;\">Gambar 1. Topology Galera Cluster<\/p>\n<p><!--more--><\/p>\n<p><strong>SEMUA NODE<\/strong><\/p>\n<p>Tambah repository MariaDB pada masing-masing node<\/p>\n<pre class=\"lang:default decode:true\">[root@node-1 ~]# vim \/etc\/yum.repos.d\/MariaDB.repo<\/pre>\n<p>Tambahkan informasi repository MariaDB dan save filenya<\/p>\n<pre class=\"lang:default decode:true\">[mariadb]\r\nname = MariaDB\r\nbaseurl = http:\/\/yum.mariadb.org\/10.1\/centos7-amd64\r\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\ngpgcheck=1\r\n<\/pre>\n<p>Install package MariaDB<\/p>\n<pre class=\"lang:default decode:true\">[root@node-1 ~]# yum -y install MariaDB-server MariaDB-client MariaDB-common\r\n<\/pre>\n<p>Menjalankan service MariaDB<\/p>\n<pre class=\"lang:default decode:true\">[root@node-1 ~]# systemctl start mariadb\r\n<\/pre>\n<p>Enable autostart saat booting<\/p>\n<pre class=\"lang:default decode:true\">[root@node-1 ~]# systemctl enable mariadb\r\n<\/pre>\n<p>Setup MariaDB<\/p>\n<pre class=\"lang:default decode:true \">[root@node-1 ~]# mysql_secure_installation\r\nEnter current password for root (enter for none): &lt;ENTER&gt;\r\nSet root password? [Y\/n] Y\r\nRemove anonymous users? [Y\/n] Y\r\nDisallow root login remotely? [Y\/n] Y\r\nRemove test database and access to it? [Y\/n] Y\r\nReload privilege tables now? [Y\/n] Y\r\n<\/pre>\n<p>Stop service MariaDB di semua node<\/p>\n<pre class=\"lang:default decode:true\">[root@node-1 ~]# systemctl stop mariadb\r\n<\/pre>\n<p>Buat file log untuk MariaDB<\/p>\n<pre class=\"lang:default decode:true\">[root@node-1 ~]# touch \/var\/log\/mariadb.log\r\n<\/pre>\n<p>Atur permission untuk file tersebut<\/p>\n<pre class=\"lang:default decode:true\">[root@node-1 ~]# chown mysql:mysql \/var\/log\/mariadb.log\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>NODE-1<\/strong><\/p>\n<p>Konfigurasi Galera pada node-1<\/p>\n<pre class=\"lang:default decode:true\">[root@node-1 ~]# vim \/etc\/my.cnf.d\/server.cnf\r\n<\/pre>\n<p>Tambahkan konfigurasi dibawah ini lalu save<\/p>\n<pre class=\"lang:default decode:true\">[mysqld]\r\nlog_error=\/var\/log\/mariadb.log\r\n\r\n[galera]\r\nbinlog_format=ROW\r\ndefault-storage-engine=innodb\r\ninnodb_autoinc_lock_mode=2\r\nbind-address=0.0.0.0\r\nwsrep_on=ON\r\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so\r\nwsrep_cluster_address=\"gcomm:\/\/192.168.1.201,192.168.1.202,192.168.1.203\"\r\nwsrep_cluster_name=\"rcn-cluster\"\r\nwsrep_sst_method=rsync\r\nwsrep_node_address=\"192.168.1.201\"\r\nwsrep_node_name=\"node-1\"\r\n<\/pre>\n<p>Start Galera Cluster di node-1<\/p>\n<pre class=\"lang:default decode:true\">[root@node-1 ~]# galera_new_cluster\r\n<\/pre>\n<p>Verifikasi Galera Cluster di node-1 sudah aktif dengan melihat listen port<\/p>\n<pre class=\"lang:default decode:true \">[root@node-1 ~]# lsof -i:4567\r\nCOMMAND PID USER FD TYPE DEVICE SIZE\/OFF NODE NAME\r\nmysqld 1298 mysql 11u IPv4 16499 0t0 TCP *:tram (LISTEN)\r\n\r\n[root@node-1 ~]# lsof -i:3306\r\nCOMMAND PID USER FD TYPE DEVICE SIZE\/OFF NODE NAME\r\nmysqld 1298 mysql 26u IPv4 16516 0t0 TCP *:mysql (LISTEN)\r\n<\/pre>\n<p>Cek jumlah node Galera Cluster di mysql status (harusnya hanya 1 karena ini baru 1 node yang di setup)<\/p>\n<pre class=\"lang:default decode:true \">[root@node-1 ~]# mysql -uroot -p\r\nMariaDB [(none)]&gt; SHOW STATUS LIKE 'wsrep_cluster_size';\r\n+--------------------+-------+\r\n| Variable_name      | Value |\r\n+--------------------+-------+\r\n| wsrep_cluster_size | 1     |\r\n+--------------------+-------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Node LAINNYA<\/strong><\/p>\n<p>Konfigurasi pada node yang lain<\/p>\n<pre class=\"lang:default decode:true\">[root@node-2 ~]# vim \/etc\/my.cnf.d\/server.cnf\r\n<\/pre>\n<p>Tambahkan konfigurasi dibawah ini<\/p>\n<pre class=\"lang:default decode:true\">[mysqld]\r\nlog_error=\/var\/log\/mariadb.log\r\n\r\n[galera]\r\nbinlog_format=ROW\r\ndefault-storage-engine=innodb\r\ninnodb_autoinc_lock_mode=2\r\nbind-address=0.0.0.0\r\nwsrep_on=ON\r\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so\r\nwsrep_cluster_address=\"gcomm:\/\/192.168.1.201,192.168.1.202,192.168.1.203\"\r\nwsrep_cluster_name=\"rcn-cluster\"\r\nwsrep_sst_method=rsync\r\nwsrep_node_address=\"192.168.1.202\"              #yang harus dirubah\r\nwsrep_node_name=\"node-2\"                        #yang harus dirubah\r\n<\/pre>\n<p>Start service MariaDB<\/p>\n<pre class=\"lang:default decode:true\">[root@node-2 ~]# systemctl start mariadb\r\n<\/pre>\n<p>Verifikasi jumlah node pada Galera Cluster<\/p>\n<pre class=\"lang:default decode:true\">MariaDB [(none)]&gt; SHOW STATUS LIKE 'wsrep_cluster_size';\r\n+--------------------+-------+\r\n| Variable_name      | Value |\r\n+--------------------+-------+\r\n| wsrep_cluster_size | 3     |\r\n+--------------------+-------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n<p>Cek status Galera Cluster<\/p>\n<pre class=\"lang:default decode:true \">MariaDB [(none)]&gt; SHOW STATUS LIKE 'wsrep%';\r\n+------------------------------+-------------------------------------------------------------+\r\n| Variable_name                | Value                                                       |\r\n+------------------------------+-------------------------------------------------------------+\r\n| wsrep_apply_oooe             | 0.000000                                                    |\r\n| wsrep_apply_oool             | 0.000000                                                    |\r\n| wsrep_apply_window           | 0.000000                                                    |\r\n| wsrep_causal_reads           | 0                                                           |\r\n| wsrep_cert_deps_distance     | 0.000000                                                    |\r\n| wsrep_cert_index_size        | 0                                                           |\r\n| wsrep_cert_interval          | 0.000000                                                    |\r\n| wsrep_cluster_conf_id        | 3                                                           |\r\n| wsrep_cluster_size           | 3                                                           |\r\n| wsrep_cluster_state_uuid     | a5a504c0-3013-11e8-95e1-ee37252c7bb8                        |\r\n| wsrep_cluster_status         | Primary                                                     |\r\n| wsrep_commit_oooe            | 0.000000                                                    |\r\n| wsrep_commit_oool            | 0.000000                                                    |\r\n| wsrep_commit_window          | 0.000000                                                    |\r\n| wsrep_connected              | ON                                                          |\r\n| wsrep_desync_count           | 0                                                           |\r\n| wsrep_evs_delayed            |                                                             |\r\n| wsrep_evs_evict_list         |                                                             |\r\n| wsrep_evs_repl_latency       | 0\/0\/0\/0\/0                                                   |\r\n| wsrep_evs_state              | OPERATIONAL                                                 |\r\n| wsrep_flow_control_paused    | 0.000000                                                    |\r\n| wsrep_flow_control_paused_ns | 0                                                           |\r\n| wsrep_flow_control_recv      | 0                                                           |\r\n| wsrep_flow_control_sent      | 0                                                           |\r\n| wsrep_gcomm_uuid             | a5a49b35-3013-11e8-8ad5-0be86fe5f5a3                        |\r\n| wsrep_incoming_addresses     | 192.168.1.202:3306,192.168.1.203:3306,192.168.1.201:3306    |\r\n| wsrep_last_committed         | 0                                                           |\r\n| wsrep_local_bf_aborts        | 0                                                           |\r\n| wsrep_local_cached_downto    | 18446744073709551615                                        |\r\n| wsrep_local_cert_failures    | 0                                                           |\r\n| wsrep_local_commits          | 0                                                           |\r\n| wsrep_local_index            | 2                                                           |\r\n| wsrep_local_recv_queue       | 0                                                           |\r\n| wsrep_local_recv_queue_avg   | 0.142857                                                    |\r\n| wsrep_local_recv_queue_max   | 2                                                           |\r\n| wsrep_local_recv_queue_min   | 0                                                           |\r\n| wsrep_local_replays          | 0                                                           |\r\n| wsrep_local_send_queue       | 0                                                           |\r\n| wsrep_local_send_queue_avg   | 0.000000                                                    |\r\n| wsrep_local_send_queue_max   | 1                                                           |\r\n| wsrep_local_send_queue_min   | 0                                                           |\r\n| wsrep_local_state            | 4                                                           |\r\n| wsrep_local_state_comment    | Synced                                                      |\r\n| wsrep_local_state_uuid       | a5a504c0-3013-11e8-95e1-ee37252c7bb8                        |\r\n| wsrep_protocol_version       | 7                                                           |\r\n| wsrep_provider_name          | Galera                                                      |\r\n| wsrep_provider_vendor        | Codership Oy &lt;info@codership.com&gt;                           |\r\n| wsrep_provider_version       | 25.3.22(r3764)                                              |\r\n| wsrep_ready                  | ON                                                          |\r\n| wsrep_received               | 7                                                           |\r\n| wsrep_received_bytes         | 698                                                         |\r\n| wsrep_repl_data_bytes        | 0                                                           |\r\n| wsrep_repl_keys              | 0                                                           |\r\n| wsrep_repl_keys_bytes        | 0                                                           |\r\n| wsrep_repl_other_bytes       | 0                                                           |\r\n| wsrep_replicated             | 0                                                           |\r\n| wsrep_replicated_bytes       | 0                                                           |\r\n| wsrep_thread_count           | 2                                                           |\r\n+------------------------------+-------------------------------------------------------------+\r\n58 rows in set (0.00 sec)\r\n<\/pre>\n<p>Testing Galera Cluster dengan cara membuat database<\/p>\n<pre class=\"lang:default decode:true\">MariaDB [(none)]&gt; SHOW DATABASES;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n+--------------------+\r\n3 rows in set (0.00 sec)\r\n\r\nMariaDB [(none)]&gt; CREATE DATABASE rcn;\r\nQuery OK, 1 row affected (0.00 sec)\r\n\r\nMariaDB [(none)]&gt; SHOW DATABASES;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| rcn                |\r\n+--------------------+\r\n4 rows in set (0.00 sec)\r\n<\/pre>\n<p>Cek pada node yang lain<\/p>\n<pre class=\"lang:default decode:true\">[root@node-2 ~]# mysql -uroot -p\r\nEnter password:\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 4\r\nServer version: 10.1.31-MariaDB MariaDB Server\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]&gt; SHOW DATABASES;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| rcn                |\r\n+--------------------+\r\n4 rows in set (0.00 sec)\r\n<\/pre>\n<p>Sekian dulu untuk tutorialnya nanti akan dilanjut untuk performance Galera Cluster dibandingkan dengan Single Database Server.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Salah satu point penting dalam sebuah aplikasi\/website adalah database server. Banyak admin yang membuat environment server mereka hanya dengan 1 (single) database karena kesulitan untuk maintain multi database server. Membuat Master-Slave atau Master-Master replication pada database adalah hal yang cukup tricky, untuk instalasi cukup mudah namun implementasi\/penyesuaian ke aplikasi terkadang lupa dilakukan. Untuk menghilangkan hal-hal [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[153,151,152,154],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.5.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>High-Availability Database menggunakan Galera Cluster - Routecloud Indonesia - Blog<\/title>\n<meta name=\"description\" content=\"High-Availability Database menggunakan Galera Cluster dengan menggunakan MariaDB 10.1 pada CentOS 7\" \/>\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.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"High-Availability Database menggunakan Galera Cluster - Routecloud Indonesia - Blog\" \/>\n<meta property=\"og:description\" content=\"High-Availability Database menggunakan Galera Cluster dengan menggunakan MariaDB 10.1 pada CentOS 7\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/\" \/>\n<meta property=\"og:site_name\" content=\"Routecloud Indonesia - Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-25T06:08:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-03-25T10:33:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"arisyi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.routecloud.net\/blog\/#organization\",\"name\":\"Routecloud Indonesia\",\"url\":\"https:\/\/www.routecloud.net\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.routecloud.net\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2017\/03\/logo_routecloud_horz_2x_b.png\",\"contentUrl\":\"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2017\/03\/logo_routecloud_horz_2x_b.png\",\"width\":400,\"height\":80,\"caption\":\"Routecloud Indonesia\"},\"image\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.routecloud.net\/blog\/#website\",\"url\":\"https:\/\/www.routecloud.net\/blog\/\",\"name\":\"Routecloud Indonesia - Blog\",\"description\":\"Share Your Knowledge\",\"publisher\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.routecloud.net\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png\",\"contentUrl\":\"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png\",\"width\":371,\"height\":300},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#webpage\",\"url\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/\",\"name\":\"High-Availability Database menggunakan Galera Cluster - Routecloud Indonesia - Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#primaryimage\"},\"datePublished\":\"2018-03-25T06:08:47+00:00\",\"dateModified\":\"2018-03-25T10:33:50+00:00\",\"description\":\"High-Availability Database menggunakan Galera Cluster dengan menggunakan MariaDB 10.1 pada CentOS 7\",\"breadcrumb\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.routecloud.net\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"High-Availability Database menggunakan Galera Cluster\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/#\/schema\/person\/bababa304857e6ec9533ffe7b108ec8c\"},\"headline\":\"High-Availability Database menggunakan Galera Cluster\",\"datePublished\":\"2018-03-25T06:08:47+00:00\",\"dateModified\":\"2018-03-25T10:33:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#webpage\"},\"wordCount\":264,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png\",\"keywords\":[\"cluster\",\"database\",\"galera\",\"high-availability\"],\"articleSection\":[\"Linux\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.routecloud.net\/blog\/#\/schema\/person\/bababa304857e6ec9533ffe7b108ec8c\",\"name\":\"arisyi\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.routecloud.net\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad901c240e8ac1273cd2e05801a73235?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad901c240e8ac1273cd2e05801a73235?s=96&d=mm&r=g\",\"caption\":\"arisyi\"},\"sameAs\":[\"http:\/\/arisyi.net\"],\"url\":\"https:\/\/www.routecloud.net\/blog\/author\/arisyi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"High-Availability Database menggunakan Galera Cluster - Routecloud Indonesia - Blog","description":"High-Availability Database menggunakan Galera Cluster dengan menggunakan MariaDB 10.1 pada CentOS 7","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.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/","og_locale":"en_US","og_type":"article","og_title":"High-Availability Database menggunakan Galera Cluster - Routecloud Indonesia - Blog","og_description":"High-Availability Database menggunakan Galera Cluster dengan menggunakan MariaDB 10.1 pada CentOS 7","og_url":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/","og_site_name":"Routecloud Indonesia - Blog","article_published_time":"2018-03-25T06:08:47+00:00","article_modified_time":"2018-03-25T10:33:50+00:00","og_image":[{"url":"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png"}],"twitter_card":"summary","twitter_misc":{"Written by":"arisyi","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.routecloud.net\/blog\/#organization","name":"Routecloud Indonesia","url":"https:\/\/www.routecloud.net\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/www.routecloud.net\/blog\/#logo","inLanguage":"en-US","url":"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2017\/03\/logo_routecloud_horz_2x_b.png","contentUrl":"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2017\/03\/logo_routecloud_horz_2x_b.png","width":400,"height":80,"caption":"Routecloud Indonesia"},"image":{"@id":"https:\/\/www.routecloud.net\/blog\/#logo"}},{"@type":"WebSite","@id":"https:\/\/www.routecloud.net\/blog\/#website","url":"https:\/\/www.routecloud.net\/blog\/","name":"Routecloud Indonesia - Blog","description":"Share Your Knowledge","publisher":{"@id":"https:\/\/www.routecloud.net\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.routecloud.net\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#primaryimage","inLanguage":"en-US","url":"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png","contentUrl":"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png","width":371,"height":300},{"@type":"WebPage","@id":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#webpage","url":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/","name":"High-Availability Database menggunakan Galera Cluster - Routecloud Indonesia - Blog","isPartOf":{"@id":"https:\/\/www.routecloud.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#primaryimage"},"datePublished":"2018-03-25T06:08:47+00:00","dateModified":"2018-03-25T10:33:50+00:00","description":"High-Availability Database menggunakan Galera Cluster dengan menggunakan MariaDB 10.1 pada CentOS 7","breadcrumb":{"@id":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.routecloud.net\/blog\/"},{"@type":"ListItem","position":2,"name":"High-Availability Database menggunakan Galera Cluster"}]},{"@type":"Article","@id":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#article","isPartOf":{"@id":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#webpage"},"author":{"@id":"https:\/\/www.routecloud.net\/blog\/#\/schema\/person\/bababa304857e6ec9533ffe7b108ec8c"},"headline":"High-Availability Database menggunakan Galera Cluster","datePublished":"2018-03-25T06:08:47+00:00","dateModified":"2018-03-25T10:33:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#webpage"},"wordCount":264,"commentCount":3,"publisher":{"@id":"https:\/\/www.routecloud.net\/blog\/#organization"},"image":{"@id":"https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#primaryimage"},"thumbnailUrl":"https:\/\/www.routecloud.net\/blog\/wp-content\/uploads\/2018\/03\/galera_replication.png","keywords":["cluster","database","galera","high-availability"],"articleSection":["Linux"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.routecloud.net\/blog\/high-availability-database-menggunakan-galera-cluster\/#respond"]}]},{"@type":"Person","@id":"https:\/\/www.routecloud.net\/blog\/#\/schema\/person\/bababa304857e6ec9533ffe7b108ec8c","name":"arisyi","image":{"@type":"ImageObject","@id":"https:\/\/www.routecloud.net\/blog\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/ad901c240e8ac1273cd2e05801a73235?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad901c240e8ac1273cd2e05801a73235?s=96&d=mm&r=g","caption":"arisyi"},"sameAs":["http:\/\/arisyi.net"],"url":"https:\/\/www.routecloud.net\/blog\/author\/arisyi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/posts\/1671"}],"collection":[{"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/comments?post=1671"}],"version-history":[{"count":20,"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/posts\/1671\/revisions"}],"predecessor-version":[{"id":1692,"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/posts\/1671\/revisions\/1692"}],"wp:attachment":[{"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/media?parent=1671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/categories?post=1671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.routecloud.net\/blog\/wp-json\/wp\/v2\/tags?post=1671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}