[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] Database versions and Storage Engines



Thanks Ian.


-----Original Message-----
From: eprints-tech-bounces at ecs.soton.ac.uk [mailto:eprints-tech-bounces at ecs.soton.ac.uk] On Behalf Of Ian Stuart
Sent: Monday, 9 May 2016 6:31 PM
To: eprints-tech at ecs.soton.ac.uk
Subject: Re: [EP-tech] Database versions and Storage Engines



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.


_____________________________________________________________
This email (including any attached files) is confidential and is for the intended recipient(s) only. If you received this email by mistake, please, as a courtesy, tell the sender, then delete this email.

The views and opinions are the originator's and do not necessarily reflect those of the University of Southern Queensland. Although all reasonable precautions were taken to ensure that this email contained no viruses at the time it was sent we accept no liability for any losses arising from its receipt.

The University of Southern Queensland is a registered provider of education with the Australian Government.
(CRICOS Institution Code QLD 00244B / NSW 02225M, TEQSA PRV12081 )