Mysql and PostgeSql

high_density · 04-28-2011, 02:42 AM

Hello,
Noob question: can mysql and postgresql service possible to run at the same time in one centos 5.5 box? is there any conflict if it will run on on the same time?

omgs · 04-28-2011, 04:51 AM

Since mysql listens on port 3306 and postgres in port 5432, and they both perform different tasks (*different* SGBDs), there's no problem at all. Get rid of "windows nonsenses" about "conflicting different programs".

Tinkster · 04-28-2011, 07:30 PM

with omgs' comment in mind, there's always the potential problem
of resource contention, and performance, depending on how busy
either service is, and how much I/O load each generates. Generally
speaking there's no problem; w/ high concurrency or computationally
intense queries you may find the performance lacking.

Cheers,
Tink

high_density · 04-28-2011, 08:49 PM

Quote:

Originally Posted by Tinkster

with omgs' comment in mind, there's always the potential problem
of resource contention, and performance, depending on how busy
either service is, and how much I/O load each generates. Generally
speaking there's no problem; w/ high concurrency or computationally
intense queries you may find the performance lacking.

Cheers,
Tink

many thanks omgs and tinkster