We all know that MySQL says it is "the world's most popular open-source database". And PostgreSQL has a firm hold on second place while claiming to be, instead, "the world's most advanced open source database". But the horse that comes in third can return some money to gamblers who bet "to show". And the horse that shows momentum or gets close is worth watching for next time.

So I'll just ignore the dolphin and the elephant in the room, and go on to a harder question: who's number three?

According to Wikipedia

To find out how many times someone has expressed interest in a topic, I can go to stats.grok.se and ask how many times someone has looked at that topic's page in Wikipedia. Evil-thinking people could manipulate these numbers with ease, but until now they have …

It will be a busy Fall season for the staff at PalominoDB as we will be sponsoring and speaking at two major international conferences.

First up is the MYSQL NOSQL & Cloud Expo in Buenos Aires, Argentina, OCT 15-16 2013. PalominoDB CTO Jay Edwards & DBA Emanuel Calvo will be featured speakers at this 2nd annual conference dedicated to building communities in Latin America.

Next is the AIOUG-SANGAM 13 in Hyderabad India, Nov 8-9, 2013.
PalominoDB CTO Jay Edwards and VP of International Operations Shiv Iyer, will be representing PalominoDB as a Silver Sponosor at one of the largest events in India.

• …

GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status. Excellent free tools for this include Cacti, Zabbix, Ganglia, Nagios, etc. But each of them needs to be properly configured to provide details on what is going on in our MySQL instances. And setting up one of these monitoring solutions is neither quick nor trivial (well, maybe with the exception of Ganglia).

MySQL Workbench provides …

A week ago we launched our first GA release of Percona Server 5.6 and it’s a real game-changer for us. The release of Percona Server 5.6 (our enhanced, drop-in replacement for MySQL) not only provides stability and performance but also provides key features only available in Oracle’s MySQL 5.6 Enterprise Edition. As usual, Percona Server 5.6 is 100 percent Free and Open Source Software.

On Oct. 16 I’ll lead a webinar that will present what’s new in Percona Server 5.6 that makes it the most powerful, highest performance, and most manageable free version of MySQL available today. The one-hour webinar starts at 1 p.m. Pacific time Wednesday. You can register here. …

MySQL Server 5.6 has seen fast adoption - the list of performance improvements and features make a convincing argument all on their own.

Join those adopting the MySQL database by taking the MySQL for Database Administrators training course.

This 5-day course teaches you all the core dba skills including what MySQL Server 5.6 brings you in terms of Replication. You will learn about:

• Managing the MySQL Binary Log
• MySQL replication threads and files
• Using MySQL Utilities for Replication
• Designing Complex Replication Topologies
• Multi-Master and Circular Replication
…

MySQL is one of the most famous Open Source Relational Database Management System (RDBMS) created by Michael Widenius. Default choice in systems as WordPress and used by top companies as Google and Wikipedia. Due its simplicity and large community, it is largely used by developers and webmasters around the world. MySQL is under dual license: […]

#DBHangOps 10/16/13 -- Resource Management, Compliance, and more

This weeks #DBHangOps is a wrap. Check out the recording below:

Hello everyone!

This Wednesday, October 16th, 2013 at 12:00pm pacific (19:00 GMT), #DBHangOps is coming up with discussion on:

• How do you constrain over-consumption of resources by competing applications?

• Network vs. Local storage for MySQL

  • How do you use this for HA? Do you use DRBD or floating VIPs?

• Secure connections to MySQL (using SSL) (requested by Daniel)

  • Do you have experience with this? What's the performance impact?
• PCI Certification with MySQL -- what changed for you?

• MySQL-isms!

  • (From Gerry) Sub SELECTs -- Why aren't these as mature as …

[ This is a quick post for my french followers about DBHangOpsFr ]

I’m sure you heard about DBHangOps, the famous virtual DBA meeting launched by Geoffrey Anderson from Box.net.
But did you know that some talented and passionate frenchies have launched DBHangOpsFr a few month ago?

DBHangOpsFr is THE virtual french DBA meeting you would love to attend.
I invite you to visit this page for more details : http://www.mysqlplus.fr/category/dbhangopsfr/

The next session will take place in November, follow me on twitter, looking for …

TSA Method in class (SmartOS)

There are two basic performance analysis methodologies you can use for most performance issues. The first is the resource-oriented USE Method, which provides a checklist for identifying common bottlenecks and errors. The second is the thread-oriented TSA Method, for identifying issues causing poor thread performance. I summarized the TSA Method in my Stop The Guessing talk at Velocity conf this year, and it is also covered in the Applications chapter of my Systems …

Since introducing TokuMX, we’ve discussed benefits that TokuMX has for existing MongoDB applications that require no changes. In this post, I introduce an extension we’ve made to the indexing API: clustering indexes, a tool that can tremendously improve query performance. If I were to speak to someone about clustering indexes, I think the conversation could go something like this…

What is a Clustering Index?

A clustering index is an index that stores the entire document, not just the defined key.

A common example is …