<div dir="ltr">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.</div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Tue, Apr 8, 2014 at 12:54 PM, der.hans <span dir="ltr"><<a href="mailto:PLUGd@lufthans.com" target="_blank">PLUGd@lufthans.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Am 08. Apr, 2014 schwätzte Paul Mooring so:<br>
<br>
moin moin,<div class=""><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I'm curious as to why you recommend MariaDB. I've used Percona pretty<br>
extensively for a while and it has worked well so far. I haven't heard<br>
anything about it going away or waning in popularity either. Is MariaDB a<br>
MySQL fork and if so why is it preferable?<br>
</blockquote>
<br></div>
Both MariaDB and Percona are forks of MySQL. I recommended MariaDB because<br>
that's what RHEL and CentOS are moving to for the default version of<br>
MySQL.<br>
<br>
Any of the 3 branches can be a good choice depending on your requirements.<br>
In this case I took into account the stated distro as a requirement :).<br>
Also, it might be t hat his version of CentOS doesn't have a 5.5 release<br>
of MySQL, but does have a 5.5 release of MariaDB.<br>
<br>
Percona is doing quite well, as far as I know. The Percona Live conference<br>
was last week. Percona's backup tool is what I would recommend for InnoDB<br>
in any version if you aren't using snapshots. I've even submitted SCaLE<br>
talks on it :).<br>
<br>
In the last three years I've used all 3 branches in significant production<br>
environments.<br>
<br>
ciao,<br>
<br>
der.hans<div><div class="h5"><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Tue, Apr 8, 2014 at 12:25 PM, der.hans <<a href="mailto:PLUGd@lufthans.com" target="_blank">PLUGd@lufthans.com</a>> wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Am 08. Apr, 2014 schwätzte keith smith so:<br>
<br>
moin moin Keith,<br>
<br>
the short answer is: move to InnoDB :)<br>
<br>
InnoDB is much improved in 5.5, but it's fine in 5.1. If you're not<br>
beating the heck out of the DB, then you're fine. If you are beating the<br>
heck out of it, please bring in a DBA to help you out :).<br>
<br>
You'll probably need to change how you're doing backups.<br>
<br>
Does CentOS already have MariaDB? If so, move to that.<br>
<br>
RHEL is moving to MariaDB, so CentOS is as well. I just don't know which<br>
release first had MariaDB or in which release MariaDB becomes the default.<br>
<br>
BTW, don't convert the internal mysql database to InnoDB, just your<br>
application schemas.<br>
<br>
ciao,<br>
<br>
der.hans<br>
<br>
I have a MySql database that is about 10 years old. The tables are using<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
the MyISAM data engine. I see the default as of version 5.5.5 is now<br>
InnoDB. The server is running a stock version of CentOS 6.4 with MySql<br>
5.1.69. We stay with the standard CentOS upgrade and do not update Apache,<br>
MySql, or PHP to other versions.<br>
<br>
As I look around it seems the InnoDB data engine is such a better deal.<br>
I'm thinking it might take several years, maybe longer, to see MySql 5.5.5<br>
in the standard CentOS install.<br>
<br>
<br>
In the mean time I am thinking that a switch to InnoDB might be the way<br>
to go especially since we are about to make some major modifications to the<br>
app that uses this database.<br>
<br>
<br>
I have not read anything about any problems in using InnoDB with MySql<br>
version prior to 5.5.5.<br>
<br>
Is there anything I should be aware of or any potential problems in using<br>
InnoDB with MySql versions prior to 5.5.5?<br>
<br>
Thank you very much for all your help and insight!!<br>
<br>
Keith<br>
<br>
</blockquote>
<br>
--<br>
# <a href="http://www.LuftHans.com/" target="_blank">http://www.LuftHans.com/</a> <a href="http://www.LuftHans.com/Classes/" target="_blank">http://www.LuftHans.com/<u></u>Classes/</a><br>
# "I guess I should've agreed with my boss more often. Today I was<br>
replaced<br>
# by a bobblehead doll!" -- Randy Glasbergen, 13Mar2006<br>
------------------------------<u></u>---------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.<u></u>org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/<u></u>mailman/listinfo/plug-discuss</a><br>
<br>
</blockquote>
<br>
<br>
<br>
<br>
</blockquote>
<br>
-- <br>
# <a href="http://www.LuftHans.com/" target="_blank">http://www.LuftHans.com/</a> <a href="http://www.LuftHans.com/Classes/" target="_blank">http://www.LuftHans.com/<u></u>Classes/</a><br></div></div>
# If you have an apple and I have an apple and we exchange apples then<br>
# you and I will still each have one apple. But if you have an idea and<br>
# I have an idea and we exchange these ideas, then each of us will have<br>
# two ideas. -- George Bernard Shaw</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">Paul Mooring<div>Operations Engineer</div><div>Chef</div></div>
</div>