<p dir="ltr">Personally I recommend webscale ;)<br>
But only if you know how to use make.<br>
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.<br>
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. <br>
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.<br>
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.</p>
<div class="gmail_quote">On Apr 8, 2014 4:12 PM, "Brian Cluff" <<a href="mailto:brian@snaptek.com">brian@snaptek.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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.<br>
<br>
Best of all, you aren't sitting around wondering what oracle is going to do with it next.<br>
<br>
Brian Cluff<br>
<br>
On 04/08/2014 01:26 PM, Paul Mooring wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Thanks for the info, I haven't been exposed to MariaDB yet but sounds<br>
like it's a good way to go at the moment. In any case I completely<br>
agree that InnoDB is the way to go.<br>
<br>
<br>
On Tue, Apr 8, 2014 at 12:54 PM, der.hans <<a href="mailto:PLUGd@lufthans.com" target="_blank">PLUGd@lufthans.com</a><br>
<mailto:<a href="mailto:PLUGd@lufthans.com" target="_blank">PLUGd@lufthans.com</a>>> wrote:<br>
<br>
Am 08. Apr, 2014 schwätzte Paul Mooring so:<br>
<br>
moin moin,<br>
<br>
<br>
I'm curious as to why you recommend MariaDB. I've used Percona<br>
pretty<br>
extensively for a while and it has worked well so far. I<br>
haven't heard<br>
anything about it going away or waning in popularity either. Is<br>
MariaDB a<br>
MySQL fork and if so why is it preferable?<br>
<br>
<br>
Both MariaDB and Percona are forks of MySQL. I recommended MariaDB<br>
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<br>
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<br>
conference<br>
was last week. Percona's backup tool is what I would recommend for<br>
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<br>
production<br>
environments.<br>
<br>
ciao,<br>
<br>
der.hans<br>
<br>
<br>
On Tue, Apr 8, 2014 at 12:25 PM, der.hans <<a href="mailto:PLUGd@lufthans.com" target="_blank">PLUGd@lufthans.com</a><br>
<mailto:<a href="mailto:PLUGd@lufthans.com" target="_blank">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<br>
you're not<br>
beating the heck out of the DB, then you're fine. If you are<br>
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<br>
don't know which<br>
release first had MariaDB or in which release MariaDB<br>
becomes the default.<br>
<br>
BTW, don't convert the internal mysql database to InnoDB,<br>
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<br>
tables are using<br>
<br>
the MyISAM data engine. I see the default as of<br>
version 5.5.5 is now<br>
InnoDB. The server is running a stock version of CentOS<br>
6.4 with MySql<br>
5.1.69. We stay with the standard CentOS upgrade and do<br>
not update Apache,<br>
MySql, or PHP to other versions.<br>
<br>
As I look around it seems the InnoDB data engine is such<br>
a better deal.<br>
I'm thinking it might take several years, maybe longer,<br>
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<br>
might be the way<br>
to go especially since we are about to make some major<br>
modifications to the<br>
app that uses this database.<br>
<br>
<br>
I have not read anything about any problems in using<br>
InnoDB with MySql<br>
version prior to 5.5.5.<br>
<br>
Is there anything I should be aware of or any potential<br>
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><br>
<a href="http://www.LuftHans.com/__Classes/" target="_blank">http://www.LuftHans.com/__<u></u>Classes/</a><br>
<<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.<br>
Today I was<br>
replaced<br>
# by a bobblehead doll!" -- Randy Glasbergen, 13Mar2006<br>
------------------------------<u></u>__---------------------<br>
PLUG-discuss mailing list -<br>
PLUG-discuss@lists.phxlinux.__<u></u>org<br>
<mailto:<a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.<u></u>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/__<u></u>mailman/listinfo/plug-discuss</a><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>
<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/__<u></u>Classes/</a><br>
<<a href="http://www.LuftHans.com/Classes/" target="_blank">http://www.LuftHans.com/<u></u>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>
<br>
<br>
<br>
--<br>
Paul Mooring<br>
Operations Engineer<br>
Chef<br>
<br>
<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>
------------------------------<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>
</blockquote></div>