Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Are there any configuration or installation hazards to setup both Postgresql-8.4 and MySQL on the same server and running them side by side, other than performance?

The server is running Debian etch.

Thanks

share|improve this question
    
I've had MySQL and PostgreSQL running side by side on a test server for several years without a problem. As you say, though, performance may be an issue on a production server, depending on the workload. –  Bruce Alderman Jul 14 '09 at 14:52
add comment

3 Answers

up vote 10 down vote accepted

i do have similar configuration live. they [ mysql-server-5.0 and postgresql-8.3 [ not 8.4 as you ask ]] work fine together.

it's not like with smtp servers postfix vs exim - mysql and postgres do not replace each other from the system perspective. but obviously those two db engines will compete for system resources [ cpu, io ] if you are going to put high load on them [ but there is nothing wrong with it ].

share|improve this answer
    
Agreed. The only issue I expect that you would see is the two competing for CPU/memory resources. If you have enough CPU power and RAM to go around then all should be fine. –  David Spillett Jul 5 '09 at 2:52
add comment

No, it will work correctly.

share|improve this answer
    
Do you have a similar configuration currently live? –  Wadih M. Jul 4 '09 at 21:33
1  
Yes. You may also be interrested by wikivs.com/wiki/MySQL_vs_PostgreSQL –  radius Jul 4 '09 at 22:07
add comment

No should run OK - and you can even minimise performance issues if you have their data on separate physical drives and enough RAM/cores.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.