{"id":55,"date":"2019-02-10T17:17:35","date_gmt":"2019-02-10T09:17:35","guid":{"rendered":"http:\/\/b.yesiyu.top\/?p=55"},"modified":"2019-02-10T17:17:35","modified_gmt":"2019-02-10T09:17:35","slug":"docker-%e5%ae%89%e8%a3%85-mysql","status":"publish","type":"post","link":"https:\/\/b.yesiyu.top\/?p=55","title":{"rendered":"Docker \u5b89\u88c5 MySQL"},"content":{"rendered":"

\u65b9\u6cd5\u4e00\u3001docker pull mysql<\/h3>\n

\u67e5\u627eDocker Hub\u4e0a\u7684mysql\u955c\u50cf<\/p>\n

runoob@runoob<\/span>:\/<\/span>mysql$ docker search mysql\r\nNAME                     DESCRIPTION                                     STARS     OFFICIAL   AUTOMATED\r\nmysql                    <\/span>MySQL<\/span> is<\/span> a widely used<\/span>,<\/span> open<\/span>-<\/span>source relati<\/span>...<\/span>   2529<\/span>      [<\/span>OK<\/span>]<\/span>       \r\nmysql<\/span>\/<\/span>mysql<\/span>-<\/span>server       <\/span>Optimized<\/span> MySQL<\/span> Server<\/span> Docker<\/span> images<\/span>.<\/span> Crea<\/span>...<\/span>   161<\/span>                  [<\/span>OK<\/span>]<\/span>\r\ncenturylink<\/span>\/<\/span>mysql        <\/span>Image<\/span> containing mysql<\/span>.<\/span> Optimized<\/span> to be li<\/span>...<\/span>   45<\/span>                   [<\/span>OK<\/span>]<\/span>\r\nsameersbn<\/span>\/<\/span>mysql                                                          <\/span>36<\/span>                   [<\/span>OK<\/span>]<\/span>\r\ngoogle<\/span>\/<\/span>mysql             <\/span>MySQL<\/span> server <\/span>for<\/span> Google<\/span> Compute<\/span> Engine<\/span>          16<\/span>                   [<\/span>OK<\/span>]<\/span>\r\nappcontainers<\/span>\/<\/span>mysql      <\/span>Centos<\/span>\/<\/span>Debian<\/span> Based<\/span> Customizable<\/span> MySQL<\/span> Con<\/span>...<\/span>   8<\/span>                    [<\/span>OK<\/span>]<\/span>\r\nmarvambass<\/span>\/<\/span>mysql         <\/span>MySQL<\/span> Server<\/span> based on <\/span>Ubuntu<\/span> 14.04<\/span>              6<\/span>                    [<\/span>OK<\/span>]<\/span>\r\ndrupaldocker<\/span>\/<\/span>mysql       <\/span>MySQL<\/span> for<\/span> Drupal<\/span>                                2<\/span>                    [<\/span>OK<\/span>]<\/span>\r\nazukiapp<\/span>\/<\/span>mysql           <\/span>Docker<\/span> image to run <\/span>MySQL<\/span> by<\/span> Azuki<\/span> -<\/span> http<\/span>:...<\/span>   2<\/span>                    [<\/span>OK<\/span>]<\/span>\r\n...<\/span><\/pre>\n
\u8fd9\u91cc\u6211\u4eec\u62c9\u53d6\u5b98\u65b9\u7684\u955c\u50cf,\u6807\u7b7e\u4e3a5.6<\/p>\n
runoob@runoob<\/span>:~\/<\/span>mysql$ docker pull mysql<\/span>:<\/span>5.6<\/span><\/pre>\n
\u7b49\u5f85\u4e0b\u8f7d\u5b8c\u6210\u540e\uff0c\u6211\u4eec\u5c31\u53ef\u4ee5\u5728\u672c\u5730\u955c\u50cf\u5217\u8868\u91cc\u67e5\u5230REPOSITORY\u4e3amysql,\u6807\u7b7e\u4e3a5.6\u7684\u955c\u50cf\u3002<\/p>\n
runoob@runoob<\/span>:~\/<\/span>mysql$ docker images <\/span>|<\/span>grep mysql\r\nmysql               <\/span>5.6<\/span>                 2c0964ec182a<\/span>        3<\/span> weeks ago         <\/span>329<\/span> MB<\/span><\/pre>\n
\u65b9\u6cd5\u4e8c\u3001\u901a\u8fc7 Dockerfile\u6784\u5efa<\/h3>\n
\u521b\u5efaDockerfile<\/p>\n
\u9996\u5148\uff0c\u521b\u5efa\u76ee\u5f55mysql,\u7528\u4e8e\u5b58\u653e\u540e\u9762\u7684\u76f8\u5173\u4e1c\u897f\u3002<\/p>\n
runoob@runoob<\/span>:~<\/span>$ mkdir <\/span>-<\/span>p <\/span>~<\/span>\/mysql\/<\/span>data <\/span>~<\/span>\/mysql\/<\/span>logs <\/span>~<\/span>\/mysql\/<\/span>conf<\/span><\/pre>\n
data\u76ee\u5f55\u5c06\u6620\u5c04\u4e3amysql\u5bb9\u5668\u914d\u7f6e\u7684\u6570\u636e\u6587\u4ef6\u5b58\u653e\u8def\u5f84<\/p>\n
logs\u76ee\u5f55\u5c06\u6620\u5c04\u4e3amysql\u5bb9\u5668\u7684\u65e5\u5fd7\u76ee\u5f55<\/p>\n
conf\u76ee\u5f55\u91cc\u7684\u914d\u7f6e\u6587\u4ef6\u5c06\u6620\u5c04\u4e3amysql\u5bb9\u5668\u7684\u914d\u7f6e\u6587\u4ef6<\/p>\n
\u8fdb\u5165\u521b\u5efa\u7684mysql\u76ee\u5f55\uff0c\u521b\u5efaDockerfile<\/p>\n
FROM debian<\/span>:<\/span>jessie\r\n\r\n<\/span># add our user and group first to make sure their IDs get assigned consistently, regardless of whatever dependencies get added<\/span>\r\nRUN groupadd <\/span>-<\/span>r mysql <\/span>&&<\/span> useradd <\/span>-<\/span>r <\/span>-<\/span>g mysql mysql\r\n\r\n<\/span># add gosu for easy step-down from root<\/span>\r\nENV GOSU_VERSION <\/span>1.7<\/span>\r\nRUN <\/span>set<\/span> -<\/span>x \\\r\n\u00a0\u00a0\u00a0\u00a0<\/span>&&<\/span> apt<\/span>-<\/span>get<\/span> update <\/span>&&<\/span> apt<\/span>-<\/span>get<\/span> install <\/span>-<\/span>y <\/span>--<\/span>no<\/span>-<\/span>install<\/span>-<\/span>recommends ca<\/span>-<\/span>certificates wget <\/span>&&<\/span> rm <\/span>-<\/span>rf <\/span>\/<\/span>var<\/span>\/<\/span>lib<\/span>\/<\/span>apt<\/span>\/<\/span>lists<\/span>\/* \\\r\n\u00a0\u00a0\u00a0\u00a0&& wget -O \/usr\/local\/bin\/gosu \"https:\/\/github.com\/tianon\/gosu\/releases\/download\/$GOSU_VERSION\/gosu-$(dpkg --print-architecture)\" \\\r\n\u00a0\u00a0\u00a0\u00a0&& wget -O \/usr\/local\/bin\/gosu.asc \"https:\/\/github.com\/tianon\/gosu\/releases\/download\/$GOSU_VERSION\/gosu-$(dpkg --print-architecture).asc\" \\\r\n\u00a0\u00a0\u00a0\u00a0&& export GNUPGHOME=\"$(mktemp -d)\" \\\r\n\u00a0\u00a0\u00a0\u00a0&& gpg --keyserver ha.pool.sks-keyservers.net --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4 \\\r\n\u00a0\u00a0\u00a0\u00a0&& gpg --batch --verify \/usr\/local\/bin\/gosu.asc \/usr\/local\/bin\/gosu \\\r\n\u00a0\u00a0\u00a0\u00a0&& rm -r \"$GNUPGHOME\" \/usr\/local\/bin\/gosu.asc \\\r\n\u00a0\u00a0\u00a0\u00a0&& chmod +x \/usr\/local\/bin\/gosu \\\r\n\u00a0\u00a0\u00a0\u00a0&& gosu nobody true \\\r\n\u00a0\u00a0\u00a0\u00a0&& apt-get purge -y --auto-remove ca-certificates wget\r\n\r\nRUN mkdir \/docker-entrypoint-initdb.d\r\n\r\n# FATAL ERROR: please install the following Perl modules before executing \/usr\/local\/mysql\/scripts\/mysql_install_db:\r\n# File::Basename\r\n# File::Copy\r\n# Sys::Hostname\r\n# Data::Dumper\r\nRUN apt-get update && apt-get install -y perl pwgen --no-install-recommends && rm -rf \/var\/lib\/apt\/lists\/*\r\n\r\n# gpg: key 5072E1F5: public key \"MySQL Release Engineering <mysql-build@oss.oracle.com>\" imported\r\nRUN apt-key adv --keyserver ha.pool.sks-keyservers.net --recv-keys A4A9406876FCBD3C456770C88C718D3B5072E1F5\r\n\r\nENV MYSQL_MAJOR 5.6\r\nENV MYSQL_VERSION 5.6.31-1debian8\r\n\r\nRUN echo \"deb http:\/\/repo.mysql.com\/apt\/debian\/ jessie mysql-${MYSQL_MAJOR}\" > \/etc\/apt\/sources.list.d\/mysql.list\r\n\r\n# the \"\/var\/lib\/mysql\" stuff here is because the mysql-server postinst doesn't have an explicit way to disable the mysql_install_db codepath besides having a database already \"configured\" (ie, stuff in \/var\/lib\/mysql\/mysql)\r\n# also, we set debconf keys to make APT a little quieter\r\nRUN { \\\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo mysql-community-server mysql-community-server\/data-dir select ''; \\\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo mysql-community-server mysql-community-server\/root-pass password ''; \\\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo mysql-community-server mysql-community-server\/re-root-pass password ''; \\\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo mysql-community-server mysql-community-server\/remove-test-db select false; \\\r\n\u00a0\u00a0\u00a0\u00a0} | debconf-set-selections \\\r\n\u00a0\u00a0\u00a0\u00a0&& apt-get update && apt-get install -y mysql-server=\"${MYSQL_VERSION}\" && rm -rf \/var\/lib\/apt\/lists\/* \\\r\n\u00a0\u00a0\u00a0\u00a0&& rm -rf \/var\/lib\/mysql && mkdir -p \/var\/lib\/mysql \/var\/run\/mysqld \\\r\n\u00a0\u00a0\u00a0\u00a0&& chown -R mysql:mysql \/var\/lib\/mysql \/var\/run\/mysqld \\\r\n# ensure that \/var\/run\/mysqld (used for socket and lock files) is writable regardless of the UID our mysqld instance ends up having at runtime\r\n\u00a0\u00a0\u00a0\u00a0&& chmod 777 \/var\/run\/mysqld\r\n\r\n# comment out a few problematic configuration values\r\n# don't reverse lookup hostnames, they are usually another container\r\nRUN sed -Ei 's\/^(bind-address|log)\/#&\/' \/etc\/mysql\/my.cnf \\\r\n\u00a0\u00a0\u00a0\u00a0&& echo 'skip-host-cache\\nskip-name-resolve' | awk '{ print } $1 == \"[mysqld]\" && c == 0 { c = 1; system(\"cat\") }' \/etc\/mysql\/my.cnf > \/tmp\/my.cnf \\\r\n\u00a0\u00a0\u00a0\u00a0&& mv \/tmp\/my.cnf \/etc\/mysql\/my.cnf\r\n\r\nVOLUME \/var\/lib\/mysql\r\n\r\nCOPY docker-entrypoint.sh \/usr\/local\/bin\/\r\nRUN ln -s usr\/local\/bin\/docker-entrypoint.sh \/entrypoint.sh # backwards compat\r\nENTRYPOINT [\"docker-entrypoint.sh\"]\r\n\r\nEXPOSE 3306\r\nCMD [\"mysqld\"]<\/span><\/pre>\n
\u901a\u8fc7Dockerfile\u521b\u5efa\u4e00\u4e2a\u955c\u50cf\uff0c\u66ff\u6362\u6210\u4f60\u81ea\u5df1\u7684\u540d\u5b57<\/p>\n
runoob@runoob<\/span>:~\/<\/span>mysql$ docker build <\/span>-<\/span>t mysql <\/span>.<\/span><\/pre>\n
\u521b\u5efa\u5b8c\u6210\u540e\uff0c\u6211\u4eec\u53ef\u4ee5\u5728\u672c\u5730\u7684\u955c\u50cf\u5217\u8868\u91cc\u67e5\u627e\u5230\u521a\u521a\u521b\u5efa\u7684\u955c\u50cf<\/p>\n
runoob@runoob<\/span>:~\/<\/span>mysql$ docker images <\/span>|<\/span>grep mysql\r\nmysql               <\/span>5.6<\/span>                 2c0964ec182a<\/span>        3<\/span> weeks ago         <\/span>329<\/span> MB<\/span><\/pre>\n
\n
\u4f7f\u7528mysql\u955c\u50cf<\/h2>\n
\u8fd0\u884c\u5bb9\u5668<\/h3>\n
runoob@runoob<\/span>:~<\/span>\/mysql$ docker run -p 3306:3306 --name mymysql -v $PWD\/<\/span>conf<\/span>:<\/span>\/etc\/<\/span>mysql<\/span>\/<\/span>conf<\/span>.<\/span>d <\/span>-<\/span>v $PWD<\/span>\/<\/span>logs<\/span>:<\/span>\/logs -v $PWD\/<\/span>data<\/span>:<\/span>\/var\/<\/span>lib<\/span>\/<\/span>mysql <\/span>-<\/span>e MYSQL_ROOT_PASSWORD<\/span>=<\/span>123456<\/span> -<\/span>d mysql<\/span>:<\/span>5.6<\/span>\r\n21cb89213c93d805c5bacf1028a0da7b5c5852761ba81327e6b99bb3ea89930e<\/span>\r\nrunoob@runoob<\/span>:~\/<\/span>mysql$ <\/span><\/pre>\n
\u547d\u4ee4\u8bf4\u660e\uff1a<\/p>\n