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

[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



On Fri, Oct 17, 2014 at 11:48 AM, Galen Charlton <gmc at esilibrary.com> wrote:
> Hi,
>
> On Fri, Oct 17, 2014 at 7:32 AM, Stéphane Dudart <sdudart at adt.irisnet.be>
> wrote:
>>
>> 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:  gmc at esilibrary.com
> direct: +1 770-709-5581
> cell:   +1 404-984-4366
> 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

ysuarez at berklee.edu
617-747-2617