{"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-13T22:29:53","modified_gmt":"2026-07-13T20:29:53","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":"\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":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"right","_kad_post_sidebar_id":"sidebar-primary","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","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":7,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/807\/revisions"}],"predecessor-version":[{"id":974,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/807\/revisions\/974"}],"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}]}}