up vote 1 down vote favorite
share [g+] share [fb]

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

link|improve this question
88% accept rate
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
feedback

3 Answers

up vote 9 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 ].

link|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
feedback
up vote 1 down vote

No, it will work correctly.

link|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
feedback
up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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