Hans, I'm curious as to why you recommend MariaDB. I've used Percona pretty extensively for a while and it has worked well so far. I haven't heard anything about it going away or waning in popularity either. Is MariaDB a MySQL fork and if so why is it preferable? On Tue, Apr 8, 2014 at 12:25 PM, der.hans wrote: > Am 08. Apr, 2014 schwätzte keith smith so: > > moin moin Keith, > > the short answer is: move to InnoDB :) > > InnoDB is much improved in 5.5, but it's fine in 5.1. If you're not > beating the heck out of the DB, then you're fine. If you are beating the > heck out of it, please bring in a DBA to help you out :). > > You'll probably need to change how you're doing backups. > > Does CentOS already have MariaDB? If so, move to that. > > RHEL is moving to MariaDB, so CentOS is as well. I just don't know which > release first had MariaDB or in which release MariaDB becomes the default. > > BTW, don't convert the internal mysql database to InnoDB, just your > application schemas. > > ciao, > > der.hans > > I have a MySql database that is about 10 years old. The tables are using >> the MyISAM data engine. I see the default as of version 5.5.5 is now >> InnoDB. The server is running a stock version of CentOS 6.4 with MySql >> 5.1.69. We stay with the standard CentOS upgrade and do not update Apache, >> MySql, or PHP to other versions. >> >> As I look around it seems the InnoDB data engine is such a better deal. >> I'm thinking it might take several years, maybe longer, to see MySql 5.5.5 >> in the standard CentOS install. >> >> >> In the mean time I am thinking that a switch to InnoDB might be the way >> to go especially since we are about to make some major modifications to the >> app that uses this database. >> >> >> I have not read anything about any problems in using InnoDB with MySql >> version prior to 5.5.5. >> >> Is there anything I should be aware of or any potential problems in using >> InnoDB with MySql versions prior to 5.5.5? >> >> Thank you very much for all your help and insight!! >> >> Keith >> > > -- > # http://www.LuftHans.com/ http://www.LuftHans.com/Classes/ > # "I guess I should've agreed with my boss more often. Today I was > replaced > # by a bobblehead doll!" -- Randy Glasbergen, 13Mar2006 > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org > To subscribe, unsubscribe, or to change your mail settings: > http://lists.phxlinux.org/mailman/listinfo/plug-discuss > -- Paul Mooring Operations Engineer Chef