{"id":807,"date":"2026-07-08T14:53:52","date_gmt":"2026-07-08T12:53:52","guid":{"rendered":"https:\/\/communaute-omr.fr\/?p=807"},"modified":"2026-07-08T17:07:17","modified_gmt":"2026-07-08T15:07:17","slug":"mise-en-place-de-la-replication-des-bases","status":"publish","type":"post","link":"https:\/\/communaute-omr.fr\/?p=807","title":{"rendered":"Mise en place de la r\u00e9plication des bases"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><div class=\"ez-toc-title\" style=\"cursor:inherit\">Table des mati\u00e8res<\/div>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Preparation_du_compte_Mysql\" >Pr\u00e9paration du compte Mysql<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Configuration_de_MariaDB\" >Configuration de MariaDB<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Configuration_de_la_replication_des_bases\" >Configuration de la r\u00e9plication des bases<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Creation_des_comptes_Centreon\" >Cr\u00e9ation des comptes Centreon<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Creation_des_comptes_de_replication\" >Cr\u00e9ation des comptes de r\u00e9plication<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Installation_de_la_HA\" >Installation de la HA<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Controle_des_connexion\" >Contr\u00f4le des connexion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Activer_la_replication\" >Activer la replication<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Passage_en_mode_readonly\" >Passage en mode readonly<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Synchronisation_des_bases_de_donnees\" >Synchronisation des bases de donn\u00e9es<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Arret_du_serveur_DB2\" >Arr\u00eat du serveur DB2<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Lancer_la_replication_des_bases\" >Lancer la r\u00e9plication des bases<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/communaute-omr.fr\/?p=807\/#Etapes_suivantes\" >Etapes suivantes<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n<h1 id=\"mise-en-place-de-la-replication-des-bases\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Preparation_du_compte_Mysql\"><\/span>Pr\u00e9paration du compte Mysql<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Sur les 2 serveurs Mysql<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Arr\u00eater les bases de donn\u00e9es<\/li>\n\n\n\n<li>Modification du compte mysql<\/li>\n\n\n\n<li>G\u00e9n\u00e9ration des cl\u00e9s ssh<\/li>\n\n\n\n<li>Echange des cl\u00e9s ssh entre les serveurs bases de donn\u00e9es<\/li>\n\n\n\n<li>Copier le contenu de la cl\u00e9 publique du serveur DB1 sur DB2 et inversement dans le fichier ~\/.ssh\/authorized_keys<\/li>\n\n\n\n<li>Modifier les droits du fichier<\/li>\n\n\n\n<li> Tester les connexions<\/li>\n<\/ul>\n\n\n\n<h3 id=\"configuration-de-mariadb\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Configuration_de_MariaDB\"><\/span>Configuration de MariaDB<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ajouter les lignes suivantes dans le fichier \/etc\/my.cnf.d\/centreon.cnf<\/li>\n\n\n\n<li>Penser \u00e0 mettre 1 pour le master et 2 pour le slave<\/li>\n\n\n\n<li>Laisser le read_only comment\u00e9<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Red\u00e9marrer le services sur les 2 serveurs<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 id=\"configuration-de-la-replication-des-bases\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Configuration_de_la_replication_des_bases\"><\/span>Configuration de la r\u00e9plication des bases<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"creation-des-comptes-centreon\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_des_comptes_Centreon\"><\/span>Cr\u00e9ation des comptes Centreon<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Se connecter \u00e0 mysql en root <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Remplacer dans la commande les valeurs qui correspondent \u00e0 votre environnement.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE USER '@MARIADB_CENTREON_USER@'@'@DATABASE_SLAVE_IPADDR@' IDENTIFIED BY '@MARIADB_CENTREON_PASSWD@';\nGRANT ALL PRIVILEGES ON centreon.* TO '@MARIADB_CENTREON_USER@'@'@DATABASE_SLAVE_IPADDR@';\nGRANT ALL PRIVILEGES ON centreon_storage.* TO '@MARIADB_CENTREON_USER@'@'@DATABASE_SLAVE_IPADDR@';\n\nCREATE USER '@MARIADB_CENTREON_USER@'@'@DATABASE_MASTER_IPADDR@' IDENTIFIED BY '@MARIADB_CENTREON_PASSWD@';\nGRANT ALL PRIVILEGES ON centreon.* TO '@MARIADB_CENTREON_USER@'@'@DATABASE_MASTER_IPADDR@';\nGRANT ALL PRIVILEGES ON centreon_storage.* TO '@MARIADB_CENTREON_USER@'@'@DATABASE_MASTER_IPADDR@';\nCREATE USER '@MARIADB_CENTREON_USER@'@'@CENTRAL_SLAVE_IPADDR@' IDENTIFIED BY '@MARIADB_CENTREON_PASSWD@';\nGRANT ALL PRIVILEGES ON centreon.* TO '@MARIADB_CENTREON_USER@'@'@CENTRAL_SLAVE_IPADDR@';\nGRANT ALL PRIVILEGES ON centreon_storage.* TO '@MARIADB_CENTREON_USER@'@'@CENTRAL_SLAVE_IPADDR@';\n\nCREATE USER '@MARIADB_CENTREON_USER@'@'@CENTRAL_MASTER_IPADDR@' IDENTIFIED BY '@MARIADB_CENTREON_PASSWD@';\nGRANT ALL PRIVILEGES ON centreon.* TO '@MARIADB_CENTREON_USER@'@'@CENTRAL_MASTER_IPADDR@';\nGRANT ALL PRIVILEGES ON centreon_storage.* TO '@MARIADB_CENTREON_USER@'@'@CENTRAL_MASTER_IPADDR@';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> USER <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@DATABASE_SLAVE_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\"> IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_PASSWD@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@DATABASE_SLAVE_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon_storage.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@DATABASE_SLAVE_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> USER <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@DATABASE_MASTER_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\"> IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_PASSWD@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@DATABASE_MASTER_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon_storage.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@DATABASE_MASTER_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> USER <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_SLAVE_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\"> IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_PASSWD@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_SLAVE_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon_storage.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_SLAVE_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> USER <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_MASTER_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\"> IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_PASSWD@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_MASTER_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon_storage.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_MASTER_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"creation-des-comptes-de-replication\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_des_comptes_de_replication\"><\/span>Cr\u00e9ation des comptes de r\u00e9plication<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Remplacer dans la commande les valeurs qui correspondent \u00e0 votre environnement.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE USER '@MARIADB_REPL_USER@'@'@CENTRAL_SLAVE_IPADDR@' IDENTIFIED BY '@MARIADB_CENTREON_PASSWD@';\nGRANT ALL PRIVILEGES ON centreon.* TO '@MARIADB_CENTREON_USER@'@'@CENTRAL_SLAVE_IPADDR@';\nGRANT ALL PRIVILEGES ON centreon_storage.* TO '@MARIADB_CENTREON_USER@'@'@CENTRAL_SLAVE_IPADDR@';\n\nCREATE USER '@MARIADB_REPL_USER@'@'@CENTRAL_MASTER_IPADDR@' IDENTIFIED BY '@MARIADB_CENTREON_PASSWD@';\nGRANT ALL PRIVILEGES ON centreon.* TO '@MARIADB_CENTREON_USER@'@'@CENTRAL_MASTER_IPADDR@';\nGRANT ALL PRIVILEGES ON centreon_storage.* TO '@MARIADB_CENTREON_USER@'@'@CENTRAL_MASTER_IPADDR@';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> USER <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_REPL_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_SLAVE_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\"> IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_PASSWD@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_SLAVE_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon_storage.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_SLAVE_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> USER <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_REPL_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_MASTER_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\"> IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_PASSWD@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_MASTER_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> centreon_storage.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_CENTREON_USER@&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;@CENTRAL_MASTER_IPADDR@&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"installation-de-la-ha\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Installation_de_la_HA\"><\/span>Installation de la HA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>dnf config-manager --enable highavailability\ndnf install centreon-ha-common pcs pacemaker corosync corosync-qdevice<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #79B8FF\">dnf config-manager --enable highavailability<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">dnf install centreon-ha-common pcs pacemaker corosync corosync-qdevice<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Configuration des \u00e9l\u00e9ments pour la replication<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Editer le fichier \/etc\/centreon-ha\/mysql-resources.sh et mettre les bonnes valeurs dans celui-ci .<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>#!\/bin\/bash\n###############################\n# Database access credentials #\n###############################\nDBHOSTNAMEMASTER='@DATABASE_MASTER_NAME@'\nDBHOSTNAMESLAVE='@DATABASE_SLAVE_NAME@'\nDBREPLUSER='@MARIADB_REPL_USER@'\nDBREPLPASSWORD='@MARIADB_REPL_PASSWD@'\nDBROOTUSER='@MARIADB_REPL_USER@'\nDBROOTPASSWORD='@MARIADB_REPL_PASSWD@'\nCENTREON_DB='centreon'\nCENTREON_STORAGE_DB='centreon_storage'\n###############################<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #6A737D\">#!\/bin\/bash<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\">###############################<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># Database access credentials #<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\">###############################<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">DBHOSTNAMEMASTER<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;@DATABASE_MASTER_NAME@&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">DBHOSTNAMESLAVE<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;@DATABASE_SLAVE_NAME@&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">DBREPLUSER<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_REPL_USER@&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">DBREPLPASSWORD<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_REPL_PASSWD@&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">DBROOTUSER<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_REPL_USER@&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">DBROOTPASSWORD<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;@MARIADB_REPL_PASSWD@&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">CENTREON_DB<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;centreon&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">CENTREON_STORAGE_DB<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;centreon_storage&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\">###############################<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 id=\"controle-des-connexion\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Controle_des_connexion\"><\/span>Contr\u00f4le des connexion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Lancer la commande suivante sur les 2 serveurs SGBD pour verifiers qu\u2019ils se connectent aux diff\u00e9rents serveurs<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>\/usr\/share\/centreon-ha\/bin\/mysql-check-status.sh\nConnection SLAVE Status 'Centreon-DB1' &#91;OK&#93;\nConnection SLAVE Status 'Centreon-DB2' &#91;OK&#93;\nSlave Thread Status &#91;KO&#93;\nError reports:\nNo slave (maybe because we cannot check a server).\nPosition Status &#91;SKIP&#93;\nError reports:\nSkip because we can't identify a unique slave.<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #79B8FF\">\/usr\/share\/centreon-ha\/bin\/mysql-check-status.sh<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Connection SLAVE Status &#39;Centreon-DB1&#39; &#91;OK&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Connection SLAVE Status &#39;Centreon-DB2&#39; &#91;OK&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Slave Thread Status &#91;KO&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Error reports:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">No slave (maybe because we cannot check a server).<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Position Status &#91;SKIP&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Error reports:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Skip because we can&#39;t identify a unique slave.<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Le message d\u2019erreur est normal car la r\u00e9plication n\u2019est pas active. Il est important a ce stade que les connexion DB1 et DB2 soient OK.<\/p>\n\n\n\n<h2 id=\"activer-la-replication\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Activer_la_replication\"><\/span>Activer la replication<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"passage-en-mode-readonly\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Passage_en_mode_readonly\"><\/span>Passage en mode readonly<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Maintenant que tout est bien configur\u00e9, activez le mode read_only sur les deux serveurs en d\u00e9commentant (c&rsquo;est-\u00e0-dire en retirant le # en d\u00e9but de ligne) cette instruction dans le fichier \/etc\/my.cnf.d\/centreon.cnf :<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">N\u0153ud principal<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>&#91;server&#93;\nserver-id=1\nread_only\nlog-bin=mysql-bin<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #79B8FF\">&#91;server&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">server-id=1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">read_only<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">log-bin=mysql-bin<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">N\u0153ud secondaire<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>&#91;server&#93;\nserver-id=2\nread_only\nlog-bin=mysql-bin<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #79B8FF\">&#91;server&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">server-id=2<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">read_only<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">log-bin=mysql-bin<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Appliquez ensuite ce changement par un red\u00e9marrage de MariaDB sur les deux n\u0153uds :<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>systemctl restart mariadb<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #79B8FF\">systemctl restart mariadb<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"synchronisation-des-bases-de-donnees\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Synchronisation_des_bases_de_donnees\"><\/span>Synchronisation des bases de donn\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 id=\"arret-du-serveur-db2\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Arret_du_serveur_DB2\"><\/span>Arr\u00eat du serveur DB2<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>systemctl stop mariadb<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #79B8FF\">systemctl stop mariadb<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h4 id=\"lancer-la-replication-des-bases\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Lancer_la_replication_des_bases\"><\/span>Lancer la r\u00e9plication des bases<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Sur le Serveur DB1 lancer la commande de synchronisation des bases de donn\u00e9es<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>\/usr\/share\/centreon-ha\/bin\/mysql-sync-bigdb.sh<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #79B8FF\">\/usr\/share\/centreon-ha\/bin\/mysql-sync-bigdb.sh<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">A la fin de l\u2019ex\u00e9cution&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>Umount and Delete LVM snapshot\nLogical volume \"dbbackupdatadir\" successfully removed.\nStart MySQL Slave\nOK\nStart Replication\nId      User    Host    db      Command Time    State   Info    Progress\n5       replication     CentreonDB1:47706       NULL    Query   0       starting        show processlist        0.000\n6       system user             NULL    Connect 0       Connecting to master    NULL    0.000\n7       system user             NULL    Slave_SQL       0       Slave has read all relay log; waiting for more updates  NULL    0.000<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #79B8FF\">Umount and Delete LVM snapshot<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Logical volume &quot;dbbackupdatadir&quot; successfully removed.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Start MySQL Slave<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">OK<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Start Replication<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Id      User    Host    db      Command Time    State   Info    Progress<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">5       replication     CentreonDB1:47706       NULL    Query   0       starting        show processlist        0.000<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">6       system user             NULL    Connect 0       Connecting to master    NULL    0.000<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">7       system user             NULL    Slave_SQL       0       Slave has read all relay log; waiting for more updates  NULL    0.000<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Il est important de v\u00e9rifier&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le d\u00e9montage des snapshot est bien effectu\u00e9<\/li>\n\n\n\n<li>Que le Slave est bien d\u00e9marr\u00e9<\/li>\n\n\n\n<li>Que la r\u00e9plication est active<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Nous pouvons maintenant contr\u00f4ler que la r\u00e9plication fonctionne&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>\/usr\/share\/centreon-ha\/bin\/mysql-check-status.sh\nConnection MASTER Status 'Centreon-DB1' &#91;OK&#93;\nConnection SLAVE Status 'Centreon-DB2' &#91;OK&#93;\nSlave Thread Status &#91;OK&#93;\nPosition Status &#91;OK&#93;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #79B8FF\">\/usr\/share\/centreon-ha\/bin\/mysql-check-status.sh<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Connection MASTER Status &#39;Centreon-DB1&#39; &#91;OK&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Connection SLAVE Status &#39;Centreon-DB2&#39; &#91;OK&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Slave Thread Status &#91;OK&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">Position Status &#91;OK&#93;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 id=\"etapes-suivantes\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Etapes_suivantes\"><\/span>Etapes suivantes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Installation des briques corosync\/pacemaker\/heartbeat<\/li>\n\n\n\n<li>Configuration du cluster<\/li>\n\n\n\n<li>Configuration des centreon pour la HA<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Pr\u00e9paration du compte Mysql Sur les 2 serveurs Mysql Configuration de MariaDB Red\u00e9marrer le services sur les 2 serveurs<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[5,15],"tags":[],"class_list":["post-807","post","type-post","status-publish","format-standard","hentry","category-centreon","category-haute-disponiblilite"],"_links":{"self":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=807"}],"version-history":[{"count":6,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/807\/revisions"}],"predecessor-version":[{"id":899,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/807\/revisions\/899"}],"wp:attachment":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}