{"id":558,"date":"2022-07-14T16:36:01","date_gmt":"2022-07-14T16:36:01","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=558"},"modified":"2022-07-18T11:31:04","modified_gmt":"2022-07-18T11:31:04","slug":"replication-maitre-esclave-mysql-sur-centos-7","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/","title":{"rendered":"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/mysql_Master_slave_centos-fr.jpg\" alt=\"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7\" class=\"wp-image-816\" srcset=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/mysql_Master_slave_centos-fr.jpg 1200w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/mysql_Master_slave_centos-fr-300x169.jpg 300w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/mysql_Master_slave_centos-fr-1024x576.jpg 1024w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/mysql_Master_slave_centos-fr-768x432.jpg 768w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/mysql_Master_slave_centos-fr-150x84.jpg 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><figcaption>R\u00e9plication ma\u00eetre-esclave MySQL.<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p>La r\u00e9plication MySQL est le processus de copie automatique des donn\u00e9es d\u2019un serveur de base de donn\u00e9es vers un ou plusieurs serveurs.<\/p>\n\n\n\n<p>MySQL offre une vari\u00e9t\u00e9 de topologies de r\u00e9plication, dont la plus connue est la topologie Ma\u00eetre\/Esclave, dans laquelle un serveur de base de donn\u00e9es fonctionne comme le ma\u00eetre et un ou plusieurs serveurs fonctionnent comme esclaves. Par d\u00e9faut, la r\u00e9plication est asynchrone, le ma\u00eetre envoyant les \u00e9v\u00e9nements \u00e0 son journal binaire qui d\u00e9crit les changements de base de donn\u00e9es et les esclaves demandant les \u00e9v\u00e9nements quand ils sont pr\u00eats.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Exigences de base<\/h2>\n\n\n\n<p>Dans cet article, nous allons vous montrer comment configurer une r\u00e9plication MySQL Master\/Slave sur CentOS 7 avec un serveur ma\u00eetre et un serveur esclave. Les m\u00eames proc\u00e9dures s\u2019appliquent \u00e0 MariaDB.<br>Cette architecture de r\u00e9plication est la mieux adapt\u00e9e \u00e0 la r\u00e9plication en lecture.<\/p>\n\n\n\n<p>Dans cet exemple, nous supposons que vous avez deux serveurs ex\u00e9cutant CentOS 7, et qu\u2019ils peuvent communiquer entre eux via un r\u00e9seau priv\u00e9. Si votre h\u00e9bergeur ne fournit pas d\u2019adresses IP priv\u00e9es, vous pouvez utiliser des adresses IP publiques et configurer le pare-feu pour n\u2019autoriser que le trafic sur le port 3306 \u00e0 partir de sources fiables.<\/p>\n\n\n\n<p>Les adresses IP des serveurs dans cet exemple sont les suivantes&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Master IP&nbsp;: 10.10.0.44\nSlave IP&nbsp;:  10.10.0.20<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Installation de MySQL<\/h2>\n\n\n\n<p>Vous pouvez suivre cet article sur l\u2019installation de MySQL sur CentOS\/RHEL 7\/6 &amp; Fedora 31\/30.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Configurer le serveur ma\u00eetre<\/h2>\n\n\n\n<p>Tout d\u2019abord, nous allons configurer le serveur ma\u00eetre MySQL avec les changements suivants&nbsp;:<\/p>\n\n\n\n<ul><li>Configurez le serveur MySQL pour \u00e9couter \u00e0 son adresse IP priv\u00e9e.<\/li><li>Cr\u00e9ez un ID de serveur distinct.<\/li><li>Activez la journalisation binaire.<\/li><\/ul>\n\n\n\n<p>Pour ce faire, \u00e9ditez le fichier de configuration MySQL et ins\u00e9rez les lignes suivantes dans la section <kbd>[mysqld]<\/kbd>&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo nano \/etc\/my.cnf<\/code><\/pre>\n\n\n\n<h5 class=\"has-text-align-center wp-block-heading\">Serveur Ma\u00eetre :\/etc\/my.cnf<\/h5>\n\n\n\n<pre class=\"wp-block-preformatted\">bind-address           = 10.10.0.44\nserver-id              = 44\nlog_bin                = mysql-bin<\/pre>\n\n\n\n<p>Une fois termin\u00e9, red\u00e9marrez le service MySQL pour que les modifications prennent effet.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo systemctl restart mysqld<\/code><\/pre>\n\n\n\n<p>L\u2019\u00e9tape suivante consiste \u00e0 configurer un nouvel utilisateur de r\u00e9plication. Connectez-vous en tant qu\u2019utilisateur root au serveur MySQL&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -uroot -p<\/code><\/pre>\n\n\n\n<p>Ex\u00e9cutez les instructions SQL suivantes \u00e0 partir de l\u2019invite MySQL pour cr\u00e9er l\u2019utilisateur slave1 et lui accorder le privil\u00e8ge REPLICATION SLAVE&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CREATE USER 'slave1'@'10.10.0.20' IDENTIFIED BY 'secret_password';\nmysql&gt; GRANT REPLICATION SLAVE ON *.* TO 'slave1'@'10.10.0.20';<\/code><\/pre>\n\n\n\n<p>Pendant que vous \u00eates toujours dans l\u2019invite MySQL, utilisez la commande suivante pour afficher le nom et la position du fichier binaire.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SHOW MASTER STATUS\\G<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">*************************** 1. row ***************************\n             File: mysql-bin.000001\n         Position: 1714\n     Binlog_Do_DB: \n Binlog_Ignore_DB: \nExecuted_Gtid_Set: \n1 row in set (0.00 sec)<\/pre>\n\n\n\n<p>Notez le nom de fichier \u00ab&nbsp;mysql-bin.000001&nbsp;\u00bb et la position \u00ab&nbsp;1714&nbsp;\u00bb. Vous aurez besoin de ces valeurs lors de la configuration du serveur esclave. Ces valeurs peuvent \u00eatre diff\u00e9rentes sur votre serveur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Configurer le serveur esclave<\/h2>\n\n\n\n<ul><li>Tout comme le serveur ma\u00eetre, nous apporterons les modifications suivantes au serveur esclave&nbsp;:<\/li><li>Configurez le serveur MySQL pour \u00e9couter sur son adresse IP priv\u00e9e.<br>Cr\u00e9ez un ID de serveur distinct.<\/li><li>Activez la journalisation binaire.<\/li><\/ul>\n\n\n\n<p>Saisissez le fichier de configuration MySQL et modifiez les lignes suivantes&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo nano \/etc\/my.cnf<\/code><\/pre>\n\n\n\n<h5 class=\"has-text-align-center wp-block-heading\">Serveur esclave&nbsp;:\/etc\/my.cnf<\/h5>\n\n\n\n<pre class=\"wp-block-preformatted\">bind-address           = 10.10.0.20\nserver-id              = 20\nlog_bin                = mysql-bin<\/pre>\n\n\n\n<p>Red\u00e9marrez le service MySQL pour que les modifications prennent effet.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo systemctl restart mysqld<\/code><\/pre>\n\n\n\n<p>L\u2019\u00e9tape suivante consiste \u00e0 d\u00e9finir les param\u00e8tres qui seront utilis\u00e9s par le serveur esclave pour se connecter au serveur ma\u00eetre. Connectez-vous au shell MySQL comme suit&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -uroot -p<\/code><\/pre>\n\n\n\n<p>Tout d\u2019abord, arr\u00eatez les fils esclaves&nbsp;(slave threads)&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; STOP SLAVE;<\/code><\/pre>\n\n\n\n<p>Ex\u00e9cutez la requ\u00eate suivante pour configurer l\u2019esclave pour dupliquer le ma\u00eetre&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CHANGE MASTER TO\nmysql&gt; MASTER_HOST='10.10.0.44',\nmysql&gt; MASTER_USER='slave1',\nmysql&gt; MASTER_PASSWORD='secret_password',\nmysql&gt; MASTER_LOG_FILE='mysql-bin.000001',\nmysql&gt; MASTER_LOG_POS=1714;<\/code><\/pre>\n\n\n\n<p>Assurez-vous d\u2019utiliser l\u2019adresse IP, le nom d\u2019utilisateur et le mot de passe appropri\u00e9s. Le nom et l\u2019emplacement du fichier journal doivent \u00eatre les m\u00eames valeurs que celles obtenues du serveur ma\u00eetre.<\/p>\n\n\n\n<p>Apr\u00e8s cela, commencer les fils esclaves.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; START SLAVE;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Tester la configuration<\/h2>\n\n\n\n<p>Vous devriez maintenant avoir une configuration de r\u00e9plication Ma\u00eetre\/Esclave fonctionnelle.<\/p>\n\n\n\n<p>Sur le serveur ma\u00eetre, nous cr\u00e9erons une nouvelle base de donn\u00e9es pour nous assurer que tout fonctionne comme pr\u00e9vu&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -uroot -p<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CREATE DATABASE test_db;<\/code><\/pre>\n\n\n\n<p>Connectez-vous au shell slave MySQL avec la commande suivante&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -uroot -p<\/code><\/pre>\n\n\n\n<p>Utilisez la commande suivante pour lister toutes les bases de donn\u00e9es&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SHOW DATABASES;<\/code><\/pre>\n\n\n\n<h5 class=\"has-text-align-center wp-block-heading\"><kbd>Output&nbsp;:<\/kbd><\/h5>\n\n\n\n<pre class=\"wp-block-preformatted\">+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| mysql              |\n| performance_schema |\n| test_db            |\n| sys                |\n+--------------------+\n5 rows in set (0.00 sec)<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>Dans cet article, nous avons montr\u00e9 comment configurer une r\u00e9plication MySQL Master\/Slave sur CentOS 7.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction La r\u00e9plication MySQL est le processus de copie automatique des donn\u00e9es d\u2019un serveur de base de donn\u00e9es vers un ou plusieurs serveurs. MySQL offre une vari\u00e9t\u00e9 de topologies de r\u00e9plication, dont la plus connue est la topologie Ma\u00eetre\/Esclave, dans laquelle un serveur de base de donn\u00e9es fonctionne comme le ma\u00eetre et un ou plusieurs ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[67,59],"tags":[],"yoast_head":"\n<title>R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7 - WebHi Tutorials &amp; Documentations<\/title>\n<meta name=\"description\" content=\"In this article, we will show you how to set up a MySQL Master\/Slave replication on CentOS 7 with one master and one slave server. The same procedures apply to MariaDB.This replication architecture is best suited for read replication.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7 - WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"og:description\" content=\"In this article, we will show you how to set up a MySQL Master\/Slave replication on CentOS 7 with one master and one slave server. The same procedures apply to MariaDB.This replication architecture is best suited for read replication.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhi.technology\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-14T16:36:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-18T11:31:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/mysql_Master_slave_centos-fr.jpg\" \/>\n<meta name=\"author\" content=\"webhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:site\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/\"},\"author\":{\"name\":\"webhi\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\"},\"headline\":\"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7\",\"datePublished\":\"2022-07-14T16:36:01+00:00\",\"dateModified\":\"2022-07-18T11:31:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/\"},\"wordCount\":709,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"articleSection\":[\"Administration syst\u00e8me Linux\",\"Bases de donn\u00e9es\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/\",\"name\":\"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7 - WebHi Tutorials &amp; Documentations\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\"},\"datePublished\":\"2022-07-14T16:36:01+00:00\",\"dateModified\":\"2022-07-18T11:31:04+00:00\",\"description\":\"In this article, we will show you how to set up a MySQL Master\/Slave replication on CentOS 7 with one master and one slave server. The same procedures apply to MariaDB.This replication architecture is best suited for read replication.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webhi.com\/how-to\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"name\":\"WebHi Tutorials &amp; Documentations\",\"description\":\"System administration and knowledge base\",\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\",\"name\":\"WebHi Technology\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"width\":288,\"height\":95,\"caption\":\"WebHi Technology\"},\"image\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webhi.technology\",\"https:\/\/twitter.com\/WebHiTechnology\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\",\"name\":\"webhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063\",\"caption\":\"webhi\"},\"sameAs\":[\"https:\/\/www.webhi.com\/how-to\"],\"url\":\"https:\/\/www.webhi.com\/how-to\/author\/webhi\/\"}]}<\/script>\n","yoast_head_json":{"title":"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7 - WebHi Tutorials &amp; Documentations","description":"In this article, we will show you how to set up a MySQL Master\/Slave replication on CentOS 7 with one master and one slave server. The same procedures apply to MariaDB.This replication architecture is best suited for read replication.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/","og_locale":"en_US","og_type":"article","og_title":"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7 - WebHi Tutorials &amp; Documentations","og_description":"In this article, we will show you how to set up a MySQL Master\/Slave replication on CentOS 7 with one master and one slave server. The same procedures apply to MariaDB.This replication architecture is best suited for read replication.","og_url":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/","og_site_name":"WebHi Tutorials &amp; Documentations","article_publisher":"https:\/\/www.facebook.com\/webhi.technology","article_published_time":"2022-07-14T16:36:01+00:00","article_modified_time":"2022-07-18T11:31:04+00:00","og_image":[{"url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/mysql_Master_slave_centos-fr.jpg"}],"author":"webhi","twitter_card":"summary_large_image","twitter_creator":"@WebHiTechnology","twitter_site":"@WebHiTechnology","twitter_misc":{"Written by":"webhi","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/#article","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/"},"author":{"name":"webhi","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54"},"headline":"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7","datePublished":"2022-07-14T16:36:01+00:00","dateModified":"2022-07-18T11:31:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/"},"wordCount":709,"commentCount":0,"publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"articleSection":["Administration syst\u00e8me Linux","Bases de donn\u00e9es"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/","url":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/","name":"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7 - WebHi Tutorials &amp; Documentations","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/#website"},"datePublished":"2022-07-14T16:36:01+00:00","dateModified":"2022-07-18T11:31:04+00:00","description":"In this article, we will show you how to set up a MySQL Master\/Slave replication on CentOS 7 with one master and one slave server. The same procedures apply to MariaDB.This replication architecture is best suited for read replication.","breadcrumb":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhi.com\/how-to\/fr\/replication-maitre-esclave-mysql-sur-centos-7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhi.com\/how-to\/"},{"@type":"ListItem","position":2,"name":"R\u00e9plication ma\u00eetre-esclave MySQL sur CentOS 7"}]},{"@type":"WebSite","@id":"https:\/\/www.webhi.com\/how-to\/#website","url":"https:\/\/www.webhi.com\/how-to\/","name":"WebHi Tutorials &amp; Documentations","description":"System administration and knowledge base","publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhi.com\/how-to\/#organization","name":"WebHi Technology","url":"https:\/\/www.webhi.com\/how-to\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","contentUrl":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","width":288,"height":95,"caption":"WebHi Technology"},"image":{"@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhi.technology","https:\/\/twitter.com\/WebHiTechnology"]},{"@type":"Person","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54","name":"webhi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/","url":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063","contentUrl":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063","caption":"webhi"},"sameAs":["https:\/\/www.webhi.com\/how-to"],"url":"https:\/\/www.webhi.com\/how-to\/author\/webhi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/558"}],"collection":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/comments?post=558"}],"version-history":[{"count":15,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/558\/revisions"}],"predecessor-version":[{"id":817,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/558\/revisions\/817"}],"wp:attachment":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/media?parent=558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/categories?post=558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/tags?post=558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}