Good books on databases are rare. So permit me to step out of my normal MySQL-centric role and review a new book that is very good and covers a lot of generic relational database territory while also teaching the basics of Oracle 11g. I would estimate that 10% of the book is 11g and the rest would be valuable to new DBAs of other database systems. Besides, seeing how other databases perform some tasks differently may spur you to improve your own.
OCA Oracle Database 11g: SQL Fundamentals I: A real-world Certification Guide
Author: Steve Reis
At yesterdays MySQL Tech Tour in Dallas, a gentleman asked how to not only partition data but also store the indexes on other disks as a way of reducing I/O contention on drives.That struck a chord with me and I was soon looking up the information in the MySQL manual.
After the recent update to pt-table-checksum, I’ve seen a few FAQs about it.
Q: is it still multi-threaded/parallel? A: No, that was a pile of bugs and complexity. If you need to run the tool in parallel to take advantage of powerful hardware, you can run several instances, say, one per database.
Q: what chunk size should I use? A: None, let the tool adjust itself dynamically.
Some administrative tasks can be simplified by using common_schema/QueryScript. I'm collecting a bunch of these for documentation. Here's one for example:
The DBA/developer has the task of retaining only top 3 most populated countries per continent. That is, she has to DELETE 4th, 5th, 6th, ... most populated counties in each continent.
It might surprise you to hear this, but I had no idea whether my talks would be accepted. The committee decided on that, and neither I nor anyone else at Percona is on the committee.
Percona is glad to announce our first Beta release of what will become Percona XtraBackup 2.0. We’re releasing this beta to encourage testing of our upcoming 2.0 release of Percona XtraBackup.
Since this is a beta release, you should not rely on it for production workloads – use the stable 1.6 series of Percona XtraBackup instead.
In this beta we’re proud to add:
This is a cross-post from my personal blog. Are you involved with an open-source project that’s interesting to MySQL users, such as Nginx, PHPMyAdmin, Drupal, Jenkins, PHP, and so on? Percona just published the application form for dot-org groups to have a free expo hall booth in the Percona Live MySQL Conference in April.