Ben Forta, the author of MySQL Crash Course and Sams Teach Yourself SQL in 10 Minutes, has written what I believe is the first MariaDB-specific book: MariaDB Crash Course. I just received word from Ben that the book is now shipping.
It has arrived, a little over a month from the last beta release, is MariaDB 5.3.1. It is a bug-fix update and as always the changelog lists everything that has been fixed. The release notes list all the changes present in the 5.3-series.
If you run a replicated MySQL setup and have a master failure, you may see the following error in your error log.
[ERROR] Error reading packet from server: Client requested master to start replication from impossible position ( server_errno=1236)
At this point your slave will not be replicating and you will need to recover from the situation. But why did it occur in the first place and what does it mean to your data integrity?
We have seen a few instances where upgrades of MySQL 5.1 to 5.5 have resulted in poor performance when using default values. After investigation it would appear that the main culprit appears to be the innodb_thread_concurrency setting.
Posted recently on the maria-developers mailing list, by Igor Babaev, Principal MariaDB developer at Monty Program is some interesting preliminary results for MariaDB 5.3.0 benchmarked against the DBT-3 benchmarking program.
DBT-3 is a benchmark to test a decision support workload, with a suite of business-oriented queries and concurrent data modifications.
As the dog days of summer set in and temperatures rise, this year’s O’Reilly OSCON conference in Portland, OR offered the open source community a brief respite from the heat. However, if you’re thinking the event lacked sizzle, think again. The energy, the discussions and the opportunities to collaborate, plus the chance to learn from/ interact with customers and potential customers, made OSCON one of the highlights of July.
Today at OSCON, SkySQL will introduce the SkySQL™ Recovery Manager. Powered by Zmanda, the SkySQL™ Recovery Manager is the most advanced backup and recovery solution for the MySQL® database. SkySQL’s solution makes life easier for any database administrator in need of a robust, yet flexible and easy to use backup and recovery manager.
If you're on openSUSE, you definitely want to upgrade to the latest MariaDB release made on 19/07/2011. Previous security fix disabled XtraDB! This is MariaDB 5.1.55.
If you're using Gentoo, please test MariaDB 5.2 ebuilds in the MySQL overlay. Its current with MariaDB 5.2.7 as well as MariaDB 5.1.55.
The primary objective of this release was to radically improve performance for subqueries, as well as for joins and single-table queries over large data sets. The MariaDB 5.3 release is based on MariaDB 5.2 (and therefor, MariaDB 5.1 & MySQL 5.1).
Noteworthy improvements in this release include: