Docker compose 配置airflow2.8 使用外置数据库

官方提供的docker file没办法自主配置 mysql & redis 地址

官方使用的docker compose 里面只支持postgrel 但是想换成自己的mysql

参考

配置参考

cloud.tencent.com/developer/a…

官方配置：

airflow.apache.org/docs/apache…

预制环境变量

linux operation

创建用户

sudo useradd -u 50000 airflow
sudo usermod -aG root airflow

创建挂载的文件

mkdir ~/data_volume/airflow
cd ~/data_volume/airflow
mkdir logs cols nfig dags plugins
sudo chown -R airflow:0 ~/data_volume/airflow

配置环境变量

 echo -e "AIRFLOW_PROJ_DIR=~/data_volume/airflow/\nAIRFLOW_UID=50000\n_PIP_ADDITIONAL_REQUIREMENTS=pymysql" > .env

Docker compose

2.1 Docker compose 配置修改了：

AIRFLOW__DATABASE__SQL_ALCHEMY_CONN: mysql+pymysql://airflow:123456@20.13.83.18:3306/airflow 
AIRFLOW__CELERY__RESULT_BACKEND: db+mysql://airflow:123456@20.13.83.18:3306/airflow 
AIRFLOW__CELERY__BROKER_URL: redis://:123456@20.13.83.18:6379/0

2.2 Service 配置安装额外的pymsql

entrypoint: ["/bin/bash", "-c", "/home/airflow/.local/bin/pip install pymysql && /usr/bin/dumb-init -- /entrypoint airflow webserver"]

init 安装 pymysql:

# Check if _PIP_ADDITIONAL_REQUIREMENTS is set and not empty
if [[ -n "${_PIP_ADDITIONAL_REQUIREMENTS}" ]]; then
    # Install additional requirements with pip
  python -m pip install --upgrade pip
  pip install ${_PIP_ADDITIONAL_REQUIREMENTS}
    # echo "test"
else
  echo "No additional pip requirements specified."
fi

2.4 airflow 关闭默认的examples AIRFLOW__CORE__LOAD_EXAMPLES: 'false'

2.5 执行创建容器 docker compose up airflow-init #初始化数据库，以及创建表 docker compose up -d #可以移除掉init 部分再创建airflow容器

docker compose down

Summary:

# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.
#

# Basic Airflow cluster configuration for CeleryExecutor with Redis and PostgreSQL.
#
# WARNING: This configuration is for local development. Do not use it in a production deployment.
#
# This configuration supports basic configuration using environment variables or an .env file
# The following variables are supported:
#
# AIRFLOW_IMAGE_NAME           - Docker image name used to run Airflow.
#                                Default: apache/airflow:2.8.0
# AIRFLOW_UID                  - User ID in Airflow containers
#                                Default: 50000
# AIRFLOW_PROJ_DIR             - Base path to which all the files will be volumed.
#                                Default: .
# Those configurations are useful mostly in case of standalone testing/running Airflow in test/try-out mode
#
# _AIRFLOW_WWW_USER_USERNAME   - Username for the administrator account (if requested).
#                                Default: airflow
# _AIRFLOW_WWW_USER_PASSWORD   - Password for the administrator account (if requested).
#                                Default: airflow
# _PIP_ADDITIONAL_REQUIREMENTS - Additional PIP requirements to add when starting all containers.
#                                Use this option ONLY for quick checks. Installing requirements at container
#                                startup is done EVERY TIME the service is started.
#                                A better way is to build a custom image or extend the official image
#                                as described in https://airflow.apache.org/docs/docker-stack/build.html.
#                                Default: ''
#
# Feel free to modify this file to suit your needs.
---
x-airflow-common:
  &airflow-common
  # In order to add custom dependencies or upgrade provider packages you can use your extended image.
  # Comment the image line, place your Dockerfile in the directory where you placed the docker-compose.yaml
  # and uncomment the "build" line below, Then run `docker-compose build` to build the images.
  image: ${AIRFLOW_IMAGE_NAME:-apache/airflow:2.8.0}
  # build: .
  environment:
    &airflow-common-env
    AIRFLOW__CORE__EXECUTOR: CeleryExecutor
    AIRFLOW__DATABASE__SQL_ALCHEMY_CONN: mysql+pymysql://airflow:123456@20.13.83.18:3306/airflow
    AIRFLOW__CELERY__RESULT_BACKEND: db+mysql://airflow:123456@20.13.83.18:3306/airflow
    AIRFLOW__CELERY__BROKER_URL: redis://:123456@20.13.83.18:6379/0
    AIRFLOW__CORE__FERNET_KEY: ''
    AIRFLOW__CORE__DAGS_ARE_PAUSED_AT_CREATION: 'true'
    AIRFLOW__CORE__LOAD_EXAMPLES: 'false'
    AIRFLOW__API__AUTH_BACKENDS: 'airflow.api.auth.backend.basic_auth,airflow.api.auth.backend.session'
    # yamllint disable rule:line-length
    # Use simple http server on scheduler for health checks
    # See https://airflow.apache.org/docs/apache-airflow/stable/administration-and-deployment/logging-monitoring/check-health.html#scheduler-health-check-server
    # yamllint enable rule:line-length
    AIRFLOW__SCHEDULER__ENABLE_HEALTH_CHECK: 'true'
    # WARNING: Use _PIP_ADDITIONAL_REQUIREMENTS option ONLY for a quick checks
    # for other purpose (development, test and especially production usage) build/extend Airflow image.
    _PIP_ADDITIONAL_REQUIREMENTS: ${_PIP_ADDITIONAL_REQUIREMENTS:-}
  volumes:
    - ${AIRFLOW_PROJ_DIR:-.}/dags:/opt/airflow/dags
    - ${AIRFLOW_PROJ_DIR:-.}/logs:/opt/airflow/logs
    - ${AIRFLOW_PROJ_DIR:-.}/:/opt/airflow/
    - ${AIRFLOW_PROJ_DIR:-.}/config:/opt/airflow/config
    - ${AIRFLOW_PROJ_DIR:-.}/plugins:/opt/airflow/plugins
  user: "${AIRFLOW_UID:-50000}:0"
  # depends_on:
    # &airflow-common-depends-on
  #   redis:
  #     condition: service_healthy
  #   postgres:
  #     condition: service_healthy

services:
  airflow-init:
    <<: *airflow-common
    entrypoint: /bin/bash
    # yamllint disable rule:line-length
    command:
      - -c
      - |
        # getent passwd | awk -F: '{print "User: " $1 ", UID: " $3 ", GID: " $4}'
        # getent group | awk -F: '{print "Group: " $1 ", GID: " $3}'
        echo $(whoami)
        if [[ -z "${AIRFLOW_UID}" ]]; then
          echo
          echo -e "\033[1;33mWARNING!!!: AIRFLOW_UID not set!\e[0m"
          echo "If you are on Linux, you SHOULD follow the instructions below to set "
          echo "AIRFLOW_UID environment variable, otherwise files will be owned by root."
          echo "For other operating systems you can get rid of the warning with manually created .env file:"
          echo "    See: https://airflow.apache.org/docs/apache-airflow/stable/howto/docker-compose/index.html#setting-the-right-airflow-user"
          echo
        fi
        one_meg=1048576
        mem_available=$$(($$(getconf _PHYS_PAGES) * $$(getconf PAGE_SIZE) / one_meg))
        cpus_available=$$(grep -cE 'cpu[0-9]+' /proc/stat)
        disk_available=$$(df / | tail -1 | awk '{print $$4}')
        warning_resources="false"
        if (( mem_available < 4000 )) ; then
          echo
          echo -e "\033[1;33mWARNING!!!: Not enough memory available for Docker.\e[0m"
          echo "At least 4GB of memory required. You have $$(numfmt --to iec $$((mem_available * one_meg)))"
          echo
          warning_resources="true"
        fi
        if (( cpus_available < 2 )); then
          echo
          echo -e "\033[1;33mWARNING!!!: Not enough CPUS available for Docker.\e[0m"
          echo "At least 2 CPUs recommended. You have $${cpus_available}"
          echo
          warning_resources="true"
        fi
        if (( disk_available < one_meg * 10 )); then
          echo
          echo -e "\033[1;33mWARNING!!!: Not enough Disk space available for Docker.\e[0m"
          echo "At least 10 GBs recommended. You have $$(numfmt --to iec $$((disk_available * 1024 )))"
          echo
          warning_resources="true"
        fi
        if [[ $${warning_resources} == "true" ]]; then
          echo
          echo -e "\033[1;33mWARNING!!!: You have not enough resources to run Airflow (see above)!\e[0m"
          echo "Please follow the instructions to increase amount of resources available:"
          echo "   https://airflow.apache.org/docs/apache-airflow/stable/howto/docker-compose/index.html#before-you-begin"
          echo
        fi
        # Check if _PIP_ADDITIONAL_REQUIREMENTS is set and not empty
        if [[ -n "${_PIP_ADDITIONAL_REQUIREMENTS}" ]]; then
            # Install additional requirements with pip
          python -m pip install --upgrade pip
          pip install ${_PIP_ADDITIONAL_REQUIREMENTS}
            # echo "test"
        else
          echo "No additional pip requirements specified."
        fi
        mkdir -p /sources/logs /sources/dags /sources/plugins
        chown -R "${AIRFLOW_UID}:0" /sources/{logs,dags,plugins}
        exec /entrypoint airflow version
    # yamllint enable rule:line-length
    environment:
      <<: *airflow-common-env
      _AIRFLOW_DB_MIGRATE: 'true'
      _AIRFLOW_WWW_USER_CREATE: 'true'
      _AIRFLOW_WWW_USER_USERNAME: ${_AIRFLOW_WWW_USER_USERNAME:-airflow}
      _AIRFLOW_WWW_USER_PASSWORD: ${_AIRFLOW_WWW_USER_PASSWORD:-airflow}
      _PIP_ADDITIONAL_REQUIREMENTS: ${_PIP_ADDITIONAL_REQUIREMENTS:-}
    user: "${AIRFLOW_UID:-50000}:0"
    volumes:
      - ${AIRFLOW_PROJ_DIR:-.}:/sources

  airflow-webserver:
    <<: *airflow-common
    entrypoint: ["/bin/bash", "-c", "/home/airflow/.local/bin/pip install pymysql && /usr/bin/dumb-init -- /entrypoint airflow webserver"]
    ports:
      - "8080:8080"
    healthcheck:
      test: ["CMD", "curl", "--fail", "http://localhost:8080/health"]
      interval: 30s
      timeout: 10s
      retries: 2
      start_period: 30s
    restart: always
    environment:
      <<: *airflow-common-env
    # depends_on:
      # <<: *airflow-common-depends-on
      # airflow-init:
      #   condition: service_completed_successfully

  airflow-scheduler:
    <<: *airflow-common
    entrypoint: ["/bin/bash", "-c", "/home/airflow/.local/bin/pip install pymysql && /usr/bin/dumb-init -- /entrypoint scheduler"]
    healthcheck:
      test: ["CMD", "curl", "--fail", "http://localhost:8974/health"]
      interval: 30s
      timeout: 10s
      retries: 5
      start_period: 30s
    restart: always
    # depends_on:
      # <<: *airflow-common-depends-on
      # airflow-init:
      #   condition: service_completed_successfully

  airflow-worker:
    <<: *airflow-common
    entrypoint: ["/bin/bash", "-c", "/home/airflow/.local/bin/pip install pymysql && /usr/bin/dumb-init -- /entrypoint celery worker"]
    healthcheck:
      # yamllint disable rule:line-length
      test:
        - "CMD-SHELL"
        - 'celery --app airflow.providers.celery.executors.celery_executor.app inspect ping -d "celery@$${HOSTNAME}" || celery --app airflow.executors.celery_executor.app inspect ping -d "celery@$${HOSTNAME}"'
      interval: 30s
      timeout: 10s
      retries: 5
      start_period: 30s
    environment:
      <<: *airflow-common-env
      # Required to handle warm shutdown of the celery workers properly
      # See https://airflow.apache.org/docs/docker-stack/entrypoint.html#signal-propagation
      DUMB_INIT_SETSID: "0"
    restart: always
    # depends_on:
      # <<: *airflow-common-depends-on
      # airflow-init:
      #   condition: service_completed_successfully

  airflow-triggerer:
    <<: *airflow-common
    entrypoint: ["/bin/bash", "-c", "/home/airflow/.local/bin/pip install pymysql && /usr/bin/dumb-init -- /entrypoint triggerer"]
    healthcheck:
      test: ["CMD-SHELL", 'airflow jobs check --job-type TriggererJob --hostname "$${HOSTNAME}"']
      interval: 30s
      timeout: 10s
      retries: 5
      start_period: 30s
    restart: always
    environment:
      <<: *airflow-common-env
    # depends_on:
      # <<: *airflow-common-depends-on
      # airflow-init:
      #   condition: service_completed_successfully

  airflow-cli:
    <<: *airflow-common
    profiles:
      - debug
    environment:
      <<: *airflow-common-env
      CONNECTION_CHECK_MAX_COUNT: "0"
    # Workaround for entrypoint issue. See: https://github.com/apache/airflow/issues/16252
    command:
      - bash
      - -c
      - airflow

  # You can enable flower by adding "--profile flower" option e.g. docker-compose --profile flower up
  # or by explicitly targeted on the command line e.g. docker-compose up flower.
  # See: https://docs.docker.com/compose/profiles/
  flower:
    <<: *airflow-common
    entrypoint: ["/bin/bash", "-c", "/home/airflow/.local/bin/pip install pymysql && /usr/bin/dumb-init -- /entrypoint celery flower"]
    profiles:
      - flower
    ports:
      - "5555:5555"
    healthcheck:
      test: ["CMD", "curl", "--fail", "http://localhost:5555/"]
      interval: 30s
      timeout: 10s
      retries: 5
      start_period: 30s
    restart: always
    environment:
      <<: *airflow-common-env
    # depends_on:
      # <<: *airflow-common-depends-on
      # airflow-init:
      #   condition: service_completed_successfully

Docker compose 配置airflow2.8 使用外置mysql

Docker compose 配置airflow2.8 使用外置数据库

参考

预制环境变量