<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt">Thank you everyone for all this great feedback!!!<br><br><div>------------------------<br>Keith Smith</div><div style="display: block;" class="yahoo_quoted"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> On Tuesday, April 8, 2014 12:56 PM, der.hans <PLUGd@LuftHans.com> wrote:<br> </font> </div> <div class="y_msg_container">Am 08. Apr, 2014 schwätzte Paul Mooring so:<br><br>moin moin,<br><br>> 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><br>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<br><br>> On Tue, Apr 8, 2014 at 12:25 PM, der.hans <<a ymailto="mailto:PLUGd@lufthans.com" href="mailto:PLUGd@lufthans.com">PLUGd@lufthans.com</a>> wrote:<br>><br>>> 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>>>> 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>>><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/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>>> ---------------------------------------------------<br>>> PLUG-discuss mailing list - <a ymailto="mailto:PLUG-discuss@lists.phxlinux.org" 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>>><br>><br>><br>><br>><br><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/Classes/</a><br># 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<br>---------------------------------------------------<br>PLUG-discuss mailing list - <a ymailto="mailto:PLUG-discuss@lists.phxlinux.org" 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><br></div> </div> </div> </div> </div></body></html>