Docker menginstal MySQL
Sebuah metode dengan membangun Dockerfile
Buat Dockerfile
Pertama, buat mysql direktori, untuk menyimpan barang-barang kembali terkait.
w3big@w3big:~$ mkdir -p ~/mysql/data ~/mysql/logs ~/mysql/conf
direktori data mysql dipetakan ke wadah data path penyimpanan file konfigurasi
direktori log akan dipetakan ke direktori log kontainer mysql
file konfigurasi direktori conf dipetakan ke wadah mysql file konfigurasi
Masukkan direktori mysql dibuat, buat Dockerfile
FROM debian:jessie # add our user and group first to make sure their IDs get assigned consistently, regardless of whatever dependencies get added RUN groupadd -r mysql && useradd -r -g mysql mysql # add gosu for easy step-down from root ENV GOSU_VERSION 1.7 RUN set -x \ && apt-get update && apt-get install -y --no-install-recommends ca-certificates wget && rm -rf /var/lib/apt/lists/* \ && wget -O /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$(dpkg --print-architecture)" \ && wget -O /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$(dpkg --print-architecture).asc" \ && export GNUPGHOME="$(mktemp -d)" \ && gpg --keyserver ha.pool.sks-keyservers.net --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4 \ && gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu \ && rm -r "$GNUPGHOME" /usr/local/bin/gosu.asc \ && chmod +x /usr/local/bin/gosu \ && gosu nobody true \ && apt-get purge -y --auto-remove ca-certificates wget RUN mkdir /docker-entrypoint-initdb.d # FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql/scripts/mysql_install_db: # File::Basename # File::Copy # Sys::Hostname # Data::Dumper RUN apt-get update && apt-get install -y perl pwgen --no-install-recommends && rm -rf /var/lib/apt/lists/* # gpg: key 5072E1F5: public key "MySQL Release Engineering <mysql-build@oss.oracle.com>" imported RUN apt-key adv --keyserver ha.pool.sks-keyservers.net --recv-keys A4A9406876FCBD3C456770C88C718D3B5072E1F5 ENV MYSQL_MAJOR 5.6 ENV MYSQL_VERSION 5.6.31-1debian8 RUN echo "deb http://repo.mysql.com/apt/debian/ jessie mysql-${MYSQL_MAJOR}" > /etc/apt/sources.list.d/mysql.list # 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) # also, we set debconf keys to make APT a little quieter RUN { \ echo mysql-community-server mysql-community-server/data-dir select ''; \ echo mysql-community-server mysql-community-server/root-pass password ''; \ echo mysql-community-server mysql-community-server/re-root-pass password ''; \ echo mysql-community-server mysql-community-server/remove-test-db select false; \ } | debconf-set-selections \ && apt-get update && apt-get install -y mysql-server="${MYSQL_VERSION}" && rm -rf /var/lib/apt/lists/* \ && rm -rf /var/lib/mysql && mkdir -p /var/lib/mysql /var/run/mysqld \ && chown -R mysql:mysql /var/lib/mysql /var/run/mysqld \ # 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 && chmod 777 /var/run/mysqld # comment out a few problematic configuration values # don't reverse lookup hostnames, they are usually another container RUN sed -Ei 's/^(bind-address|log)/#&/' /etc/mysql/my.cnf \ && echo 'skip-host-cache\nskip-name-resolve' | awk '{ print } $1 == "[mysqld]" && c == 0 { c = 1; system("cat") }' /etc/mysql/my.cnf > /tmp/my.cnf \ && mv /tmp/my.cnf /etc/mysql/my.cnf VOLUME /var/lib/mysql COPY docker-entrypoint.sh /usr/local/bin/ RUN ln -s usr/local/bin/docker-entrypoint.sh /entrypoint.sh # backwards compat ENTRYPOINT ["docker-entrypoint.sh"] EXPOSE 3306 CMD ["mysqld"]
Buat cermin melalui Dockerfile, menggantinya dengan nama Anda sendiri
w3big@w3big:~/mysql$ docker build -t mysql .
Setelah dibuat, kita dapat menemukan gambar yang baru saja dibuat dalam daftar mirror lokal
w3big@w3big:~/mysql$ docker images |grep mysql mysql 5.6 2c0964ec182a 3 weeks ago 329 MB
Metode dua, buruh pelabuhan tarik mysql
Cari cermin mysql di Docker Hub
w3big@w3big:/mysql$ docker search mysql NAME DESCRIPTION STARS OFFICIAL AUTOMATED mysql MySQL is a widely used, open-source relatiid. 2529 [OK] mysql/mysql-server Optimized MySQL Server Docker images. Creaid. 161 [OK] centurylink/mysql Image containing mysql. Optimized to be liid. 45 [OK] sameersbn/mysql 36 [OK] google/mysql MySQL server for Google Compute Engine 16 [OK] appcontainers/mysql Centos/Debian Based Customizable MySQL Conid. 8 [OK] marvambass/mysql MySQL Server based on Ubuntu 14.04 6 [OK] drupaldocker/mysql MySQL for Drupal 2 [OK] azukiapp/mysql Docker image to run MySQL by Azuki - http:id. 2 [OK] id.
Di sini kita menarik sebuah cermin resmi, berlabel 5.6
w3big@w3big:~/mysql$ docker pull mysql:5.6
Tunggu download selesai, kita dapat menemukan cermin lokal repositori dari daftar mysql, berlabel 5.6 gambar.
Mirroring menggunakan mysql
Jalankan wadah
w3big@w3big:~/mysql$ docker run -p 3306:3306 --name mymysql -v $PWD/conf/my.cnf:/etc/mysql/my.cnf -v $PWD/logs:/logs -v $PWD/data:/mysql_data -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6 21cb89213c93d805c5bacf1028a0da7b5c5852761ba81327e6b99bb3ea89930e w3big@w3big:~/mysql$
Perintah Deskripsi:
-p 3306: 3306: 3306 akan dipetakan ke port host pelabuhan kontainer di 3306
v $ PWD / conf / my.cnf: /etc/mysql/my.cnf: host conf / my.cnf di direktori saat dipasang ke /etc/mysql/my.cnf wadah
v $ PWD / log: / log : log directory akan menjadi tuan rumah direktori saat dipasang ke wadah / log
v $ PWD / Data: / mysql_data : direktori data master di bawah direktori saat dipasang ke wadah / mysql_data
-e MYSQL_ROOT_PASSWORD = 123456: inisialisasi password user root
Periksa wadah dimulai keadaan
w3big@w3big:~/mysql$ docker ps CONTAINER ID IMAGE COMMAND id. PORTS NAMES 21cb89213c93 mysql:5.6 "docker-entrypoint.sh" id. 0.0.0.0:3306->3306/tcp mymysql