[EP-tech] Database versions and Storage Engines

[Ian Stuart]

On 06/05/16 02:36, Matthew Brady wrote:
> Hi All,
>
> Just wondering if there are any pros/cons for moving the tables from the
> default MyISAM to InnoDB.
>
> The DBA’s are wanting to upgrade MySQL to a newer version, and asked if
> swapping engines could also be performed.
>
> Is there any reasons I shouldn’t move away from the MyISAM engine??

I've run EPrints against PostgreSQL for close on 10 years.

The only "problems" I've come across are
1) that the *install* requires mysql (and you change to Pg after the 
install), and
2) I need to upgrade to Pg 9.3 to get live replication across multiple 
databases

-- 

Ian Stuart.
Developer: ORI, RJ-Broker, and OpenDepot.org
Bibliographics and Multimedia Service Delivery team,
EDINA,
The University of Edinburgh.

http://edina.ac.uk/

This email was sent via the University of Edinburgh.

The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.