Re:Making MySQL Better at GitHub
by sjwright on Tuesday September 02, 2014 @05:57PM
(#8260417)
Our experience switching from Oracle's MySQL to MariaDB was a solid improvement in performance -- particularly on certain queries where MariaDB's superior query optimizations kick in.
We've also migrated many tables to TokuDB storage engine, and seen phenomenal improvements in performance and scaling. It's so good we were able to de-partition and de-archive our largest tables with no performance penalty.
If you haven't tried MariaDB yet, try it.
If your database is reasonably large (10GB+) and you haven't tried TokuDB yet, TRY IT.
We've also migrated many tables to TokuDB storage engine, and seen phenomenal improvements in performance and scaling. It's so good we were able to de-partition and de-archive our largest tables with no performance penalty.
If you haven't tried MariaDB yet, try it.
If your database is reasonably large (10GB+) and you haven't tried TokuDB yet, TRY IT.