News for hackers. Stuff that matters.
Re:RIP Open Source MySQL by falcolas on Saturday August 18, 2012 @12:35PM (#4401522)
FWIW, in addition to MariaDB, there is Percona Server as well, and they are also maintaining a launchpad for the base MySQL code on Launchpad while Oracle neglects that codebase.

http://www.mysqlperformanceblog.com/2012/08/16/where-to-get-...

Re:RIP Open Source MySQL by caseyf on Saturday August 18, 2012 @12:51PM (#4401572)
I highly recommend Percona Server. especially if you are using SSDs or a mix of SSDs and regular disks.
Re:RIP Open Source MySQL by __Joker on Saturday August 18, 2012 @03:55PM (#4402121)
Can you elaborate ?
Re:RIP Open Source MySQL by caseyf on Sunday August 19, 2012 @12:00AM (#4403161)
Percona Server has lots of improvements (some small things and others that are pretty essential for me) On the SSD front, the main ones are:

* You can put the innodb doublewrite buffer on your spinning disks - that's the best place for it since it's heavy sequential writes. See section 2.2.2 here http://yoshinorimatsunobu.blogspot.com/2009/05/tables-on-ssd...

* The ability to tune various parts of innodb that were originally designed to perform well on regular disks - those with fast sequential access, slower random access, and no real wear considerations. See http://www.percona.com/doc/percona-server/5.1/scalability/in...

Here's a recent post from Percona showing MySQL vs Percona server on an Intel 320 SSD: http://www.mysqlperformanceblog.com/2012/02/23/percona-serve...

--

MariaDB is pretty nice too. Their team has introduced some sorely needed query optimizations (http://kb.askmonty.org/en/what-is-mariadb-53/#subquery-optim...) and it does include Percona's XtraDB.

I haven't looked at MariaDB 5.5 to see how it compares to Percona Server 5.5. I put Percona Server into production last fall and MariaDB was still at 5.3 at the time.

Re:RIP Open Source MySQL by heretohelp on Saturday August 18, 2012 @04:58PM (#4402292)
Percona has done a lot of work to enable MySQL to take advantage of SSDs, work that hasn't percolated into mainline or MariaDB.
Re:RIP Open Source MySQL by latimer on Saturday August 18, 2012 @10:42PM (#4403046)
I've benchmarked all three and it seemed like the vast majority of the performance improvement on SSDs was due to the XtraDB engine which is included with MariaDB.
Re:RIP Open Source MySQL by heretohelp on Saturday August 18, 2012 @10:52PM (#4403067)
Re:RIP Open Source MySQL by latimer on Sunday August 19, 2012 @02:21AM (#4403375)
Yes you have to install it separately for MySQL but it's enabled by default in MariaDB so their work has in fact made it into MariaDB.