mirror of
https://github.com/alchemy-fr/Phraseanet.git
synced 2025-10-07 01:54:27 +00:00
33 lines
2.1 KiB
YAML
33 lines
2.1 KiB
YAML
version: "3.9"
|
|
|
|
services:
|
|
|
|
db:
|
|
image: mysql:8.0.36-debian
|
|
# NOTE: use of "mysql_native_password" is not recommended: https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password
|
|
# (this is just an example, not intended to be a production configuration)
|
|
command: --default-authentication-plugin=mysql_native_password --max_allowed_packet=$MYSQL_MAX_ALLOWED_PACKET --max_connections=$MYSQL_MAX_CONNECTION --long_query_time=$MYSQL_LONG_QUERY_TIME --sql_mode="NO_ENGINE_SUBSTITUTION"
|
|
restart: on-failure
|
|
profiles: ["mysql8"]
|
|
entrypoint:
|
|
sh -c "
|
|
echo 'CREATE DATABASE IF NOT EXISTS ab_master CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;CREATE DATABASE IF NOT EXISTS db_databox1 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;CREATE DATABASE IF NOT EXISTS db_unitTest CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;CREATE DATABASE IF NOT EXISTS db_dataset1 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;CREATE DATABASE IF NOT EXISTS db_dataset2 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE USER `$PHRASEANET_DB_USER`@`%` IDENTIFIED BY \"$PHRASEANET_DB_PASSWORD\";GRANT ALL PRIVILEGES ON *.* to `$PHRASEANET_DB_USER`@`%`;' > /docker-entrypoint-initdb.d/init.sql;
|
|
chmod +x /usr/local/bin/docker-entrypoint.sh /docker-entrypoint-initdb.d/init.sql;
|
|
/usr/local/bin/docker-entrypoint.sh --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --default-authentication-plugin=mysql_native_password --max_allowed_packet=$MYSQL_MAX_ALLOWED_PACKET --max_connections=$MYSQL_MAX_CONNECTION --long_query_time=$MYSQL_LONG_QUERY_TIME --sql_mode="NO_ENGINE_SUBSTITUTION" --slow_query_log=$MYSQL_SLOW_QUERY_LOG
|
|
"
|
|
environment:
|
|
- MYSQL_ROOT_PASSWORD
|
|
- MYSQL_MAX_ALLOWED_PACKET
|
|
- MYSQL_MAX_CONNECTION
|
|
- MYSQL_LONG_QUERY_TIME
|
|
- MYSQL_SLOW_QUERY_LOG
|
|
- MYSQL_QUERY_CACHE_LIMIT
|
|
- MYSQL_QUERY_CACHE_SIZE
|
|
- MYSQL_KEY_BUFFER_SIZE
|
|
- MYSQL_CONNECT_TIMEOUT
|
|
- MYSQL_WAIT_TIMEOUT
|
|
volumes:
|
|
- ${PHRASEANET_DB_DIR}_mysql8:/var/lib/mysql:rw
|
|
networks:
|
|
- internal
|