Can MS SQL and MySQL run simultaneously?

[Anon]

My host currently runs MS SQL on a server cluster. Could he install and run MySQL on the same server cluster without conflict?

He does not offer MySQL, but I have attempted talking him into it. This is his final question:

==========

Ok, one last question for mySQL - can it run simultaneously with Microsoft SQL server? The reason I ask is because we already have a cluster running for MS SQL - if the two can run together without conflicting, then we could just set it up there. Otherwise we'll need to order a new system for it, which can take a few days to get in and get it configured.

[brandonschnell]

should be able to without problems.

MS SQL defaults to port 1433 & mysql defaults to 3306

just specify a different directory for the mysql database.

MS SQL is a decent database and while the php libs for MS SQL aren't the best, they do work.

[[deleted]]

Small note: MySQL runs on windows, but it's far from ideal. And it is never a good idea to use one machine to run two 'big' tasks, especially not databases. If MS-SQL decides it needs to use the disk, MySQL has to wait, and vice-versa. All the disk-access optimizations go right out the window.

Advise your ISP to buy a seperate system, and install MySQL under Linux. (and while he is at it, forget mysql and install postgreSQL instead, that matches MS-SQL's functionality much better than mysql's flat-file-sql)