{"id":194,"date":"2013-08-06T01:04:16","date_gmt":"2013-08-06T01:04:16","guid":{"rendered":"https:\/\/digitalchild.info\/?p=194"},"modified":"2013-08-06T01:04:16","modified_gmt":"2013-08-06T01:04:16","slug":"remove-a-mysql-replication-slave","status":"publish","type":"post","link":"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/","title":{"rendered":"Remove A MySQL Replication Slave"},"content":{"rendered":"<p>There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions.<\/p>\n<p>Log in to your mysql slave and make sure that nothing is accessing the slave database.<\/p>\n<p>Run the following commands.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\nmysql&gt; STOP SLAVE;\n\nmysql&gt; CHANGE MASTER TO MASTER_HOST=' ';\n\nmysql&gt; RESET SLAVE;\n\n<\/pre>\n<p><em>Note: There is a space between the apostrophes.\u00a0<\/em><\/p>\n<p>You will then need to remove the Slave configuration from your mysql configuration file (my.cnf). You will need to comment out or remove any line that has the following:<\/p>\n<ul>\n<li>server-<\/li>\n<li>master-<\/li>\n<li>relay-<\/li>\n<\/ul>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\nvi \/etc\/my.cnf\n\n<\/pre>\n<p>Restart mysql to reload the configuration.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\nservice mysqld restart\n\n<\/pre>\n<p>You can test that the slave is disabled by checking the slave status and it returns an empty set. .<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\nmysql&gt; SHOW SLAVE STATUS \\G\nEmpty set (0.00 sec)\n\n<\/pre>\n<p>After the slave is completely offline you might want to remove the database that was replicating so you can go ahead and drop the replicated database and ensure the slave is clean.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\nmysql&gt; DROP DATABASE databasename;\n\n<\/pre>\n<p>MySQL replication is now completely disabled and the server is clean of any data you might have replicated to it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions. Log in to your mysql slave and make sure that nothing is accessing the slave database. Run the following commands. Note: There &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"ast-button\" href=\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/\"> <span class=\"screen-reader-text\">Remove A MySQL Replication Slave<\/span> Read More \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[5],"tags":[46,128,164],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.11 (Yoast SEO v20.11) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Remove A MySQL Replication Slave - Random Adult<\/title>\n<meta name=\"description\" content=\"There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Remove A MySQL Replication Slave\" \/>\n<meta property=\"og:description\" content=\"There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/\" \/>\n<meta property=\"og:site_name\" content=\"Random Adult\" \/>\n<meta property=\"article:published_time\" content=\"2013-08-06T01:04:16+00:00\" \/>\n<meta name=\"author\" content=\"digitalchild\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dcwhatwhat\" \/>\n<meta name=\"twitter:site\" content=\"@dcwhatwhat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"digitalchild\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/\"},\"author\":{\"name\":\"digitalchild\",\"@id\":\"https:\/\/randomadult.local\/#\/schema\/person\/b0b954202434291ace51b4e7a0a81c04\"},\"headline\":\"Remove A MySQL Replication Slave\",\"datePublished\":\"2013-08-06T01:04:16+00:00\",\"dateModified\":\"2013-08-06T01:04:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/\"},\"wordCount\":217,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/randomadult.local\/#organization\"},\"keywords\":[\"database\",\"mysql\",\"replication\"],\"articleSection\":[\"Geek\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/\",\"url\":\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/\",\"name\":\"Remove A MySQL Replication Slave - Random Adult\",\"isPartOf\":{\"@id\":\"https:\/\/randomadult.local\/#website\"},\"datePublished\":\"2013-08-06T01:04:16+00:00\",\"dateModified\":\"2013-08-06T01:04:16+00:00\",\"description\":\"There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions.\",\"breadcrumb\":{\"@id\":\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/randomadult.local\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Remove A MySQL Replication Slave\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/randomadult.local\/#website\",\"url\":\"https:\/\/randomadult.local\/\",\"name\":\"Random Adult\",\"description\":\"Ramblings of a random adult\",\"publisher\":{\"@id\":\"https:\/\/randomadult.local\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/randomadult.local\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/randomadult.local\/#organization\",\"name\":\"Random Adult\",\"url\":\"https:\/\/randomadult.local\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/randomadult.local\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/randomadult.local\/wp-content\/uploads\/2020\/01\/logo.png\",\"contentUrl\":\"https:\/\/randomadult.local\/wp-content\/uploads\/2020\/01\/logo.png\",\"width\":320,\"height\":134,\"caption\":\"Random Adult\"},\"image\":{\"@id\":\"https:\/\/randomadult.local\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/twitter.com\/dcwhatwhat\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/randomadult.local\/#\/schema\/person\/b0b954202434291ace51b4e7a0a81c04\",\"name\":\"digitalchild\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/randomadult.local\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e0331079f6730910bc7760cb8f781237?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e0331079f6730910bc7760cb8f781237?s=96&d=mm&r=g\",\"caption\":\"digitalchild\"},\"url\":\"https:\/\/randomadult.local\/author\/digitalchild\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Remove A MySQL Replication Slave - Random Adult","description":"There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions.","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:\/\/randomadult.local\/remove-a-mysql-replication-slave\/","og_locale":"en_US","og_type":"article","og_title":"Remove A MySQL Replication Slave","og_description":"There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions.","og_url":"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/","og_site_name":"Random Adult","article_published_time":"2013-08-06T01:04:16+00:00","author":"digitalchild","twitter_card":"summary_large_image","twitter_creator":"@dcwhatwhat","twitter_site":"@dcwhatwhat","twitter_misc":{"Written by":"digitalchild","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/#article","isPartOf":{"@id":"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/"},"author":{"name":"digitalchild","@id":"https:\/\/randomadult.local\/#\/schema\/person\/b0b954202434291ace51b4e7a0a81c04"},"headline":"Remove A MySQL Replication Slave","datePublished":"2013-08-06T01:04:16+00:00","dateModified":"2013-08-06T01:04:16+00:00","mainEntityOfPage":{"@id":"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/"},"wordCount":217,"commentCount":0,"publisher":{"@id":"https:\/\/randomadult.local\/#organization"},"keywords":["database","mysql","replication"],"articleSection":["Geek"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/","url":"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/","name":"Remove A MySQL Replication Slave - Random Adult","isPartOf":{"@id":"https:\/\/randomadult.local\/#website"},"datePublished":"2013-08-06T01:04:16+00:00","dateModified":"2013-08-06T01:04:16+00:00","description":"There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions.","breadcrumb":{"@id":"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/randomadult.local\/remove-a-mysql-replication-slave\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/randomadult.local\/"},{"@type":"ListItem","position":2,"name":"Remove A MySQL Replication Slave"}]},{"@type":"WebSite","@id":"https:\/\/randomadult.local\/#website","url":"https:\/\/randomadult.local\/","name":"Random Adult","description":"Ramblings of a random adult","publisher":{"@id":"https:\/\/randomadult.local\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/randomadult.local\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/randomadult.local\/#organization","name":"Random Adult","url":"https:\/\/randomadult.local\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/randomadult.local\/#\/schema\/logo\/image\/","url":"https:\/\/randomadult.local\/wp-content\/uploads\/2020\/01\/logo.png","contentUrl":"https:\/\/randomadult.local\/wp-content\/uploads\/2020\/01\/logo.png","width":320,"height":134,"caption":"Random Adult"},"image":{"@id":"https:\/\/randomadult.local\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/twitter.com\/dcwhatwhat"]},{"@type":"Person","@id":"https:\/\/randomadult.local\/#\/schema\/person\/b0b954202434291ace51b4e7a0a81c04","name":"digitalchild","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/randomadult.local\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e0331079f6730910bc7760cb8f781237?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e0331079f6730910bc7760cb8f781237?s=96&d=mm&r=g","caption":"digitalchild"},"url":"https:\/\/randomadult.local\/author\/digitalchild\/"}]}},"_links":{"self":[{"href":"https:\/\/randomadult.local\/wp-json\/wp\/v2\/posts\/194"}],"collection":[{"href":"https:\/\/randomadult.local\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/randomadult.local\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/randomadult.local\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/randomadult.local\/wp-json\/wp\/v2\/comments?post=194"}],"version-history":[{"count":0,"href":"https:\/\/randomadult.local\/wp-json\/wp\/v2\/posts\/194\/revisions"}],"wp:attachment":[{"href":"https:\/\/randomadult.local\/wp-json\/wp\/v2\/media?parent=194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/randomadult.local\/wp-json\/wp\/v2\/categories?post=194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/randomadult.local\/wp-json\/wp\/v2\/tags?post=194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}