<div dir="ltr">Hans,<div><br></div><div>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?</div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Apr 8, 2014 at 12:25 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 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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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.<br>
<br>
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. <br>
<br>
<br>
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.<br>
<br>
<br>
I have not read anything about any problems in using InnoDB with MySql version prior to 5.5.5.<br>
<br>
Is there anything I should be aware of or any potential problems in using InnoDB with MySql versions prior to 5.5.5?<br>
<br>
Thank you very much for all your help and insight!!<br>
<br>
Keith <span class="HOEnZb"><font color="#888888"><br>
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<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 replaced<br>
# by a bobblehead doll!" -- Randy Glasbergen, 13Mar2006</font></span><br>---------------------------------------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org">PLUG-discuss@lists.phxlinux.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/mailman/listinfo/plug-discuss</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">
Paul Mooring<div>Operations Engineer</div><div>Chef</div></div>
</div>