Thank you everyone for all this great feedback!!! ------------------------ Keith Smith On Tuesday, April 8, 2014 12:56 PM, der.hans wrote: Am 08. Apr, 2014 schwätzte Paul Mooring so: moin moin, > 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? Both MariaDB and Percona are forks of MySQL. I recommended MariaDB because that's what RHEL and CentOS are moving to for the default version of MySQL. Any of the 3 branches can be a good choice depending on your requirements. In this case I took into account the stated distro as a requirement :). Also, it might be t hat his version of CentOS doesn't have a 5.5 release of MySQL, but does have a 5.5 release of MariaDB. Percona is doing quite well, as far as I know. The Percona Live conference was last week. Percona's backup tool is what I would recommend for InnoDB in any version if you aren't using snapshots. I've even submitted SCaLE talks on it :). In the last three years I've used all 3 branches in significant production environments. ciao, der.hans > 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 >> > > > > -- #  http://www.LuftHans.com/       http://www.LuftHans.com/Classes/ #  If you have an apple and I have an apple and we exchange apples then #  you and I will still each have one apple. But if you have an idea and #  I have an idea and we exchange these ideas, then each of us will have #  two ideas. -- George Bernard Shaw --------------------------------------------------- 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