MS SQL Server and MySQL coexisting?

[gtaylor]

Hi there,

The existing configuration is as follows:

Server 2003,
IIS,
SQL Server 2000.

Basically it's for a client, but our project runs on MySQL, so, I need to know if MySQL can coexist on the same machine as MS SQL Server 2000? Are there any special considerations given this scenario?

Thanks in advance,

Graeme

[rmiao]

Yes, they can if the server has enough horsepower. But your server has sql and iis already.

[gtaylor]

Yes, they can if the server has enough horsepower. But your server has sql and iis already.

Thanks for your reply. The thing is that it's going on a clients system (that's the one described above). They have their own intanet applications running on IIS and SQL Server, and we can't interfere with them. Our app runs on PHP and MySQL and so we'll need to get those on their system in parallel with SQL Server 2000 so that both sites can run fine, theirs with SQL server 2000 and ours with MySQL.

Are there any considerations with installing PHP and MySQL on such a system?

[MAK]

I usually separate Webserver, Application server and the database server.

Keep the RDBMS and the IIS and APP on the same server only if the databases that reside on that server is dedicated to that application.

For many APP and IIS patch/hotfix/sps you have to restart the machine. If you keep the databases of different apps on this server, all the apps gets affected.