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