[ensembl-dev] Ensembl MySQL Database Engine
annelyle at ebi.ac.uk
Tue Nov 7 09:59:33 GMT 2017
Just to add some context:
Historically we’ve been reliant on MyISAM for the website, because we need to copy a massive amount of data to our overseas mirrors and InnoDB does not make that efficient or easy. However technologies change, so as Alessandro says we are looking into it.
Ensembl Web Developer
> On 7 Nov 2017, at 09:53, Alessandro Vullo <avullo at ebi.ac.uk> wrote:
> Hi Chuck,
> yes, we're actually considering switching to InnoDB and are in the process of testing the migration to this engine. Unfortunately, we cannot anticipate when exactly the move will occur, it'll be some time next year.
> Hope that helps,
> On 06/11/17 21:01, Chuck Lynch wrote:
>> Hi Dev Team,
>> I’m working with a client in the Boston area that has run into some problems using the Ensembl MySQL MyISAM database Engine. Have you considered using the InnoDB engine for Ensembl? MyISAM is older technology and will likely be replaced by InnoDB in the future. It would save us a lot of time by obviating the need to convert to the InnoDB engine.
> Dev mailing list Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info: http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/
More information about the Dev