作者:94Wong_386 | 来源:互联网 | 2022-12-16 16:22
1> Bukharov Ser..:
变量SQL_INTERNAL_PORT
可能3307
有价值。您需要将其更改为3306
。
另外,您可以删除
expose:
- "${SQL_INTERNAL_PORT}"
线。Mysql已经公开了3306端口。
所有进入群集的应用程序都使用内部端口(在mysql情况下为3306)。外部端口(在部分端口中)仅用于外部字通信。
如果要拥有多个数据库,则需要更改docker-compose这样的内容:
version: '3'
services:
hackernews:
image: prismagraphql/prisma:1.8
restart: always
ports:
- "${CLIENT_PORT}:${INTERNAL_PORT}"
environment:
PRISMA_CONFIG: |
port: $INTERNAL_PORT
managementApiSecret: $PRISMA_MANAGEMENT_API_SECRET
databases:
default:
connector: mysql
host: mysql_first
port: 3306
user: root
password: $SQL_PASSWORD
migrations: true
second:
connector: mysql
host: mysql_second
port: 3306
user: root
password: $SQL_PASSWORD
migrations: true
mysql_first:
image: mysql:5.7
restart: always
environment:
MYSQL_ROOT_PASSWORD: $SQL_PASSWORD
ports:
- 3307:3306
volumes:
- ./custom/:/etc/mysql/conf.d/my.cnf
- mysql:/var/lib/mysql
mysql_second:
image: mysql:5.7
restart: always
environment:
ports:
- 3308:3306
MYSQL_ROOT_PASSWORD: $SQL_PASSWORD