{"id":21318,"date":"2024-03-15T21:54:01","date_gmt":"2024-03-15T21:54:01","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/"},"modified":"2024-03-21T20:11:58","modified_gmt":"2024-03-21T20:11:58","slug":"how-to-deploy-mysql-master-slave-replication-with-docker","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/","title":{"rendered":"How to deploy MySQL master-slave replication with Docker?"},"content":{"rendered":"

To deploy MySQL master-slave replication in Docker, the following steps need to be carried out:<\/p>\n

    \n
  1. Set up a network (optional):<\/li>\n
  2. Create a network called mysql-net using Docker.<\/li>\n
  3. Start the MySQL master node container.<\/li>\n
  4. Start a Docker container named mysql-master on the mysql-net network with port 3306 mapped to the host, setting the MYSQL_ROOT_PASSWORD environment variable to “password”, using the mysql image.<\/li>\n
  5. Start the MySQL standby node container.<\/li>\n
  6. Run a mysql container named mysql-slave, in detached mode, on the mysql-net network with port 3307 mapped to port 3306, setting the MySQL root password to “password”.<\/li>\n
  7. Enable binary logging and master-slave replication in the master node container.<\/li>\n
  8. Run the “docker exec -it mysql-master bash” command to access the MySQL shell, then log in as the root user. grant replication privileges to a user ‘slave_user’ identified by ‘password’, flush privileges, lock tables for reading, and display the master status.<\/li>\n
  9. Note down the values of File and Position.<\/li>\n
  10. Configuring master-slave replication from the node container.<\/li>\n
  11. Log into the MySQL slave container using Docker, then enter the MySQL server using the root user. Update the master server information with the hostname, username, password, log file, and log position, then start the replication process.<\/li>\n
  12. Replace [File] and [Position] with the corresponding values of the master node.<\/li>\n<\/ol>\n

    You have successfully deployed MySQL master-slave replication. You can access the database by connecting to port 3306 on the master node container or port 3307 on the slave node container.<\/p>\n","protected":false},"excerpt":{"rendered":"

    To deploy MySQL master-slave replication in Docker, the following steps need to be carried out: Set up a network (optional): Create a network called mysql-net using Docker. Start the MySQL master node container. Start a Docker container named mysql-master on the mysql-net network with port 3306 mapped to the host, setting the MYSQL_ROOT_PASSWORD environment variable […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-21318","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nHow to deploy MySQL master-slave replication with Docker? - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to deploy MySQL master-slave replication with Docker?\" \/>\n<meta property=\"og:description\" content=\"To deploy MySQL master-slave replication in Docker, the following steps need to be carried out: Set up a network (optional): Create a network called mysql-net using Docker. Start the MySQL master node container. Start a Docker container named mysql-master on the mysql-net network with port 3306 mapped to the host, setting the MYSQL_ROOT_PASSWORD environment variable […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/\" \/>\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-15T21:54:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T20:11:58+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\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=\"Sophia Anderson\" \/>\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:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"How to deploy MySQL master-slave replication with Docker?\",\"datePublished\":\"2024-03-15T21:54:01+00:00\",\"dateModified\":\"2024-03-21T20:11:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/\"},\"wordCount\":246,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/\",\"name\":\"How to deploy MySQL master-slave replication with Docker? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T21:54:01+00:00\",\"dateModified\":\"2024-03-21T20:11:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to deploy MySQL master-slave replication with Docker?\"}]},{\"@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\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to deploy MySQL master-slave replication with Docker? - Blog - Silicon Cloud","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\/how-to-deploy-mysql-master-slave-replication-with-docker\/","og_locale":"en_US","og_type":"article","og_title":"How to deploy MySQL master-slave replication with Docker?","og_description":"To deploy MySQL master-slave replication in Docker, the following steps need to be carried out: Set up a network (optional): Create a network called mysql-net using Docker. Start the MySQL master node container. Start a Docker container named mysql-master on the mysql-net network with port 3306 mapped to the host, setting the MYSQL_ROOT_PASSWORD environment variable […]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T21:54:01+00:00","article_modified_time":"2024-03-21T20:11:58+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"How to deploy MySQL master-slave replication with Docker?","datePublished":"2024-03-15T21:54:01+00:00","dateModified":"2024-03-21T20:11:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/"},"wordCount":246,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/","name":"How to deploy MySQL master-slave replication with Docker? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T21:54:01+00:00","dateModified":"2024-03-21T20:11:58+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-deploy-mysql-master-slave-replication-with-docker\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to deploy MySQL master-slave replication with Docker?"}]},{"@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\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21318","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=21318"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21318\/revisions"}],"predecessor-version":[{"id":55173,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21318\/revisions\/55173"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=21318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=21318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=21318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}