Keith Larson and I will be presenting MySQL for Oracle DBAs or How to Speak MySQL for beginners at Collaborate 12 in April at the Mandalay Bay hotel in Las Vegas.

…

One of the more common questions I get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success means I should advise something that is stable, reliable, easy to manage and has plenty of resources available online. It should also allow running MySQL without too much hassle. Unless there are individual circumstances, it actually makes the decision quite easy.

There are probably only a few distributions, which can be considered: CentOS, Debian, RedHat Enterprise Linux, SuSE Linux and Ubuntu. Of course CentOS and Ubuntu derive from RedHat and Debian respectively, but their install bases are large enough to mention them separately. Running MySQL won’t be much different whether one or another distribution is used. All use common Linux kernel – the heart of Linux operating system – which in principle will behave the same way in all cases. The kernel versions may …

In case you haven’t seen it, the Facebook team held a Tech Talk on Monday focusing on MySQL and HBase at Scale.

You can view the recording here.

Facebook relies on MySQL for it users database, handling users interactions such as likes, shares, status updates, events, notifications…etc, and is running massive operations, especially considering (as Domas Mituzas from the database performance team mentioned) the time and scope of “social” data. Domas shared some pretty impressive numbers including:

• 800M active monthly users

• 500M active daily users

• 350M mobile users

• 7M apps and web sites integrated via platform

• 60M queries per second

• 4M row …

MariaDB or MySQL ext3 ext4 journaling options for faster databases.
In my previous posting http://alexalexander.blogspot.com/2011/12/mariadb-and-mysql-performance-boost.html I was suggesting to use "noatime" to improve your databases performance. Now we can go a step further to make things even faster - ext 3 or ext4 filesystem journaling options:

Most of us are aware that modern filesystems (ext3, ext4, xfs, reiser etc...) use journaling. Journaling in concept is very similar to databases write ahead logging WAL it helps to avoid data corruption on the filesystem when the system is abruptly shutdown. On system's comeback the filesystem will replay the journal and correct the data on the filesystem. Awesome concept, but were you aware that there are several options to journaling and depending on the options selected …

Just in case you've missed my initial post last week (there were some problems on the Planet MySQL site, and it did not appear correctly)..

I'm looking for Test Scenarios to extend our Benchmark Workloads to run on MySQL Server in way to improve MySQL performance and find the most optimal solutions to your problems.. - More closed to production workloads we're testing, better MySQL will keep your production workloads in the future! easy, no?.. ;-)

Well, it's just a reminder from my initial post (and I cannot believe you have nothing to share ;-))
(hoping there will be no problems on the Planet MySQL site this time ;-))

Rgds,
-Dimitri

In case you haven’t seen it, the Facebook team held a Tech Talk on Monday focusing on MySQL and HBase at Scale.

You can view the recording here.

Facebook relies on MySQL for it users database, handling users interactions such as likes, shares, status updates, events, notifications…etc, and is running massive operations, especially considering (as Domas Mituzas from the database performance team mentioned) the time and scope of “social” data. Domas shared some pretty impressive numbers including:

• 800M active monthly users

• 500M active daily users

• 350M mobile users

• 7M apps and web sites integrated via platform

• 60M queries per second

• 4M row …

As you may or may not know, MariaDB has supported microseconds in version 5.3 for several months already.

And now MySQL has added microsecond support in version 5.6 (5.6.4, specifically).

For more details on MariaDB microseconds, please refer to this page:

http://kb.askmonty.org/en/microseconds-in-mariadb

And for more details on MySQL microseconds, see “Fractional Seconds Handling” on the following page:

http://dev.mysql.com/doc/refman/5.6/en/news-5-6-4.html

From what I can tell, the implementation looks largely to be the same (at least from a user perspective), in that if the fractional part is given, it must be an integer number 0 to 6. And if no precision is …

The last post described MySQL Cluster epochs and why they provide a good basis for conflict detection, with a few enhancements required. This post describes the enhancements.

The following four mechanisms are required to implement conflict detection via epochs :

1. Slaves should 'reflect' information about replicated epochs they have applied
   Applied epoch numbers should be included in the Slave Binlog events returning to the originating cluster, in a Binlog position corresponding to the commit time of the replicated epoch …

We welcome everyone to Amsterdam where on Friday at 16:00 CET we will be giving a talk together with SpamExperts at the Open Source Conference 2011. The talk will be about MariaDB and how SpamExperts successfully overcame their problems with MySQL by migrating to MariaDB. The talk will focus on the MariaDB features that differentiate it from vanilla MySQL and an in-depth case study on SpamExperts and the problems they faced when deciding to migrate to MariaDB and a detailed overview of the actual migration process.  For more information about the conference, check out their website: http://www.opensourceconference.nl/

If you are close to Washington DC, you should plan to attend our Percona Live event on January 11th at the DC Convention Center. We have three tracks of expert speakers on core MySQL-related topics.

This event will not be as large as some of the other events we’ve run, with a capacity of about 200. Frankly, we are targeting this to more local attendees. We know that a lot of people simply can’t travel out to Santa Clara for the main MySQL conference every year, and we want to make sure there is great technical content for them. This is part of our idea to host smaller regional events periodically to try to make sure top-quality MySQL events are more accessible to all, not just the privileged.

We have …