Re: InnoDB ( was: blank subject )

>>     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 <PLUGd@lufthans.com
>>         <mailto:PLUGd@lufthans.com>> 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/
>>             <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
>>             <mailto:PLUG-discuss@lists.phxlinux.org>
>>             To subscribe, unsubscribe, or to change your mail settings:
>>             http://lists.phxlinux.org/__mailman/listinfo/plug-discuss
>>             <http://lists.phxlinux.org/mailman/listinfo/plug-discuss>

>>     --
>>     # http://www.LuftHans.com/ http://www.LuftHans.com/__Classes/
>>     <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