Docker-compose检查mysql连接是否准备就绪-Docker-composecheckifmysqlconnectionisready

33  

version: "2.1"
services:
    api:
        build: .
        container_name: api
        ports:
            - "8080:8080"
        depends_on:
            db:
                condition: service_healthy
    db:
        container_name: db
        image: mysql
        ports:
            - "3306"
        environment:
            MYSQL_ALLOW_EMPTY_PASSWORD: "yes"
            MYSQL_USER: "user"
            MYSQL_PASSWORD: "password"
            MYSQL_DATABASE: "database"
        healthcheck:
            test: ["CMD", "mysqladmin" ,"ping", "-h", "localhost"]
            timeout: 20s
            retries: 10

The api container will not start until the db container is healthy (basically until mysqladmin is up and accepting connections.)

在db容器运行之前，api容器才会启动（基本上直到mysqladmin启动并接受连接。）

3  

If you can change the container to wait for mysql to be ready do it.

如果您可以更改容器以等待mysql准备就绪。

If you don't have the control of the container that you want to connect the database to, you can try to wait for the specific port.

如果您没有要将数据库连接到的容器的控件，则可以尝试等待特定端口。

For that purpose, I'm using a small script to wait for a specific port exposed by another container.

为此，我使用一个小脚本来等待另一个容器暴露的特定端口。

In this example, myserver will wait for port 3306 of mydb container to be reachable.

在此示例中，myserver将等待mydb容器的端口3306可访问。

# Your database
mydb:
  image: mysql
  ports:
    - "3306:3306"
  volumes:
    - yourDataDir:/var/lib/mysql

# Your server
myserver:
  image: myserver
  ports:
    - "....:...."
  entrypoint: ./wait-for-it.sh mydb:3306 -- ./yourEntryPoint.sh

You can find the script wait-for-it documentation here

您可以在此处找到脚本wait-for-it文档

2  

I modified the docker-compose.yml as per the following example and it worked.

我根据以下示例修改了docker-compose.yml并且它工作正常。

mysql:
        image: mysql:5.6
        ports:
          - "3306:3306"
        volumes:       
          # Preload files for data
          - ../schemaAndSeedData:/docker-entrypoint-initdb.d
        environment:
          MYSQL_ROOT_PASSWORD: rootPass
          MYSQL_DATABASE: DefaultDB
          MYSQL_USER: usr
          MYSQL_PASSWORD: usr
        healthcheck:
          test:  mysql --user=root --password=rootPass -e 'Design your own check script ' LastSchema

In my case ../schemaAndSeedData contains multiple schema and data seeding sql files. Design your own check script can be similar to following 'select * from LastSchema.LastDBInsert'.

在我的情况下../schemaAndSeedData包含多个模式和数据种子sql文件。设计自己的检查脚本可以类似于以下'select * from LastSchema.LastDBInsert'。

While web dependent container code was

而依赖于Web的容器代码是

depends_on:
      mysql:
        condition: service_healthy