Я всегда использую СУБД в докере. Очень удобно использовать конфиги для docker compose
Вот, конфиги, чтобы быстро поднять БД + панель управления.
PostgreSQL + PgAdmin
version: '3.8'
services:
postgres:
container_name: postgres
image: postgres
restart: always
environment:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: postgres
PGDATA: /data/postgres
ports:
- "5432:5432"
volumes:
- postgres:/data/postgres
pgadmin:
depends_on:
- postgres
container_name: pgadmin4
image: dpage/pgadmin4
restart: always
environment:
PGADMIN_DEFAULT_EMAIL: mail@example.com
PGADMIN_DEFAULT_PASSWORD: postgres
ports:
- "5050:80"
volumes:
- pgadmin:/root/.pgadmin
networks:
postgres:
driver: bridge
volumes:
postgres:
pgadmin:
Mysql + PhpMyAdmin
version: '3.8'
services:
mysql:
image: mysql:latest
container_name: mysql
restart: always
ports:
- '3306:3306'
environment:
MYSQL_ROOT_PASSWORD: mysql
phpmyadmin:
depends_on:
- mysql
image: phpmyadmin/phpmyadmin
container_name: phpmyadmin
restart: always
ports:
- '5051:80'
environment:
- PMA_HOST=mysql
- UPLOAD_LIMIT=1024M
- MEMORY_LIMIT=1024M
- MAX_EXECUTION_TIME=300version: '3.8'
services:
mysql:
image: mysql:latest
container_name: mysql
restart: always
ports:
- '3306:3306'
environment:
MYSQL_ROOT_PASSWORD: mysql
phpmyadmin:
depends_on:
- mysql
image: phpmyadmin/phpmyadmin
container_name: phpmyadmin
restart: always
ports:
- '5051:80'
environment:
- PMA_HOST=mysql
- UPLOAD_LIMIT=1024M
- MEMORY_LIMIT=1024M
- MAX_EXECUTION_TIME=300
MariaDB + PhpMyAdmin
version: '3.8'
services:
mariadb:
image: mariadb:latest
container_name: mariadb
restart: always
ports:
- '3306:3306'
environment:
MYSQL_ROOT_PASSWORD: mariadb
phpmyadmin:
depends_on:
- mariadb
image: phpmyadmin/phpmyadmin
container_name: phpmyadmin
restart: always
ports:
- '5051:80'
environment:
- PMA_HOST=mariadb
- UPLOAD_LIMIT=1024Mversion: '3.8'
services:
mariadb:
image: mariadb:latest
container_name: mariadb
restart: always
ports:
- '3306:3306'
environment:
MYSQL_ROOT_PASSWORD: mariadb
phpmyadmin:
depends_on:
- mariadb
image: phpmyadmin/phpmyadmin
container_name: phpmyadmin
restart: always
ports:
- '5051:80'
environment:
- PMA_HOST=mariadb
- UPLOAD_LIMIT=1024M
- MEMORY_LIMIT=1024M
- MAX_EXECUTION_TIME=300
- MEMORY_LIMIT=1024M
- MAX_EXECUTION_TIME=300