{"id":342,"date":"2023-07-31T09:50:44","date_gmt":"2023-07-31T01:50:44","guid":{"rendered":"https:\/\/www.aqrboyblog.top\/?p=342"},"modified":"2023-07-31T09:50:45","modified_gmt":"2023-07-31T01:50:45","slug":"mysql%e4%b8%bb%e4%bb%8e%e6%95%b0%e6%8d%ae%e5%ba%93-docker%e7%8e%af%e5%a2%83","status":"publish","type":"post","link":"https:\/\/www.aqrboyblog.top\/?p=342","title":{"rendered":"mysql\u4e3b\u4ece\u6570\u636e\u5e93 docker\u73af\u5883"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">1.\u914d\u7f6e\u4e3b\u5e93<\/h2>\n\n\n\n<p>master.cnf<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;mysqld]\n# \u540c\u4e00\u5c40\u57df\u7f51\u5185\u6ce8\u610f\u8981\u552f\u4e00\nserver-id=100\n# \u5f00\u542f\u4e8c\u8fdb\u5236\u65e5\u5fd7\u529f\u80fd\uff0c\u53ef\u4ee5\u968f\u4fbf\u53d6\nlog-bin=mysql-bin<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>\u67e5\u770b\u4e8c\u8fdb\u5236\u65e5\u5fd7\u662f\u5426\u5f00\u542f \nSHOW GLOBAL VARIABLES LIKE '%log%';\n\u67e5\u770b\u4e3b\u8282\u70b9\u7684server id\nSHOW GLOBAL VARIABLES LIKE '%server%';\n\u521b\u5efa\u6709\u590d\u5236\u6743\u9650\u7684\u7528\u6237slave\nCREATE USER 'slave'@'%' IDENTIFIED BY '123456';\r\nGRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'slave'@'%' IDENTIFIED by '123456';\n\u5237\u65b0\u914d\u7f6e\r\nFLUSH PRIVILEGES;\n\u67e5\u770bFile\u548cPosition\u5b57\u6bb5\u7684\u503c\r\nshow master status;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">2.\u914d\u7f6e\u4ece\u5e93<\/h2>\n\n\n\n<p>slave.cnf <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;mysqld]\nserver-id=101\r\n#\u5f00\u542f\u4e8c\u8fdb\u5236\u65e5\u5fd7\u529f\u80fd\uff0c\u4ee5\u5907Slave\u4f5c\u4e3a\u5176\u5b83Slave\u7684Master\u65f6\u4f7f\u7528\r\nlog-bin=mysql-slave-bin\r\n#relay_log\u914d\u7f6e\u4e2d\u7ee7\u65e5\u5fd7\r\nrelay_log=edu-mysql-relay-bin<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>\u505c\u6b62\u4e3b\u4ece\u590d\u5236\nstop slave;\n\u8bbe\u7f6e\u4e3b\u6570\u636e\u5e93\u4fe1\u606f\nchange master to master_host='172.17.0.5', master_user='slave', master_password='123456', master_port=3306, master_log_file='mysql-bin.000001', master_log_pos=856, master_connect_retry=30;\n\u542f\u52a8\u4e3b\u4ece\u590d\u5236\nstart slave;\n\u67e5\u770b\u4e3b\u4ece\u540c\u6b65\u72b6\u6001\nshow slave status;<\/code><\/pre>\n\n\n\n<p>\u8bbe\u7f6e\u4ece\u5e93\u53ea\u8bfb<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5f00\u542f\u53ea\u8bfb\r\nshow global variables like \"%read_only%\";\r\n# \u5bf9\u6240\u6709\u7528\u6237\u751f\u6548\uff0c\u5305\u62ecsuper\u7528\u6237\uff08\u4e0d\u5efa\u8bae\u4f7f\u7528\uff09\r\nflush tables with read lock;\r\n# \u53ea\u5bf9\u666e\u901a\u7528\u6237\u751f\u6548\uff0c\u5982slave\u7528\u6237\r\nset global read_only=1;\r\nshow global variables like \"%read_only%\";\r\n# \u5173\u95ed\u53ea\u8bfb\r\nunlock tables;\r\nset global read_only=0;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Docker\u914d\u7f6e<\/h2>\n\n\n\n<p>\u521b\u5efa \/app\/docker_files\/mysql \u6587\u4ef6\u5939<\/p>\n\n\n\n<p>docker-compose.yml \u914d\u7f6e\u6587\u4ef6  \u653e\u5728 \/app\/docker_files\u76ee\u5f55\u4e0b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>version: '3'\nservices:    \n  db-master:\n    build: '.\/mysql'\n    image: 'db-server:1.0'\n    container_name: 'db-master'\n    ports:\n      - \"3366:3306\"\n    volumes:\n      - \"\/app\/docker_files\/mysql\/conf\/master.cnf:\/etc\/mysql\/conf.d\/master.cnf\"\n      - \"\/app\/docker_files\/mysql\/data:\/var\/lib\/mysql\"\n    restart: always\n    environment:\n      MYSQL_ROOT_PASSWORD: qwe123!@#\n    command: &#91;\"mysqld\", \"--server-id=1\", \"--log-bin=mysql-bin\"]\n    networks:\n      - lnmp  \n  db-slave:\n    build: '.\/mysql'\n    image: 'db-server:1.0'\n    container_name: 'db-slave'\n    ports:\n      - \"3307:3306\"\n    volumes:\n      - \"\/app\/docker_files\/mysql\/conf\/slave.cnf:\/etc\/mysql\/conf.d\/slave.cnf\"\n      - \"\/app\/docker_files\/mysql\/slave-data:\/var\/lib\/mysql\"\n    restart: always\n    environment:\n      MYSQL_ROOT_PASSWORD: qwe123!@#\n    command: &#91;\"mysqld\", \"--server-id=2\"]\n    networks:\n      - lnmp  \nnetworks:\n  lnmp:\n    driver: bridge \n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p class=\"text-justify\">1.\u914d\u7f6e\u4e3b\u5e93 master.cnf 2.\u914d\u7f6e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-342","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=\/wp\/v2\/posts\/342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=342"}],"version-history":[{"count":14,"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions"}],"predecessor-version":[{"id":356,"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions\/356"}],"wp:attachment":[{"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aqrboyblog.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}