我已经在我的系统上安装了SQL-Server 2008 r2,但是现在我也需要安装MYSQL。是否可以同时安装MYSQL和Server?在同一个系统上安装Server和MYSQL是否相互影响?
发布于 2015-05-05 07:12:15
是的这是可能的。但是,您必须确保它们侦听的端口是different.By默认端口,mysql使用端口3306,SQL-server使用端口1433,它们都是应用程序,就像其他应用程序一样。具有不同的进程,因此它们应该在同一台机器上运行,而不会发生任何冲突。在安装时,只需确保配置好端口,使它们不使用相同的端口,系统也应该检测到端口正在被另一个应用程序使用。
发布于 2019-08-06 20:16:43
您的问题的简单而清晰的答案是Docker,我创建了教程,其中MySQL、MSSQL、Oracle、PostgreSQL和MongoDB在3GB内存的单一CentOS系统中同时安装和运行,而不相互影响:
https://adhoctuts.com/run-mulitple-databases-in-single-machine-using-docker-vagrant/ https://www.youtube.com/watch?v=LeqkCoX28qg
下面是本教程中的docker-compose.yml文件的内容,但您也需要其他文件(所有文件都位于下面的git存储库:databases)。如果您只需要MySQL和MSSQL,只需从docker-compose.yml中删除其他服务,然后运行docker:
# link to tutorial: https://adhoctuts.com/run-mulitple-databases-in-single-machine-using-docker-vagrant/
version: "3.1"
networks:
docker-network:
services:
# https://hub.docker.com/_/mysql
mysql_persistance: # service name
image: mysql:8
container_name: mysql_p # container_name
command: --default-authentication-plugin=mysql_native_password
volumes:
- /docker/mysql/data:/var/lib/mysql # for data persistance
- /docker/mysql/conf:/etc/mysql/conf.d # put all the custom configuration files from host to container
environment:
- MYSQL_ROOT_PASSWORD=AdHocTuts2019@
ports:
- "3309:3306" # map host port to container port
networks:
- docker-network
#restart: on-failure
mysql_no_persistance:
image: mysql:5.7
container_name: mysql_np
environment:
- MYSQL_ROOT_PASSWORD=AdHocTuts2019@
ports:
- "3308:3306"
networks:
- docker-network
# https://hub.docker.com/_/microsoft-mssql-server
mssql:
image: mcr.microsoft.com/mssql/server:2017-CU8-ubuntu
container_name: mssql
volumes:
- /docker/mssql/data:/var/opt/mssql
environment:
- SA_PASSWORD=AdHocTuts2019@
- ACCEPT_EULA=Y
- TZ=Asia/Baku
- MSSQL_PID=Express
ports:
- "1433:1433"
networks:
- docker-network
# https://hub.docker.com/_/oracle-database-enterprise-edition
# Accept Terms of Service for Oracle Database Enterprise Edition (Proceed to Checkout).
# Then in command line: docker login
# sqlplus sys/Oradoc_db1@ORCLDB as sysdba
oracle:
image: store/oracle/database-enterprise:12.2.0.1-slim
container_name: oracle
volumes:
- /docker/oracle/data:/ORCL # host path must have 777 permission or writable by docker oracle user
environment:
- DB_SID=ORCLDB
- DB_MEMORY=1GB
ports:
- "1521:1521"
networks:
- docker-network
# https://hub.docker.com/_/postgres
postgres:
image: postgres:12
container_name: postgres
volumes:
- /docker/postgre/data:/var/lib/postgresql/data
environment:
- POSTGRES_PASSWORD=AdHocTuts2019@
- POSTGRES_USER=postgres
- POSTGRES_DB=docker_db
ports:
- "5432:5432"
networks:
- docker-network
# https://hub.docker.com/_/mongo
mongo:
image: mongo:3.4.21-xenial
container_name: mongo
volumes:
- /docker/mongo/data:/data/db
environment:
- MONGO_INITDB_ROOT_USERNAME=root
- MONGO_INITDB_ROOT_PASSWORD=AdHocTuts2019@
ports:
- "27017:27017"
networks:
- docker-networkhttps://stackoverflow.com/questions/30045396
复制相似问题