在 Windows Server 2003 企业版上并行安装 SQL Server 2008 R2 和 MySQL 是否安全?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/4504060/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 18:04:31  来源:igfitidea点击:

Is it safe to install SQL Server 2008 R2 and MySQL side-by-side on Windows Server 2003 Enterprise Edition?

sqlmysqlsql-serverdatabaseinstallation

提问by Giffyguy

Are there any drawbacks to such a configuration?

这样的配置有什么缺点吗?

回答by darioo

These two databases are totally separate entities and you should have no problems running both of them on the same machine.

这两个数据库是完全独立的实体,在同一台机器上运行它们应该没有问题。

Short story: I wanted to test Hibernatewith various database dialects, so I ended up installing these databases on one machine:

小故事:我想用各种数据库方言测试Hibernate,所以我最终在一台机器上安装了这些数据库:

  • MS SQL server
  • MySQL
  • PostgreSQL
  • Oracle
  • DB2
  • MS SQL 服务器
  • MySQL
  • PostgreSQL
  • 甲骨文
  • 数据库2

and I had no problems with all of them running at once. Yes, it was a test server and the poor thing was totally running out of memory, but everything did work.

而且我对它们同时运行没有任何问题。是的,它是一个测试服务器,糟糕的是内存完全耗尽,但一切正常。

Only imaginable problem you could run into: configuring the same port for multiple databases. But you wouldn't do that, so it's not a problem.

您可能会遇到的唯一可以想象的问题:为多个数据库配置相同的端口。但你不会那样做,所以这不是问题。

回答by Andrew Barber

Aside from the resources they would both consume (memory, disk, cpu); barring any purposeful conflicting configuration (by default they will listen on different ports), it would work fine.

除了它们都会消耗的资源(内存、磁盘、CPU);除非有任何有目的的冲突配置(默认情况下,它们将侦听不同的端口),否则它会正常工作。

回答by Shoban

No as far as I know.. I use both MS SQL and MySQL for my websites in the same box and no issues so far (2 years now!)

据我所知没有......我在同一个盒子中为我的网站同时使用 MS SQL 和 MySQL,到目前为止没有问题(2 年了!)

回答by tenfour

I have never run into an issue; they really don't step on each others' configurations at all.

我从来没有遇到过问题;他们真的根本不踩对方的配置。