Both Oracle MySQL version 5.5.36 and MariaDB version 5.5.36 are out… but which is faster? As always, the only true decider is the benchmark! So both flavours promise the best that MySQL 5.5 has to offer, but which is truly faster and by how much?
Ever wondered how to run MariaDB and MySQL alongside flawlessly? Read this blog article to find out more…
After having gone through a Percona training presentation I’ve put some notes together noting some of the more crucial and useful points for myself.
Some are trivial points that I’ve just noted for the sake of reference, others are interesting tricks and snags we should all be aware of. Ultimately, these are all must know facts for any and all MySQL DBAs regardless of the MySQL flavour.
Trying to add that missing piece of functionality to your MySQL instance again and feel you don’t have all the information you need?
Well here’s a nice surprise from the developers at Oracle – the recently updated MySQL Internals Manual, now reaching revision 151. Best of all it has come just in time for the holiday season “reading time” period, having being updated on the 24th of December 2013.
The document is readily and freely available at the following url: http://dev.mysql.com/doc/internals/en/index.html
And if you don’t feel motivated enough to even page through the manual I will mention a few famous words by a freedom fighter we all revere: “Software patents are dangerous to software developers because they impose monopolies on software ideas” – Richard Stallman
Over the years I’ve seen a couple of interesting sharding solutions for the shared-nothing storage MySQL architecture, I can honestly say that none were ever worth writing home about. Scalebase provide a fairly robust looking solution however at a very high cost – and the cost of scaling your database shouldn’t have to be astronomical, especially when the database is open-source.
Heres a quick how to guide on setting up a Puppet Master and Agents for streamlined server management. First off you’ll have to configure each of your puppet agent nodes (i.e. clients).
Ok – heres a few easy steps to setup a MariaDB Galera Cluster using RSYNC for SST on Debian boxes. The Debian boxes were installed using ISO 1 of the Wheezy Release (7.0.0) and do not include a desktop environment.