{"id":7040,"date":"2019-02-08T12:01:13","date_gmt":"2019-02-08T11:01:13","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=7040"},"modified":"2025-11-21T17:17:05","modified_gmt":"2025-11-21T16:17:05","slug":"replication-mysql-resynchronisation-dun-slave-mysql","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/","title":{"rendered":"R\u00e9plication MySQL : Resynchronisation d&#8217;un Slave MySQL"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7040&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7040&#038;title=R%C3%A9plication%20MySQL%20%3A%20Resynchronisation%20d%E2%80%99un%20Slave%20MySQL\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=R%C3%A9plication%20MySQL%20%3A%20Resynchronisation%20d%E2%80%99un%20Slave%20MySQL&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7040\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><p>L&#8217;objectif de cet article est de d\u00e9crire la proc\u00e9dure de resynchronisation d&#8217;un Slave suite \u00e0 un probl\u00e8me de r\u00e9plication MySQL li\u00e9 au Master.<\/p>\n<p>Derni\u00e8rement, chez un client, un probl\u00e8me est survenu sur le Master d&#8217;une r\u00e9plication MySQL.<\/p>\n<p>En effet, le filesystem stockant les donn\u00e9es MySQL (datadir) a \u00e9t\u00e9 satur\u00e9 et un nouveau disque d&#8217;une plus grande taille a \u00e9t\u00e9 mise en place. Les donn\u00e9es ont \u00e9t\u00e9 d\u00e9plac\u00e9 sur ce nouveau disque mais la r\u00e9plication MySQL avec le Slave n&#8217;a pas \u00e9t\u00e9 remise en place.<\/p>\n<p>Nous devons donc restaurer un backup FULL de 2 bases sur le Slave et relancer la r\u00e9plication sur le Slave.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Voici donc la proc\u00e9dure qui inclus des actions tant sur le Master que sur le Slave donc bien v\u00e9rifier sur lequel vous \u00eates !<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>Master (asterix)<\/h3>\n<ul>\n<li>V\u00e9rifier le status du Master<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p********\r\nshow master status \\G;\r\nshow processlist \\G;<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Faire un backup FULL compress\u00e9 sur le Master avec mysqldump comprenant les 2 bases :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">time mysqldump -uroot -p****** --single-transaction --master-data=2 --databases panoramix idefix --max-allowed-packet=2G | gzip &gt; \/backup2\/backup_bases_03pic.dmp.gz<\/pre>\n<p>Nous utilisons la commande time pour chronom\u00e9trer le temps du backup FULL avec les options suivantes :<\/p>\n<p>&#8211; single-transaction : sauvegarde se fait au sein d\u2019une seule transaction tout en laissant la base fonctionner normalement<\/p>\n<p>&#8211; master-data : <span class=\"tlid-translation translation\"><span class=\"\" title=\"\">la valeur de l&#8217;option \u00e0 2 \u00e9crit l&#8217;instruction CHANGE MASTER TO en commentaire. <\/span><span class=\"\" title=\"\">L&#8217;option &#8211;master-data d\u00e9sactive automatiquement &#8211;lock-tables.<\/span><\/span><\/p>\n<p>&#8211; databases : nom des bases \u00e0 sauvegarder<\/p>\n<p>&#8211; max-allowed-packet : l<span class=\"tlid-translation translation\"><span class=\"\" title=\"\">ongueur de paquet maximale \u00e0 envoyer ou \u00e0 recevoir du serveur<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Transf\u00e9rer le backup FULL des 2 bases en scp du Master vers le Slave :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">scp \/backup2\/backup_bases.dmp.gz capdata@obelix:\/opt\/restore<\/pre>\n<p>&nbsp;<\/p>\n<h3>Slave (obelix)<\/h3>\n<ul>\n<li>V\u00e9rifier le status du Slave et l&#8217;\u00e9tat du process de r\u00e9plication<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p********\r\nshow slave status \\G;\r\nshow processlist \\G;<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Supprimer les 2 bases sur le slave :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p********\r\nshow databases;\r\ndrop database panoramix;\r\ndrop database idefix;<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Par mesure de s\u00e9curit\u00e9, et afin qu&#8217;aucune transaction du site primaire ne vienne \u00e9crire dans les nouvelles bases du slave, stopper celui ci :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p******** stop slave;<\/pre>\n<ul>\n<li>Restaurer le dump de la prod sur le slave :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p******** &lt; \/opt\/restore\/backup_bases.dmp<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Dans une nouvelle session, vous pouvez voir le process de restauration depuis la liste des processus sur le Slave :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p********\r\nshow processlist \\G;<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Une fois la restauration termin\u00e9e, mettre le fichier de log et position compris au d\u00e9but du dump puis d\u00e9marrer le Slave :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p********\r\nCHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.052873', MASTER_LOG_POS=42402792;\r\nstart slave;<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>V\u00e9rifier le status du Slave et le rattrapage (Seconds_Behind_Master) des bin logs vis-\u00e0-vis du Master :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">show slave status \\G;<\/pre>\n<p><a href=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_slave_status_resynchronistation_en_cours.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7094\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_slave_status_resynchronistation_en_cours.png\" alt=\"\" width=\"561\" height=\"702\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_slave_status_resynchronistation_en_cours.png 561w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_slave_status_resynchronistation_en_cours-240x300.png 240w\" sizes=\"auto, (max-width: 561px) 100vw, 561px\" \/><\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7054 size-full\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_slave_status_apres_resynchronistation.png\" alt=\"\" width=\"524\" height=\"743\" \/><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">show processlist \\G;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7053 size-full\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_processlist_apres_resynchronistation.png\" alt=\"\" width=\"688\" height=\"307\" \/><\/p>\n<h3>Master (Asterix)<\/h3>\n<ul>\n<li>V\u00e9rifier le status du Master :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p********\r\nshow master status \\G;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7051 size-full\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_master_status.png\" alt=\"\" width=\"528\" height=\"165\" \/><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">show processlist \\G;<\/pre>\n<pre><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7052 size-full\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_processlist.png\" alt=\"\" width=\"633\" height=\"149\" \/><\/pre>\n<p>&nbsp;<\/p>\n<p>Voila en esp\u00e9rant que ce petit tips MySQL vous aura servi.<\/p>\n<p>A bient\u00f4t pour de nouveaux articles sur MySQL !<\/p>\n<p>Erwan Ollitrault<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7040&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7040&#038;title=R%C3%A9plication%20MySQL%20%3A%20Resynchronisation%20d%E2%80%99un%20Slave%20MySQL\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=R%C3%A9plication%20MySQL%20%3A%20Resynchronisation%20d%E2%80%99un%20Slave%20MySQL&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7040\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>L&#8217;objectif de cet article est de d\u00e9crire la proc\u00e9dure de resynchronisation d&#8217;un Slave suite \u00e0 un probl\u00e8me de r\u00e9plication MySQL li\u00e9 au Master. Derni\u00e8rement, chez un client, un probl\u00e8me est survenu sur le Master d&#8217;une r\u00e9plication MySQL. En effet, le&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":7094,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[31,304],"class_list":["post-7040","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-replication","tag-resynchronisation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>R\u00e9plication MySQL : Resynchronisation d&#039;un Slave MySQL - Capdata TECH BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"R\u00e9plication MySQL : Resynchronisation d&#039;un Slave MySQL - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"L&#8217;objectif de cet article est de d\u00e9crire la proc\u00e9dure de resynchronisation d&#8217;un Slave suite \u00e0 un probl\u00e8me de r\u00e9plication MySQL li\u00e9 au Master. Derni\u00e8rement, chez un client, un probl\u00e8me est survenu sur le Master d&#8217;une r\u00e9plication MySQL. En effet, le&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-08T11:01:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-21T16:17:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_slave_status_resynchronistation_en_cours.png\" \/>\n\t<meta property=\"og:image:width\" content=\"561\" \/>\n\t<meta property=\"og:image:height\" content=\"702\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Capdata team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Capdata team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/\"},\"author\":{\"name\":\"Capdata team\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\"},\"headline\":\"R\u00e9plication MySQL : Resynchronisation d&#8217;un Slave MySQL\",\"datePublished\":\"2019-02-08T11:01:13+00:00\",\"dateModified\":\"2025-11-21T16:17:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/\"},\"wordCount\":551,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"replication\",\"resynchronisation\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/\",\"name\":\"R\u00e9plication MySQL : Resynchronisation d'un Slave MySQL - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2019-02-08T11:01:13+00:00\",\"dateModified\":\"2025-11-21T16:17:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"R\u00e9plication MySQL : Resynchronisation d&#8217;un Slave MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\",\"name\":\"Capdata team\",\"sameAs\":[\"https:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"R\u00e9plication MySQL : Resynchronisation d'un Slave MySQL - Capdata TECH BLOG","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:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/","og_locale":"fr_FR","og_type":"article","og_title":"R\u00e9plication MySQL : Resynchronisation d'un Slave MySQL - Capdata TECH BLOG","og_description":"L&#8217;objectif de cet article est de d\u00e9crire la proc\u00e9dure de resynchronisation d&#8217;un Slave suite \u00e0 un probl\u00e8me de r\u00e9plication MySQL li\u00e9 au Master. Derni\u00e8rement, chez un client, un probl\u00e8me est survenu sur le Master d&#8217;une r\u00e9plication MySQL. En effet, le&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2019-02-08T11:01:13+00:00","article_modified_time":"2025-11-21T16:17:05+00:00","og_image":[{"width":561,"height":702,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/show_slave_status_resynchronistation_en_cours.png","type":"image\/png"}],"author":"Capdata team","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Capdata team","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/"},"author":{"name":"Capdata team","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9"},"headline":"R\u00e9plication MySQL : Resynchronisation d&#8217;un Slave MySQL","datePublished":"2019-02-08T11:01:13+00:00","dateModified":"2025-11-21T16:17:05+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/"},"wordCount":551,"commentCount":2,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["replication","resynchronisation"],"articleSection":["MySQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/","url":"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/","name":"R\u00e9plication MySQL : Resynchronisation d'un Slave MySQL - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2019-02-08T11:01:13+00:00","dateModified":"2025-11-21T16:17:05+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"R\u00e9plication MySQL : Resynchronisation d&#8217;un Slave MySQL"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9","name":"Capdata team","sameAs":["https:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/7040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=7040"}],"version-history":[{"count":33,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/7040\/revisions"}],"predecessor-version":[{"id":10771,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/7040\/revisions\/10771"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7094"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=7040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=7040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=7040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}