Oracle and MySql on sameserver

[Billyt]

Just a very quick question to you guys in the know.

Is it possible to have an oracle database instance and a MySql database instance running on the same server? At the moment we have 2 servers each servering one of the databases. We are looking at providing one new server to collaborate both databases upon. The MySql database server is used be approx 30 users and the Oracle database is used by 5 users. The use of the relevant databases are mandated by the applications they server.

I would be very interested to hear your views ot concerns.

Regards,

Billy.

 

[alvechurchdata]

I don't know about Oracle but I've got SQL Server, MySQL, and SQLAnywhere all running on my laptop. I use them during training courses so I cannot say just how well they'd perform with a real load.

My only concern is to wonder why you're putting them both on the same server? I'd move the 30-user system to the new server and leave the smaller Oracle system on the old server. If you put them both on the same server then whenever you meet any sort of problem you will always have a little doubt at the back of your mind. It might be something as simple as "Is MySQL running slow because Oracle's doing some disk-intensive reindexing?" but it will always be something you have to take into consideration.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Billyt]

The only reason why we are putting the 2 instances on the same server is to save the customer money. They don't want to pay for support for 2 servers when they can get away with one. I don't think that performance is an issue because we are replacing the existing servers which are about 8 years old now with a new server which is far superior in terms on CPU and memory.

I am just trying to get a feel of what peoples thoughts are really or if it has been done elsewhere

 

[alvechurchdata]

The only reason why we are putting the 2 instances on the same server is to save the customer money

You have my sympathy - two servers would be so much simpler and the customer would have some backup. I suppose it's the support costs that are the killer. Servers don't cost that much these days.

Geoff Franklin

http://www.alvechurchdata.co.uk