Personally I recommend webscale ;)
But only if you know how to use make.
Maria and Percona are both drop in replacements to stock mysql ... And for each other ... Unless you use them at scale. Then you will find different edge casses in each.
I should note that centos is considered adding percona as a default in addition to Maria. They are all mysql based. And all have the percona xtradb engine in place of the stock innodb engine.
As for innodb vs myisam.... You are gaining row based locking, transactions, crash recovery, huge performance gains for point selects (if you have the hardware for it), etc, etc.
You give up a number of things, but you get most of them back in 5.6. Like full text indexes and geospatial. Unless you have a strong reason not to use innodb then you should use it.
Maria is nice! It's a complete drop in replacement for mysql. When we switched to it from mysql there was a noticeable speed increase. That alone made it worth using, but it's also got some capabilities that aren't in mysql itself.
Best of all, you aren't sitting around wondering what oracle is going to do with it next.
Brian Cluff
On 04/08/2014 01:26 PM, Paul Mooring wrote:
Thanks for the info, I haven't been exposed to MariaDB yet but sounds---------------------------------------------------
like it's a good way to go at the moment. In any case I completely
agree that InnoDB is the way to go.
On Tue, Apr 8, 2014 at 12:54 PM, der.hans <PLUGd@lufthans.com
<mailto:PLUGd@lufthans.com>> 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 <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
--
Paul Mooring
Operations Engineer
Chef
---------------------------------------------------
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
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