在 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
Is it safe to install SQL Server 2008 R2 and MySQL side-by-side on Windows Server 2003 Enterprise Edition?
提问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.
我从来没有遇到过问题;他们真的根本不踩对方的配置。