[OPEN-ILS-DEV] conflict between mysql and postgresql

[Stéphane Dudart]

Dear all,

I would like to install Evergreen on a PC on which I already use Mysql for other php applications. Does someone can tell me if it is possible to use the two database servers Mysql et Postgresql on the same machine without having conflicts ?

Thank your for your help.

Stéphane Dudart
Documentaliste
T. [phone]


[cid:***@01CFEA28.012F6B30]<http://www.adt-ato.irisnet.be/>

Agence de developpement territorial asbl
Agentschap voor territoriale ontwikkeling vzw
Rue Royale 2-4 Koningsstraat | B- 1000 Bruxelles - Brussel
www.adt-ato.irisnet.be<http://www.adt-ato.irisnet.be>
twitter.com/ADTATO_Bussels<https://twitter.com/ADTATO_Brussels>

Sauf habilitation contraire, le contenu de ce courriel est propre à son auteur et n'engage pas l'ADT. Il est exclusivement réservé aux destinataires indiqués. Voir www.adt.irisnet.be/fr/disclaimer<http://www.adt.irisnet.be/fr/disclaimer>
Tenzij andere machtiging gaat de inhoud van deze mail uit van zijn auteur en verbindt hij het ATO niet. Hij richt zich uitsluitend tot de gemelde bestemmelingen. Zie www.adt.irisnet.be/nl/disclaimer<http://www.adt.irisnet.be/nl/disclaimer>

[Galen Charlton]

Hi,

Post by Stéphane Dudart
I would like to install Evergreen on a PC on which I already use Mysql for
other php applications. Does someone can tell me if it is possible to use
the two database servers Mysql et Postgresql on the same machine without
having conflicts ?

Yes, it is possible to run both MySQL and PostgreSQL on the same server
without much trouble.

Regards,

Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email: ***@esilibrary.com
direct: [phone]
cell: [phone]
skype: gmcharlt
web: http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org

[Yamil Suarez]

Stéphane,

I am not as knowledgeable as Galen, but I wanted to give you some
simple advice. First of all like Galen said, Postgres and MySQL can
co-exist quite well because their data is by default stored on
different locations within the servers, and they both by default use
different network ports to communicate.

With that being said, you can often get better performance of Postgres
when you use a dedicated server for just Postgres (or just MySQL). So
go ahead and set it up that way with both running on the same server.
Though if you notices that Postgres or EG runs slow, one thing among
other fixes to consider if you need to improve performance is to set
up Postgres on its own server.

Good luck,
Yamil

Post by Galen Charlton
Hi,

Post by Stéphane Dudart
I would like to install Evergreen on a PC on which I already use Mysql for
other php applications. Does someone can tell me if it is possible to use
the two database servers Mysql et Postgresql on the same machine without
having conflicts ?

Yes, it is possible to run both MySQL and PostgreSQL on the same server
without much trouble.
Regards,
Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
direct: [phone]
cell: [phone]
skype: gmcharlt
web: http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org

--
--------------------------------

Yamil Suarez, MCS
Library System Administrator/Developer

Stan Getz Library
Berklee College of Music
1140 Boylston St
Boston, MA 02215

***@berklee.edu
617-747-2617

[Robert Heller]

Post by Galen Charlton
Hi,

Post by Stéphane Dudart
I would like to install Evergreen on a PC on which I already use Mysql for
other php applications. Does someone can tell me if it is possible to use
the two database servers Mysql et Postgresql on the same machine without
having conflicts ?

Yes, it is possible to run both MySQL and PostgreSQL on the same server
without much trouble.

Yes, I have both DB systems running on my CentOS 5 desktop and have been
running both together for many years. The two servers listen on different
ports/sockets and use separate database files, etc. I would imagine one could
also run Oracle at the same, but since I don't have an Oracle or really any
reason to run it, I don't know for sure.

It does help to have enough resources available (eg enough RAM, diskspace, CPU
cycles, etc.) for the databases to work well together. (MySQL is somewhat
MORE of a memory pig than PostgreSQL.)

Post by Galen Charlton
Regards,
Galen

[Galen Charlton]

Hi,

Post by Robert Heller
Yes, I have both DB systems running on my CentOS 5 desktop and have been
running both together for many years. The two servers listen on different
ports/sockets and use separate database files, etc. I would imagine one could
also run Oracle at the same, but since I don't have an Oracle or really any
reason to run it, I don't know for sure.

It can be done -- in the past, I've run a Debian box with all three.
The two tricky bits were installing Oracle and trying to avoid using
psql-isms in SQL*Plus (and vice versa).

Regards,

Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email: ***@esilibrary.com
direct: [phone]
cell: [phone]
skype: gmcharlt
web: http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org