{"id":7062,"date":"2023-10-23T21:41:44","date_gmt":"2023-10-23T21:41:44","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=7062"},"modified":"2023-10-23T21:41:45","modified_gmt":"2023-10-23T21:41:45","slug":"installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/","title":{"rendered":"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/galera_cluster_fr.jpg\" alt=\"installation et configuration un cluster Galera \u00e0 deux n\u0153uds pour MySQL\" class=\"wp-image-7069\" srcset=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/galera_cluster_fr.jpg 1200w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/galera_cluster_fr-300x169.jpg 300w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/galera_cluster_fr-1024x576.jpg 1024w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/galera_cluster_fr-768x432.jpg 768w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/galera_cluster_fr-150x84.jpg 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"introduction\">Introduction<\/h2>\n\n\n\n<p><strong>Galera Cluster<\/strong> permet de construire un cluster de bases de donn\u00e9es <strong>MySQL \/ MariaDB<\/strong> hautement disponible sans compromettre la coh\u00e9rence des donn\u00e9es. En r\u00e9pliquant les donn\u00e9es entre les n\u0153uds en temps r\u00e9el, Galera assure une disponibilit\u00e9 continue m\u00eame en cas de d\u00e9faillance de n\u0153uds individuels.<\/p>\n\n\n\n<p>Dans ce tutoriel complet, nous allons parcourir les \u00e9tapes de configuration d&#8217;un cluster Galera \u00e0 deux n\u0153uds sur Ubuntu\/Debian et CentOS\/RHEL Linux.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"pr%C3%A9requis\">Pr\u00e9requis<\/h3>\n\n\n\n<p>Avant de commencer, assurez-vous de disposer de:<\/p>\n\n\n\n<ul>\n<li>2 serveurs ou VM avec Ubuntu 18.04+\/Debian 9+ ou CentOS 7+\/RHEL 7+ install\u00e9s.<\/li>\n\n\n\n<li>Au moins 2 Go de RAM et 2 cores de CPU sur chaque n\u0153ud.<\/li>\n\n\n\n<li>Acc\u00e8s root aux serveurs via SSH.<\/li>\n\n\n\n<li>MySQL server d\u00e9j\u00e0 install\u00e9 sur les deux n\u0153uds. Version 5.7+ recommand\u00e9e.<\/li>\n\n\n\n<li>R\u00e8gles de pare-feu de base configur\u00e9es pour autoriser le trafic sur les ports 3306, 4567, 4568 et 4444.<\/li>\n<\/ul>\n\n\n\n<p>Nous ex\u00e9cuterons la plupart des commandes en tant qu&#8217;utilisateur root ou avec les privil\u00e8ges sudo.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"installation-de-galera-et-des-packages-associ%C3%A9s\">Installation de Galera et des packages associ\u00e9s<\/h2>\n\n\n\n<p>Nous commen\u00e7ons par installer le logiciel Galera Cluster et d&#8217;autres utilitaires n\u00e9cessaires au bon fonctionnement du cluster.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"sur-ubuntudebian\">Sur Ubuntu\/Debian<\/h3>\n\n\n\n<p>Mettre \u00e0 jour les indexes des d\u00e9p\u00f4ts apt et installer les paquets requis :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ apt update\n$ apt install galera-4 mariadb-server socat python3-mysql.connector<\/code><\/pre>\n\n\n\n<p>Ceci installe:<\/p>\n\n\n\n<ul>\n<li>galera-4 &#8211; frameworks Galera Cluster<\/li>\n\n\n\n<li>mariadb-server &#8211; Pour le serveur de bases de donn\u00e9es MySQL<\/li>\n\n\n\n<li>socat &#8211; Pour tester et surveiller les clusters<\/li>\n\n\n\n<li>python3-mysql.connector &#8211; Pour les connexions MySQL depuis Python<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"sur-centosrhel\">Sur CentOS\/RHEL<\/h3>\n\n\n\n<p>Activez les d\u00e9p\u00f4ts EPEL qui fournissent les paquets Galera :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ yum install epel-release<\/code><\/pre>\n\n\n\n<p>Maintenant, installez Galera et ses d\u00e9pendances :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ yum install galera mariadb-server rsync socat mysql-connector-python<\/code><\/pre>\n\n\n\n<p>Ceci installe:<\/p>\n\n\n\n<ul>\n<li>galera &#8211; Galera Cluster<\/li>\n\n\n\n<li>mariadb-server &#8211; Le serveur MySQL<\/li>\n\n\n\n<li>rsync &#8211; Pour les transferts d&#8217;instantan\u00e9s SST<\/li>\n\n\n\n<li>socat &#8211; Utilitaire de surveillance<\/li>\n\n\n\n<li>mysql-connector-python &#8211; Connecteur Python pour MySQL<\/li>\n<\/ul>\n\n\n\n<p>Galera Cluster est maintenant pr\u00eat \u00e0 \u00eatre configur\u00e9 sur les deux n\u0153uds.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"configuration-de-mysql-pour-galera\">Configuration de MySQL pour Galera<\/h2>\n\n\n\n<p>Pour que MySQL utilise Galera, nous devons configurer quelques options dans&nbsp;<code>my.cnf<\/code>.<\/p>\n\n\n\n<p>Ouvrez le fichier de configuration :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ nano \/etc\/my.cnf<\/code><\/pre>\n\n\n\n<p>Ajoutez ce qui suit sous&nbsp;<code>[mysqld]<\/code>&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"properties\" class=\"language-properties\">binlog_format=ROW\ndefault-storage-engine=innodb \ninnodb_autoinc_lock_mode=2\nbind-address=0.0.0.0\n  \n# Param\u00e8tres Galera \nwsrep_provider=\/usr\/lib64\/galera-4\/libgalera_smm.so\nwsrep_cluster_name='my_galera_cluster'\nwsrep_cluster_address=\"gcomm:\/\/node1,node2\"\n\n# Ceci uniquement sur le n\u0153ud 1\nwsrep_node_address='192.168.1.101'\nwsrep_node_name='node1'\n\n# Ceci uniquement sur le n\u0153ud 2\nwsrep_node_address='192.168.1.102' \nwsrep_node_name='node2'\n\nwsrep_sst_method=rsync<\/code><\/pre>\n\n\n\n<p>Le&nbsp;<code>wsrep_cluster_address<\/code>&nbsp;contient la liste des adresses IP des n\u0153uds du cluster.<\/p>\n\n\n\n<p><code>wsrep_node_address<\/code>&nbsp;et&nbsp;<code>wsrep_node_name<\/code>&nbsp;doivent \u00eatre uniques sur chaque serveur.<\/p>\n\n\n\n<p>Enregistrez et fermez le fichier apr\u00e8s avoir fait les changements.<\/p>\n\n\n\n<p>Faites ceci sur les deux serveurs, en rempla\u00e7ant les IP et noms selon vos serveurs.<\/p>\n\n\n\n<p>Cela configure MySQL pour utiliser le plugin Galera pour la r\u00e9plication.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"d%C3%A9marrage-du-cluster-galera\">D\u00e9marrage du cluster Galera<\/h2>\n\n\n\n<p>La configuration \u00e9tant en place, nous sommes pr\u00eats \u00e0 d\u00e9marrer le cluster.<\/p>\n\n\n\n<p>D\u00e9marrez MySQL uniquement sur le premier n\u0153ud (node1) :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl start mysql\n<em># ou<\/em>\n$ systemctl start mariadb <\/code><\/pre>\n\n\n\n<p>Ceci va initialiser le cluster Galera.<\/p>\n\n\n\n<p>V\u00e9rifiez le statut MySQL et les variables wsrep :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -u root -e \"SHOW STATUS LIKE '%wsrep%';\"<\/code><\/pre>\n\n\n\n<p>Exemple de r\u00e9sultat :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">+-----------------------------+------------------------------------------+\n| Variable_name               | Value                                    |\n+-----------------------------+------------------------------------------+\n| wsrep_local_state_uuid      | af2a75b4-9e1c-11ed-9838-be4b133a6b15     |\n| wsrep_protocol_version      | 7                                        |\n| wsrep_last_committed        | 0                                        |\n| wsrep_replicated            | 0                                        |\n| wsrep_replicated_bytes      | 0                                        |\n| wsrep_received              | 1                                        |\n| wsrep_received_bytes        | 119                                      |\n| wsrep_local_commits         | 0                                        |\n| wsrep_local_cert_failures   | 0                                        |\n| wsrep_local_replays         | 0                                        |\n| wsrep_local_send_queue      | 0                                        |\n| wsrep_local_send_queue_avg  | 0.000000                                 |  \n| wsrep_local_recv_queue      | 0                                        |\n| wsrep_local_recv_queue_avg  | 0.000000                                 | \n| wsrep_cluster_size          | 1                                        | \n+-----------------------------+------------------------------------------+<\/code><\/pre>\n\n\n\n<p>Ceci confirme que Galera est op\u00e9rationnel. Notez que la taille du cluster local est de 1 pour le moment.<\/p>\n\n\n\n<p>Maintenant, d\u00e9marrez MySQL sur le second n\u0153ud pour le rejoindre au cluster :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl start mysql\n<em># ou <\/em>\n$ systemctl start mariadb<\/code><\/pre>\n\n\n\n<p>V\u00e9rifiez qu&#8217;il a rejoint le cluster avec succ\u00e8s :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -u root -e \"SHOW STATUS LIKE '%wsrep%';\" <\/code><\/pre>\n\n\n\n<p>Nous devrions maintenant voir la taille du cluster comme \u00e9tant 2 :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">| wsrep_cluster_size | 2 |<\/code><\/pre>\n\n\n\n<p>De plus, ex\u00e9cutez&nbsp;<code>mysql -e \"SHOW STATUS LIKE '%wsrep%';\"<\/code>&nbsp;sur le n\u0153ud 1 \u00e0 nouveau et les variables de statut doivent \u00eatre synchronis\u00e9es entre les deux n\u0153uds.<\/p>\n\n\n\n<p>Notre cluster Galera \u00e0 deux n\u0153uds est pr\u00eat !<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"test-du-fonctionnement-du-cluster\">Test du fonctionnement du cluster<\/h2>\n\n\n\n<p>Testons que la r\u00e9plication entre les deux n\u0153uds fonctionne comme pr\u00e9vu.<\/p>\n\n\n\n<p>Sur le n\u0153ud 1, cr\u00e9ez une base de test et ins\u00e9rez des donn\u00e9es :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CREATE DATABASE cluster_test;\nmysql&gt; USE cluster_test;  \nmysql&gt; CREATE TABLE test (id INT, message VARCHAR(20));\nmysql&gt; INSERT INTO test VALUES (1, 'Bonjour Galera');\nmysql&gt; SELECT * FROM test;\n+------+-----------------+\n| id   | message         |  \n+------+-----------------+\n|    1 | Bonjour Galera  |\n+------+-----------------+<\/code><\/pre>\n\n\n\n<p>Maintenant, v\u00e9rifiez le m\u00eame contenu de table depuis le n\u0153ud 2 :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; USE cluster_test;\nmysql&gt; SELECT * FROM test;\n+------+-----------------+\n| id   | message         |\n+------+-----------------+\n|    1 | Bonjour Galera  |  \n+------+-----------------+<\/code><\/pre>\n\n\n\n<p>La ligne a \u00e9t\u00e9 r\u00e9pliqu\u00e9e du n\u0153ud 1 vers le n\u0153ud 2 comme pr\u00e9vu.<\/p>\n\n\n\n<p>Testons aussi la r\u00e9cup\u00e9ration d&#8217;arr\u00eat. Arr\u00eatez MySQL sur le n\u0153ud 1 :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl stop mysql\n<em># ou<\/em>\n$ systemctl stop mariadb<\/code><\/pre>\n\n\n\n<p>Sur le n\u0153ud 2, connectez-vous \u00e0 MySQL et v\u00e9rifiez que les requ\u00eates fonctionnent toujours :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; USE cluster_test; \nmysql&gt; SELECT * FROM test;\n+------+-----------------+\n| id   | message         |\n+------+-----------------+\n|    1 | Bonjour Galera  |\n+------+-----------------+<\/code><\/pre>\n\n\n\n<p>Le n\u0153ud 2 reste op\u00e9rationnel malgr\u00e9 l&#8217;arr\u00eat du n\u0153ud 1 puisque toutes les donn\u00e9es sont r\u00e9pliqu\u00e9es.<\/p>\n\n\n\n<p>Red\u00e9marrez le n\u0153ud 1 :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl start mysql  \n<em># ou<\/em>\n$ systemctl start mariadb<\/code><\/pre>\n\n\n\n<p>Il va se resynchroniser automatiquement avec le n\u0153ud 2. Ex\u00e9cutez&nbsp;<code>SHOW STATUS LIKE '%wsrep%';<\/code>&nbsp;sur les deux n\u0153uds pour confirmer que les valeurs correspondent.<\/p>\n\n\n\n<p>Ceci d\u00e9montre la haute disponibilit\u00e9 fournie par Galera !<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"surveillance-et-gestion-du-cluster\">Surveillance et gestion du cluster<\/h2>\n\n\n\n<p>Maintenant que nous avons un cluster Galera op\u00e9rationnel, examinons quelques conseils pour le surveiller et le g\u00e9rer.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"v%C3%A9rification-du-statut-du-cluster\">V\u00e9rification du statut du cluster<\/h3>\n\n\n\n<p>Utilisez le daemon&nbsp;<code>garbd<\/code>&nbsp;pour v\u00e9rifier les statistiques de haut niveau du cluster :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ garbd -a gcomm:\/\/192.168.1.101,192.168.1.102 -g my_galera_cluster\nGalera cluster Node 1\/2 info:\n  evs::protover =&gt; 7\n  evs::uuid     =&gt; af2a75b4-9e1c-11ed-9838-be4b133a6b15\n  evs::status   =&gt; Primary\n  evs::state    =&gt; Synced\nGalera cluster Node 2\/2 info:\n  evs::protover =&gt; 7\n  evs::uuid     =&gt; af2a75b4-9e1c-11ed-9838-be4b133a6b15\n  evs::status   =&gt; Primary\n  evs::state    =&gt; Synced  <\/code><\/pre>\n\n\n\n<p>Cela montre que les deux n\u0153uds sont dans l&#8217;\u00e9tat Synced et font partie du m\u00eame cluster.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"surveillance-de-l%C3%A9tat-des-n%C5%93uds\">Surveillance de l&#8217;\u00e9tat des n\u0153uds<\/h3>\n\n\n\n<p>Utilisez&nbsp;<code>mysqladmin<\/code>&nbsp;pour v\u00e9rifier les variables Galera sur chaque n\u0153ud :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysqladmin -uroot -p -h192.168.1.101 variables | grep wsrep\n| wsrep_cluster_conf_id | 25 |\n| wsrep_cluster_size | 2 |\n| wsrep_cluster_state_uuid | af2a75b4-9e1c-11ed-9838-be4b133a6b15 |\n| wsrep_cluster_status | Primary |\n\n$ mysqladmin -uroot -p -h192.168.1.102 variables | grep wsrep\n| wsrep_cluster_conf_id | 25 |  \n| wsrep_cluster_size | 2 |\n| wsrep_cluster_state_uuid | af2a75b4-9e1c-11ed-9838-be4b133a6b15 |\n| wsrep_cluster_status | Primary |<\/code><\/pre>\n\n\n\n<p>Des valeurs comme la taille du cluster, l&#8217;UUID, le statut doivent correspondre sur tous les n\u0153uds.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"v%C3%A9rification-du-statut-de-transfert-sst\">V\u00e9rification du statut de transfert SST<\/h3>\n\n\n\n<p>Lorsqu&#8217;un nouveau n\u0153ud rejoint le cluster, le transfert d&#8217;\u00e9tat (SST) est utilis\u00e9 pour synchroniser les donn\u00e9es vers celui-ci.<\/p>\n\n\n\n<p>Surveillez la progression SST avec:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">$ mysql -e \"SHOW STATUS LIKE 'wsrep_local_state_uuid'\"  \n+----------------------------------+--------------------------------------+\n| Variable_name                    | Value                                |\n+----------------------------------+--------------------------------------+\n| wsrep_local_state_uuid           | af2a75b4-9e1c-11ed-9838-be4b133a6b15 | \n+----------------------------------+--------------------------------------+\n\n$ mysql -e \"SHOW STATUS LIKE 'wsrep_local_state_comment'\"\n+-----------------------------------+----------+\n| Variable_name                     | Value    |\n+-----------------------------------+----------+\n| wsrep_local_state_comment         | Synced   |\n+-----------------------------------+----------+<\/code><\/pre>\n\n\n\n<p>Pendant que le SST est en cours,&nbsp;<code>wsrep_local_state_comment<\/code>&nbsp;affichera le pourcentage de synchronisation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"v%C3%A9rification-du-statut-de-r%C3%A9cup%C3%A9ration\">V\u00e9rification du statut de r\u00e9cup\u00e9ration<\/h3>\n\n\n\n<p>Lorsqu&#8217;un n\u0153ud rejoint apr\u00e8s une d\u00e9connexion, le statut peut \u00eatre v\u00e9rifi\u00e9 avec :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt;SHOW STATUS WHERE `variable_name` LIKE'wsrep_%'; <\/code><\/pre>\n\n\n\n<p>Surveillez&nbsp;<code>wsrep_local_state_comment<\/code>&nbsp;pour des valeurs comme&nbsp;<code>Recovering<\/code>&nbsp;ou&nbsp;<code>Donor\/Desynced<\/code>&nbsp;pendant la r\u00e9cup\u00e9ration.<\/p>\n\n\n\n<p>Ainsi, les diff\u00e9rentes \u00e9tapes de synchronisation et r\u00e9cup\u00e9ration du cluster peuvent \u00eatre suivies.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"surveillance-de-la-taille-du-cluster\">Surveillance de la taille du cluster<\/h3>\n\n\n\n<p>Pour v\u00e9rifier le nombre de n\u0153uds dans le cluster :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SHOW STATUS LIKE 'wsrep_cluster_size';\n+--------------------+-------+ \n| Variable_name      | Value |\n+--------------------+-------+\n| wsrep_cluster_size | 2     |  \n+--------------------+-------+<\/code><\/pre>\n\n\n\n<p>Cela doit correspondre au nombre de n\u0153uds attendus.<\/p>\n\n\n\n<p>Nous pouvons aussi utiliser le script&nbsp;<code>clustercheck<\/code>&nbsp;pour surveiller la taille du cluster :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ clustercheck\nCluster is CORRECT (2 nodes)\n$<\/code><\/pre>\n\n\n\n<p>Cela avertira si des n\u0153uds sont manquants ou en surplus.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"v%C3%A9rification-de-la-coh%C3%A9rence-des-n%C5%93uds\">V\u00e9rification de la coh\u00e9rence des n\u0153uds<\/h3>\n\n\n\n<p>Le statut du cluster doit \u00eatre v\u00e9rifi\u00e9 pour s&#8217;assurer que tous les n\u0153uds contiennent les m\u00eames donn\u00e9es.<\/p>\n\n\n\n<p>La comparaison de la variable&nbsp;<code>wsrep_local_state_uuid<\/code>&nbsp;entre les n\u0153uds indique la coh\u00e9rence :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -e \"SHOW STATUS LIKE 'wsrep_local_state_uuid'\\G\" -h192.168.1.101\n   *************************** 1. row ***************************\n   Variable_name: wsrep_local_state_uuid\n        Value: af2a75b4-9e1c-11ed-9838-be4b133a6b15\n\n$ mysql -e \"SHOW STATUS LIKE 'wsrep_local_state_uuid'\\G\" -h192.168.1.102\n   *************************** 1. row ***************************\n   Variable_name: wsrep_local_state_uuid\n        Value: af2a75b4-9e1c-11ed-9838-be4b133a6b15<\/code><\/pre>\n\n\n\n<p>Si l&#8217;UUID correspond sur les n\u0153uds, les donn\u00e9es sont coh\u00e9rentes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"v%C3%A9rification-du-statut-des-connexions\">V\u00e9rification du statut des connexions<\/h3>\n\n\n\n<p>Utilisez&nbsp;<code>socat<\/code>&nbsp;pour v\u00e9rifier le statut de connexion TCP entre les n\u0153uds :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ socat - TCP:192.168.1.101:4567  \n&gt;\n$ socat - TCP:192.168.1.102:4567\n&gt; <\/code><\/pre>\n\n\n\n<p>Cela confirme que le port TCP 4567 est ouvert entre les n\u0153uds pour le trafic de r\u00e9plication du cluster Galera.<\/p>\n\n\n\n<p>Nous pouvons aussi utiliser MySQL pour v\u00e9rifier le statut de connexion :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SHOW STATUS WHERE `variable_name` LIKE '%connection%'; \n+-----------------------------+-------+\n| Variable_name               | Value |\n+-----------------------------+-------+\n| Slave_connections           | 0     |\n| Max_used_connections        | 2     |  \n| Aborted_connects            | 0     |\n| Max_used_connections        | 2     |\n+-----------------------------+-------+<\/code><\/pre>\n\n\n\n<p>Surveillez le nombre de connexions ouvertes pour d\u00e9tecter des probl\u00e8mes.<\/p>\n\n\n\n<p>Cela donne un aper\u00e7u de l&#8217;\u00e9tat g\u00e9n\u00e9ral du cluster et de la connectivit\u00e9.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"suivi-de-lhistorique-des-n%C5%93uds\">Suivi de l&#8217;historique des n\u0153uds<\/h3>\n\n\n\n<p>L&#8217;historique des n\u0153uds peut \u00eatre utile pour le d\u00e9pannage ou l&#8217;analyse d&#8217;\u00e9v\u00e9nements :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SHOW STATUS LIKE 'wsrep_local_state_uuid%';\n+--------------------------------+--------------------------------------+\n| Variable_name                  | Value                                |\n+--------------------------------+--------------------------------------+  \n| wsrep_local_state_uuid         | af2a75b4-9e1c-11ed-9838-be4b133a6b15 |\n| wsrep_local_state_uuid_history | af2a75b4-9e1c-11ed-9838-be4b133a6b15 |\n+--------------------------------+--------------------------------------+<\/code><\/pre>\n\n\n\n<p>Tous les anciens UUID de cluster seront ajout\u00e9s \u00e0&nbsp;<code>wsrep_local_state_uuid_history<\/code>&nbsp;lors d&#8217;\u00e9v\u00e9nements comme des r\u00e9cup\u00e9rations.<\/p>\n\n\n\n<p>De m\u00eame, le nombre de changements d&#8217;appartenance au cluster est suivi par :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SHOW STATUS LIKE 'wsrep_cluster_size_change%'; \n+-------------------------------+-------+\n| Variable_name                 | Value |\n+-------------------------------+-------+\n| wsrep_cluster_size_changes    | 1     |\n| wsrep_cluster_size_change_history | 1 |  \n+-------------------------------+-------+<\/code><\/pre>\n\n\n\n<p>Cela donne un aper\u00e7u de l&#8217;activit\u00e9 du cluster au fil du temps.<\/p>\n\n\n\n<p>En utilisant ces variables de statut et commandes, le cluster Galera peut \u00eatre surveill\u00e9 pour un fonctionnement ad\u00e9quat. Des probl\u00e8mes comme les d\u00e9connexions de n\u0153uds, le d\u00e9calage de r\u00e9plication ou la perte de coh\u00e9rence peuvent \u00eatre rapidement d\u00e9tect\u00e9s et d\u00e9bugg\u00e9s.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"configuration-de-larbitre-galera-facultative\">Configuration de l&#8217;arbitre Galera (facultative)<\/h2>\n\n\n\n<p>Pour un cluster \u00e0 deux n\u0153uds, nous devrions configurer un arbitre Galera pour \u00e9viter les sc\u00e9narios de split brain. L&#8217;arbitre est un processus l\u00e9ger qui fournit un quorum pour que le cluster d\u00e9termine quel n\u0153ud doit continuer \u00e0 fonctionner en cas de partition r\u00e9seau.<\/p>\n\n\n\n<p>Sur un troisi\u00e8me serveur, installez seulement le paquet&nbsp;<code>galera-4<\/code>&nbsp;ou&nbsp;<code>galera<\/code>.<\/p>\n\n\n\n<p>Modifiez&nbsp;<code>\/etc\/my.cnf<\/code>&nbsp;avec:<\/p>\n\n\n\n<pre title=\"\" class=\"wp-block-code\"><code lang=\"properties\" class=\"language-properties\">[mysqld]\nwsrep_provider=\/usr\/lib64\/galera-4\/libgalera_smm.so \n\n[galera]\nwsrep_cluster_address=\"gcomm:\/\/192.168.1.101,192.168.1.102\"\nwsrep_cluster_name='my_galera_cluster'<\/code><\/pre>\n\n\n\n<p>D\u00e9marrez l&#8217;arbitre :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ galera_arbitrator<\/code><\/pre>\n\n\n\n<p>V\u00e9rifiez les logs dans&nbsp;<code>\/var\/log\/mysql\/galera.log<\/code>&nbsp;pour vous assurer qu&#8217;il s&#8217;est connect\u00e9 au cluster avec succ\u00e8s.<\/p>\n\n\n\n<p>L&#8217;arbitre participera maintenant aux calculs de quorum et fournira un basculement automatique en cas de sc\u00e9nario de split brain. Cela \u00e9vite les pertes de donn\u00e9es en cas de partition r\u00e9seau.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2>\n\n\n\n<p>Dans ce guide d\u00e9taill\u00e9, nous avons couvert les \u00e9tapes d&#8217;installation, de configuration et de surveillance d&#8217;un cluster Galera \u00e0 deux n\u0153uds sur les distributions Ubuntu\/Debian et CentOS\/RHEL \u00e9tape par \u00e9tape avec des exemples pratiques.<\/p>\n\n\n\n<p>Les points cl\u00e9s \u00e0 retenir sont :<\/p>\n\n\n\n<ul>\n<li>Galera permet de construire des clusters MySQL multi-ma\u00eetre pour la haute disponibilit\u00e9.<\/li>\n\n\n\n<li>La r\u00e9plication en temps r\u00e9el au niveau ligne assure la coh\u00e9rence.<\/li>\n\n\n\n<li>Les n\u0153uds peuvent \u00eatre ajout\u00e9s ou supprim\u00e9s dynamiquement.<\/li>\n\n\n\n<li>Rejoindre, transf\u00e9rer l&#8217;\u00e9tat et g\u00e9rer le quorum des n\u0153uds est automatique.<\/li>\n\n\n\n<li>Surveiller les variables de statut cl\u00e9s comme les mesures wsrep.<\/li>\n\n\n\n<li>L&#8217;arbitre Galera pr\u00e9vient les sc\u00e9narios de split brain.<\/li>\n<\/ul>\n\n\n\n<p>Un cluster Galera \u00e0 deux n\u0153uds convient bien pour r\u00e9duire les temps d&#8217;arr\u00eat et assurer la redondance pour de nombreuses applications. Des n\u0153uds suppl\u00e9mentaires peuvent \u00eatre introduits de mani\u00e8re transparente ult\u00e9rieurement si n\u00e9cessaire.<\/p>\n\n\n\n<p>En utilisant ce didacticiel comme guide, vous pouvez d\u00e9sormais d\u00e9ployer des clusters MySQL hautement disponibles avec Galera sur Ubuntu\/Debian et CentOS\/RHEL.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Galera Cluster permet de construire un cluster de bases de donn\u00e9es MySQL \/ MariaDB hautement disponible sans compromettre la coh\u00e9rence des donn\u00e9es. En r\u00e9pliquant les donn\u00e9es entre les n\u0153uds en temps r\u00e9el, Galera assure une disponibilit\u00e9 continue m\u00eame en cas de d\u00e9faillance de n\u0153uds individuels. Dans ce tutoriel complet, nous allons parcourir les \u00e9tapes ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[67,59],"tags":[],"yoast_head":"\n<title>Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL - WebHi Tutorials &amp; Documentations<\/title>\n<meta name=\"description\" content=\"Guide d\u00e9taill\u00e9 pour installer, configurer et surveiller un cluster Galera hautement disponible \u00e0 deux n\u0153uds pour MySQL sur Ubuntu\/Debian et CentOS\/RHEL.\" \/>\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.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL - WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"og:description\" content=\"Guide d\u00e9taill\u00e9 pour installer, configurer et surveiller un cluster Galera hautement disponible \u00e0 deux n\u0153uds pour MySQL sur Ubuntu\/Debian et CentOS\/RHEL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhi.technology\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-23T21:41:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-23T21:41:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/galera_cluster_fr.jpg\" \/>\n<meta name=\"author\" content=\"webhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:site\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/\"},\"author\":{\"name\":\"webhi\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\"},\"headline\":\"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL\",\"datePublished\":\"2023-10-23T21:41:44+00:00\",\"dateModified\":\"2023-10-23T21:41:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/\"},\"wordCount\":1527,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"articleSection\":[\"Administration syst\u00e8me Linux\",\"Bases de donn\u00e9es\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/\",\"name\":\"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL - WebHi Tutorials &amp; Documentations\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\"},\"datePublished\":\"2023-10-23T21:41:44+00:00\",\"dateModified\":\"2023-10-23T21:41:45+00:00\",\"description\":\"Guide d\u00e9taill\u00e9 pour installer, configurer et surveiller un cluster Galera hautement disponible \u00e0 deux n\u0153uds pour MySQL sur Ubuntu\/Debian et CentOS\/RHEL.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webhi.com\/how-to\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"name\":\"WebHi Tutorials &amp; Documentations\",\"description\":\"System administration and knowledge base\",\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\",\"name\":\"WebHi Technology\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"width\":288,\"height\":95,\"caption\":\"WebHi Technology\"},\"image\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webhi.technology\",\"https:\/\/twitter.com\/WebHiTechnology\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\",\"name\":\"webhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260\",\"caption\":\"webhi\"},\"sameAs\":[\"https:\/\/www.webhi.com\/how-to\"],\"url\":\"https:\/\/www.webhi.com\/how-to\/author\/webhi\/\"}]}<\/script>\n","yoast_head_json":{"title":"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL - WebHi Tutorials &amp; Documentations","description":"Guide d\u00e9taill\u00e9 pour installer, configurer et surveiller un cluster Galera hautement disponible \u00e0 deux n\u0153uds pour MySQL sur Ubuntu\/Debian et CentOS\/RHEL.","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.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/","og_locale":"en_US","og_type":"article","og_title":"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL - WebHi Tutorials &amp; Documentations","og_description":"Guide d\u00e9taill\u00e9 pour installer, configurer et surveiller un cluster Galera hautement disponible \u00e0 deux n\u0153uds pour MySQL sur Ubuntu\/Debian et CentOS\/RHEL.","og_url":"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/","og_site_name":"WebHi Tutorials &amp; Documentations","article_publisher":"https:\/\/www.facebook.com\/webhi.technology","article_published_time":"2023-10-23T21:41:44+00:00","article_modified_time":"2023-10-23T21:41:45+00:00","og_image":[{"url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/galera_cluster_fr.jpg"}],"author":"webhi","twitter_card":"summary_large_image","twitter_creator":"@WebHiTechnology","twitter_site":"@WebHiTechnology","twitter_misc":{"Written by":"webhi","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/#article","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/"},"author":{"name":"webhi","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54"},"headline":"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL","datePublished":"2023-10-23T21:41:44+00:00","dateModified":"2023-10-23T21:41:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/"},"wordCount":1527,"commentCount":0,"publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"articleSection":["Administration syst\u00e8me Linux","Bases de donn\u00e9es"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/","url":"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/","name":"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL - WebHi Tutorials &amp; Documentations","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/#website"},"datePublished":"2023-10-23T21:41:44+00:00","dateModified":"2023-10-23T21:41:45+00:00","description":"Guide d\u00e9taill\u00e9 pour installer, configurer et surveiller un cluster Galera hautement disponible \u00e0 deux n\u0153uds pour MySQL sur Ubuntu\/Debian et CentOS\/RHEL.","breadcrumb":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhi.com\/how-to\/fr\/installer-et-configurer-un-cluster-galera-pour-mysql-mariadb-sur-ubuntu-debian-et-centos-rhel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhi.com\/how-to\/"},{"@type":"ListItem","position":2,"name":"Installer et configurer un cluster Galera pour MySQL\/MariaDB sur Ubuntu\/Debian et CentOS\/RHEL"}]},{"@type":"WebSite","@id":"https:\/\/www.webhi.com\/how-to\/#website","url":"https:\/\/www.webhi.com\/how-to\/","name":"WebHi Tutorials &amp; Documentations","description":"System administration and knowledge base","publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhi.com\/how-to\/#organization","name":"WebHi Technology","url":"https:\/\/www.webhi.com\/how-to\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","contentUrl":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","width":288,"height":95,"caption":"WebHi Technology"},"image":{"@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhi.technology","https:\/\/twitter.com\/WebHiTechnology"]},{"@type":"Person","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54","name":"webhi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/","url":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260","contentUrl":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260","caption":"webhi"},"sameAs":["https:\/\/www.webhi.com\/how-to"],"url":"https:\/\/www.webhi.com\/how-to\/author\/webhi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/7062"}],"collection":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/comments?post=7062"}],"version-history":[{"count":3,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/7062\/revisions"}],"predecessor-version":[{"id":7084,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/7062\/revisions\/7084"}],"wp:attachment":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/media?parent=7062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/categories?post=7062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/tags?post=7062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}