質問編集履歴

タイトルを変更

2018/10/31 08:06

投稿

rock_square

スコア14

test CHANGED Viewed

	@@ -1 +1 @@
1	- Docker~~のイメ~~ージ~~にパッケー~~ジを追加したい
1	+ DockerでMroongaストレージエンジンを持つMySQLを起動したい

test CHANGED Viewed

@@ -1,4 +1,4 @@
-###  Dockerのイメージにパッケージを追加したい。
+###  DockerでMroongaストレージエンジンを持つMySQLを起動したい
 ### 前提

「試したこと」の内容を編集しました。

2018/10/31 08:06

投稿

rock_square

スコア14

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -176,53 +176,245 @@
 ### 試したこと
-Mroongaのインストール方法（http://mroonga.org/ja/docs/install/ubuntu.html）を参考に、Dockerfileに追記してbuildしてみました。
+公式のMySQLイメージにMroongaをインストールするのではなく、mroonga/docker（https://github.com/mroonga/docker）を使用する方法で対応してみました。
+各ファイルを編集しました。
+Dockerfileやmy.cnf は
+https://github.com/mroonga/docker/blob/master/Dockerfile/mysql5723_mroonga807/Dockerfile
+の内容を参考に、内容を変更しました。
 ```Dockerfile
-FROM mysql:5.7
+FROM centos:centos6.9
+MAINTAINER groonga
-RUN apt-get update
+RUN yum upgrade -y
-RUN apt-get install -y -V software-properties-common lsb-release
-RUN add-apt-repository -y universe
+RUN yum install -y which
-RUN add-apt-repository "deb http://security.ubuntu.com/ubuntu $(lsb_release --short --codename)-security main restricted"
+RUN yum install -y http://packages.groonga.org/centos/groonga-release-1.4.0-1.noarch.rpm && yum clean all
+RUN yum install -y https://dev.mysql.com/get/mysql80-community-release-el6-1.noarch.rpm && yum clean all
+RUN yum install --enablerepo=mysql56-community --disablerepo=mysql57-community --disablerepo=mysql80-community -y mysql-community-client-5.6.41 mysql-community-server-5.6.41 && yum clean all
+RUN yum install -y mysql-community-mroonga-8.07 groonga-8.0.7 groonga-tokenizer-mecab-8.0.7 groonga-normalizer-mysql && yum clean all
+RUN chown -R mysql. /var/lib/mysql ; service mysqld start && mysql -e "GRANT ALL ON *.* TO root@'%' WITH GRANT OPTION" && mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql mysql && service mysqld stop
+COPY my.cnf /etc/my.cnf
+RUN rpm -q --scripts mysql-community-mroonga | sed -n '/^postinstall scriptlet/,/^[a-z][a-z]* scriptlet/p' | tail -n +2 | head -n -1 > /root/postinstall.sh
+RUN rm /var/lib/mysql/auto.cnf /var/lib/mysql/groonga.log
-RUN add-apt-repository -y ppa:groonga/ppa
+COPY entrypoint.sh /root/entrypoint.sh
-RUN apt-get update
-RUN apt-get install -y -V mysql-server-mroonga
 EXPOSE 3306
-ADD ./my.cnf /etc/mysql/conf.d/my.cnf
-RUN chmod 644 /etc/mysql/conf.d/my.cnf
-CMD ["mysqld"]
-```
-実行結果ですが
+ENTRYPOINT ["/root/entrypoint.sh"]
+```
+```myCnf
+# For advice on how to change settings please see
+# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
+[mysqld]
+#
+# Remove leading # and set to the amount of RAM for the most important data
+# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
+# innodb_buffer_pool_size = 128M
+#
+# Remove leading # to turn on a very important data integrity option: logging
+# changes to the binary log between backups.
+# log_bin
+#
+# Remove leading # to set options mainly useful for reporting servers.
+# The server defaults are faster for transactions and fast SELECTs.
+# Adjust sizes as needed, experiment to find the optimal values.
+# join_buffer_size = 128M
+# sort_buffer_size = 2M
+# read_rnd_buffer_size = 2M
+datadir=/var/lib/mysql
+socket=/var/lib/mysql/mysql.sock
+# Disabling symbolic-links is recommended to prevent assorted security risks
+symbolic-links=0
+# Recommended in standard MySQL setup
+sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
+### Added by yoku0825
+character_set_server= utf8mb4
+[mysqld_safe]
+log-error=/var/log/mysqld.log
+pid-file=/var/run/mysqld/mysqld.pid
+```
+```composeYml
+version: "3"
+services:
+  db:
+    build: ./mysql
+    ports:
+      - 3307:3306
+    environment:
+      MYSQL_ROOT_PASSWORD: root
+      TZ: Asia/Tokyo
+    volumes:
+      - ./mysql/mysql_data:/var/lib/mysql groonga/mroonga
+    container_name: "groonga"
+  phpmyadmin:
+    image: phpmyadmin/phpmyadmin:latest
+    links:
+      - db
+    ports:
+      - 8081:80
+    environment:
+      - PMA_ARBITRARY=1
+      - PMA_HOST=db
+    container_name: "phpmyamin-la"
+```
+また、Dockerfileとmy.cnfと同じディレクトリに、 entrypoint.sh を下記内容で配置しました。
+```entrypointSh
+#!/bin/bash
+if [ ! -e /var/lib/mysql/ibdata1 ] ; then
+  ### If overroded my.cnf is there, rename and restore it.
+  ### See https://github.com/mroonga/docker/issues/59
+  [[ -e /etc/my.cnf ]] && mv -n /etc/my.cnf /etc/my.cnf.save
+  chown -R mysql. /var/lib/mysql
+  bash /root/postinstall.sh
+  service mysqld start
+  mysql -e "GRANT ALL ON *.* TO root@'%' WITH GRANT OPTION"
+  mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql mysql
+  service mysqld stop
+  ### Restore my.cnf
+  [[ -e /etc/my.cnf.save ]] && mv /etc/my.cnf.save /etc/my.cnf
+fi
+oldowner=$(ls -ln /var/lib/mysql/ibdata1 | awk '{print $3}')
+oldgroup=$(ls -ln /var/lib/mysql/ibdata1 | awk '{print $4}')
+chown -R mysql. /var/lib/mysql
+/usr/sbin/mysqld --user=mysql "$@"
+chown -R $oldowner.$oldgroup /var/lib/mysql
+```
+上記の設定でbuildを行いました。
@@ -232,35 +424,25 @@
 Building db
-Step 1/12 : FROM mysql:5.7
+Step 1/15 : FROM centos:centos6.9
+centos6.9: Pulling from library/centos
+993c50d47469: Already exists
+Digest: sha256:48623f1cc1ff287ef4843888bcee22285066adf2d5da6daf000070bee83cd93a
+Status: Downloaded newer image for centos:centos6.9
- ---> 702fb0b7837f
+ ---> e88c611d16a0
-Step 2/12 : RUN apt-get update
+Step 2/15 : MAINTAINER groonga
- ---> Running in 14af51ff6717
+ ---> Running in 2bcced1f2a82
-Get:1 http://repo.mysql.com/apt/debian stretch InRelease [19.2 kB]
-Get:3 http://repo.mysql.com/apt/debian stretch/mysql-5.7 amd64 Packages [5675 B]
-Ign:2 http://cdn-fastly.deb.debian.org/debian stretch InRelease
-Get:4 http://cdn-fastly.deb.debian.org/debian stretch-updates InRelease [91.0 kB]
-Get:5 http://security.debian.org/debian-security stretch/updates InRelease [94.3 kB]
-Get:6 http://cdn-fastly.deb.debian.org/debian stretch Release [118 kB]
-Get:7 http://cdn-fastly.deb.debian.org/debian stretch-updates/main amd64 Packages [5152 B]
-Get:8 http://security.debian.org/debian-security stretch/updates/main amd64 Packages [454 kB]
-Get:9 http://cdn-fastly.deb.debian.org/debian stretch Release.gpg [2434 B]
-Get:10 http://cdn-fastly.deb.debian.org/debian stretch/main amd64 Packages [7099 kB]
-Fetched 7888 kB in 6s (1146 kB/s)
+Removing intermediate container 2bcced1f2a82
+ ---> 6a8b3793b27d
@@ -268,19 +450,75 @@
-Step 4/12 : RUN add-apt-repository -y universe
+Step 13/15 : COPY entrypoint.sh /root/entrypoint.sh
+ ---> 79b9820f0b6a
+Step 14/15 : EXPOSE 3306
+ ---> Running in 4dee21467386
+Removing intermediate container 4dee21467386
+ ---> 934e3e1567b0
+Step 15/15 : ENTRYPOINT ["/root/entrypoint.sh"]
- ---> Running in 5ae4c8bbe007
+ ---> Running in 5eb08b8d6109
+Removing intermediate container 5eb08b8d6109
+ ---> 1afe083dfee4
+Successfully built 1afe083dfee4
+Successfully tagged mysql_db:latest
-Error: 'universe' invalid
+phpmyadmin uses an image, skipping
-ERROR: Service 'db' failed to build: The command '/bin/sh -c add-apt-repository -y universe' returned a non-zero code: 1
-```
+```
+buildは通りました。
-上記でエラーとなってしまいます。
+コンテナを起動しました。
+```
+PS C:\Docker\Mysql> docker-compose up -d
+Starting groonga ... done
+Creating phpmyamin-la ... done
+```
+確認したところ
+```
+PS C:\Docker\Mysql> docker ps
+CONTAINER ID        IMAGE                          COMMAND                  CREATED             STATUS              PORTS                            NAMES
+9866db4e93cf        phpmyadmin/phpmyadmin:latest   "/run.sh supervisord…"   39 seconds ago      Up 35 seconds       9000/tcp, 0.0.0.0:8081->80/tcp   phpmyamin-la
+```
+PHP MyAdminのみコンテナが起動し、Mroongaは起動していませんでした。
+MySQLへの接続もできない状態でした。