{"id":11735,"date":"2024-03-14T14:37:34","date_gmt":"2024-03-14T14:37:34","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/"},"modified":"2025-08-04T16:16:34","modified_gmt":"2025-08-04T16:16:34","slug":"what-are-the-steps-for-switching-mysql-master-slave","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/","title":{"rendered":"MySQL Master-Slave Switch: Step-by-Step"},"content":{"rendered":"

MySQL master-slave switch is a high availability solution for databases, which ensures that in case of failure in the master database, the slave database can take over and continue providing services. The steps for the switch are as follows:<\/p>\n

    \n
  1. Confirming the failure of the primary database: First, it is necessary to confirm that the primary database has experienced a failure and is unable to provide service.<\/li>\n
  2. Manual Switching: This refers to the administrator manually performing a switch operation, promoting the standby database to become the primary database. During manual switching, the following steps need to be conducted:<\/li>\n
  3. Stop the replication process from the database.<\/li>\n
  4. Stop the slave replication by executing the STOP SLAVE command on the database.<\/li>\n
  5. To enable read-write functionality on the database, execute the command SET GLOBAL read_only=OFF;<\/li>\n
  6. Executing the RESET MASTER command on the database will clear the binary logs.<\/li>\n
  7. Stop the MySQL service on the main database.<\/li>\n
  8. Switch the data directory from the database to the main database.<\/li>\n
  9. Start the MySQL service.<\/li>\n
  10. Automatic failover is the process where the system automatically promotes a standby database to the primary database when the primary database fails. This process relies on high availability software such as Pacemaker and Corosync, which monitor the status of the primary database and initiate the failover process when needed.<\/li>\n<\/ol>\n

    Regardless of whether it is manually or automatically switched, it is necessary to perform some essential checks and tests on the database after switching to ensure a successful switch and proper system operation.<\/p>\n","protected":false},"excerpt":{"rendered":"

    MySQL master-slave switch is a high availability solution for databases, which ensures that in case of failure in the master database, the slave database can take over and continue providing services. The steps for the switch are as follows: Confirming the failure of the primary database: First, it is necessary to confirm that the primary […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[15203,779,4401,4399,15204],"class_list":["post-11735","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-failover","tag-high-availability","tag-master-slave","tag-mysql-replication","tag-mysql-switch"],"yoast_head":"\nMySQL Master-Slave Switch: Step-by-Step - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to perform MySQL master-slave switches for high availability. Quick guide for database admins.\" \/>\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.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Master-Slave Switch: Step-by-Step\" \/>\n<meta property=\"og:description\" content=\"Learn how to perform MySQL master-slave switches for high availability. Quick guide for database admins.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T14:37:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T16:16:34+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"MySQL Master-Slave Switch: Step-by-Step\",\"datePublished\":\"2024-03-14T14:37:34+00:00\",\"dateModified\":\"2025-08-04T16:16:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/\"},\"wordCount\":254,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database failover\",\"High availability\",\"master-slave\",\"MySQL replication\",\"MySQL switch\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/\",\"name\":\"MySQL Master-Slave Switch: Step-by-Step - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T14:37:34+00:00\",\"dateModified\":\"2025-08-04T16:16:34+00:00\",\"description\":\"Learn how to perform MySQL master-slave switches for high availability. Quick guide for database admins.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Master-Slave Switch: Step-by-Step\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL Master-Slave Switch: Step-by-Step - Blog - Silicon Cloud","description":"Learn how to perform MySQL master-slave switches for high availability. Quick guide for database admins.","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.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Master-Slave Switch: Step-by-Step","og_description":"Learn how to perform MySQL master-slave switches for high availability. Quick guide for database admins.","og_url":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T14:37:34+00:00","article_modified_time":"2025-08-04T16:16:34+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"MySQL Master-Slave Switch: Step-by-Step","datePublished":"2024-03-14T14:37:34+00:00","dateModified":"2025-08-04T16:16:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/"},"wordCount":254,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database failover","High availability","master-slave","MySQL replication","MySQL switch"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/","url":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/","name":"MySQL Master-Slave Switch: Step-by-Step - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T14:37:34+00:00","dateModified":"2025-08-04T16:16:34+00:00","description":"Learn how to perform MySQL master-slave switches for high availability. Quick guide for database admins.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-steps-for-switching-mysql-master-slave\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Master-Slave Switch: Step-by-Step"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=11735"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11735\/revisions"}],"predecessor-version":[{"id":155524,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11735\/revisions\/155524"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=11735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=11735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=11735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}