We got a great response to our Percona MySQL University event in Raleigh With about a week to go before event we’re around 90% full, so if you plan to attend do not delay your registration until last minute. Also if you have registered before but can’t attend at this point please release your ticket so we can accommodate as many people as possible.

Number of people approached me about getting together for a drinks and dinner with Percona Team after the event and we’re happy to oblige. We’ll have Percona Mixer event at Flying Saucer Draught Emporium . If you plan on joining us please register for Percona Mixer at

I’m pleased to announce the first of the Percona Live MySQL Conference and Expo 2013 keynote speakers and new sponsors including Amazon Web Services, Google, Clustrix, Scalebase, PalominoDB, Database Trends & Applications, and Linux Journal. We are also now accepting applications for the DotOrg Pavilion. Also, nominations are now being accepted for the 2013 MySQL Community Awards which will be given during the conference Community Networking Reception.

The 2012 Percona Live MySQL Conference and Expo featured sponsorship and speakers from some of the world’s most admired brands and

I’m pleased to announce the initial list of keynote speakers for the Percona Live MySQL Conference & Expo, April 22-25 in Santa Clara, California. The conference promises great content with over 90 speakers in more than 110 sessions, 15 tutorials, and multiple keynotes. The MySQL Community Awards 2013 are also now accepting nominations. And do not miss your chance to save by taking advantage of the Super Saver registration rates which are only available for a few more days!

Keynote Speakers

This year the Percona Live MySQL Conference is pleased to welcome Matt Aslett of 451 Research who will present the keynote “MySQL, YourSQL,

I’ll be presenting a webinar next Wednesday, January 23 at 10 a.m. (Pacific Time), about issues application developers should think about for scaling out read-query traffic using multiple MySQL instances in a replication pair.

Specifically, about the care we have to take because replication is asynchronous.  This means the slave  may not have current data at all times, so an application must choose to query the slave or the master dynamically.  As much as possible, we’d like to automate this choice so that application developers can be the most productive.

Please join me for this webinar by registering here: http://www.percona.com/webinars/readwrite-splitting-mysql-and-php

The post

Just like previous years, the ‘MySQL And Friends’ community is gathering to have a dinner on the Saturdaynight of FOSDEM. This time it is on February 2nd, 2013.

This year, it will not be an Italian restaurant, but more a Belgian style restaurant, about 10 minutes walk from the FOSDEM event.

Mirabelle: http://www.mirabelle.be/index.php?lang=en
Chaussée de Boondael, 455
1050, Ixelles

If you wish to attend, please register at 

Percona is glad to announce the release of Percona Server 5.1.66-14.2 on January 15th, 2013 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.1.66, including all the bug fixes in it, Percona Server 5.1.66-14.2 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.1.66-14.2 milestone at Launchpad.

New Features:

• Multiple bitmap file

Percona Live MySQL Conference and Expo 2013 – the largest MySQL Conference event of the year is getting close and we’re now announcing two community activities which are going to happen at this event.

Call of DotOrg Pavilion exhibitors is open – DotOrg pavilion is a free expo hall space for non commercial projects relevant for MySQL community. If you’re working on the project which you would like to get in front of a larger community but can’t afford expo hall exhibitor price tag because of non commercial nature of the project it is a great opportunity to do so. In the

In a few hours I’m leaving for my “SouthEast Meetup Tour” first going to Charlotte where I’m speaking Today, Jan 14, about MySQL Indexing: Best practices on local MySQL Meetup and then going to Atlanta to give the same talk on Atlanta MySQL Meetup Jan 15th. If you’re in the area please come by, I’ll have some Books and T-shirts to give away!

The post Reminder: Speaking at MySQL Meetups in Charlotte and Atlanta today and tomorrow. appeared first on MySQL Performance Blog.

At Percona we focus on education a lot, which we believe is critical for us to be successful with our mission of making businesses successful with their use of MySQL. The MySQL Performance Blog, our first effort in this space, by now contains over 1,000 technical articles. We have spoken on countless conferences and Meetups and have published our knowledge in our “High Performance MySQL” book. We answer your questions on our forums, and host free technical Webinars. And for more intense MySQL educational

Start of the year and time for the first speaking tour. This time I will take my MySQL Indexing Best Practices presentation to Charlotte on January 14 and Atlanta on January 15.

I think this presentation is great for Meetup as it is both providing a lot of very good ready to use practical advice on picking MySQL indexes to people only starting to use MySQL, as well as going into the more advanced topics of MySQL index trickery so even advanced MySQL users will find something new to learn. Meetup format should also allow us more time to go into more details and more practical questions when useful. Bring your own indexing war stories if you’re joining us !

Another great thing about indexing topic is

Now that we are in the New Year, it is time to settle back into work and make plans for 2013. As part of your professional development planning, consider Percona MySQL Training.

Percona will be holding the following MySQL Training classes in the first quarter:

• January
  • Live Virtual Training – DBA Training for MySQL: January 7-10, 2013
  • Chicago, Illinois, USA : January 14-17, 2013
  • London, UK: January 14-17, 2013
• February
  • Frankfurt, DE: February 4-7, 2013
  • San Francisco, CA, USA: February 4-7, 2013
• March
  • New York, NY, USA: March 11-14, 2013

To view these training events, and others, go to percona.com/training.

As a thank-you for making 2012 a

Percona Live London wrapped up last week to very positive reviews from attendees and sponsors like those from Johan De Meersman.

Percona was pleased to provide an engaging event for MySQL community members that featured engaging tutorials, highly rated breakout sessions, a very well-attended Tuesday community networking reception sponsored by Clustrix, and keynotes from a variety of industry experts:

• Peter Zaitsev, Percona
• Monty Widenius, Monty Program Ab
• Robert Hodges, Continuent
• Frank Terburg, Clustrix

We were pleased to see such a varied and all inclusive group of MySQL community members in attendance. A few facts about the attendees:

• 52% were from the United Kingdom and 35% were from other parts of Europe that

On December 19th at 1 PM Eastern / 10 AM Pacific, I will be giving a
webinar entitled “10 Percona Toolkit Tools Every MySQL DBA Should Know
About”.

As a Consultant, I make heavy use of Percona Toolkit tools while
solving customers’ problems, and I have used this experience to select
what I consider to be the top 10 tools everyone working with MySQL
should know about. I will present each of the selected tools using
examples based on real-world cases.

You can sign up by clicking the “Register” button here. Hope to see
you next week!

The Web And PHP Magazine just published an article describing Percona XtraDB Cluster written by Liz van Dijk and Kenny Gryp. It is a pretty high-level introduction to the technology, so definitely give it a read if you’ve been wanting to give it a closer look.

Go to their website http://www.webandphp.com and download Issue number 9 for free!

As Percona Live London is raging in the UK, I thought it fitting to remind everyone about the next big Percona Live: MySQL Conference and Expo 2013 in Santa Clara, Californa on April 22-25, 2013.  You can register NOW for this conference, and the Super Saving Registration deadline ends on December 28th, so be sure to register early if you already know you’ll be there.

As promised, I wanted to keep giving updates on the committee’s progress in selecting the

On Monday I will deliver with Seppo Jaakola from Codership a tutorial on Percona XtraDB Cluster (Percona Server + Galera).

Already in London and you don’t know how to consume the hotel’s bandwidth ? If you attend this tutorial, you can download the Virtual Box appliance we will use during the session.

Two versions are available:

• PLUK 2012 Appliance (32-bit)
• PLUK 2012 Appliance (64-bit)

How to test them:

Time for another poll! I wonder What CPU Architecture do you use for running MySQL in Production ? I guess most of the game here is between Intel and AMD x86-64 variants though I wonder if there is still a lot of use for others in the wild. If I am missing some Architecture which is still alive in your data center please post a comment and I will add it to the list.
Please select all what applies. If you would like to share what works better for you in the comments I appreciate it.

One of my favorite tools in the Percona Toolkit is pt-query-digest.  This tool is indispensable for identifying your top SQL queries, and analyzing which queries are accounting for your database load.

But the report you get from pt-query-digest is only as good as the log of queries you give it as input.  You need a large enough sample of query logs, collected over a period of time when you have representative traffic on your database.

You also need the log to include all the queries, not just those that take more than N seconds.  The reason is that some queries are individually quick, and would not be logged if you set the long_query_time

If you are interested by a great and revolutionary HA solution for MySQL or even if you already have some experience with PXC and/or Galera, I invite you to attend the tutorial I will deliver in Percona Live MySQL Conference London 2012 (PLUK2012), December 3rd : Percona XtraDB Cluster in a nutshell.

Small amount of theory and a lot of exercises and examples to really tame the beast that PXC is !

A Codership engineer will also be present and happy to help me answering your questions.

Note to attendees: please bring your

Have you been using Percona Server ? Interested to Try ? Using Percona Server in Production Tutorial at Percona Live, London is a great talk for you.

In my experience working with customers I discovered many people are not aware about number of unique features Percona Server offers and how they can help you to achieve better performance and stability in your MySQL environment. I start this talk with many general features which MySQL and Percona Server share giving advice on best production configuration and best practices and then move to special features which are unique to Percona Server. I provide specific examples how to use the features and what benefits they provide.

See you there !

I have a pleasure to deliver Webinar on Industrial-Strength MySQL Applications Using Percona and Continuent together with Robert Hodges next week, Nov 28.

We will talk about how you can use technologies from Percona and Continuent to build Highly Performance and Highly Available Applications utilizing
MySQL Replication. I’ve been interesting in doing this Webinar for long time as we have a lot of great feedback from our customers using Continuent Tungsten and Percona software very successfully to implement advanced filtering, achieve much higher replication performance with parallel replication as well as make failover a lot more painless and easy to use. If you’re using MySQL Replication in highly demanding

Another Percona Live event is coming up, this time in London on the 3rd and 4th of December. I’m sure it is going to be as awesome as it was last year.

This year, I will talk about ‘Choosing Hardware For MySQL‘.

Of course, the most important hardware components will be covered: CPU, Memory, Network, Disk Subsystem and also the Cloud.
I will try to help attendees better understand how MySQL uses hardware (and how it does not), how it optimizes random IO operations on disk, what scalability means for MySQL, what it’s limitations are

The Percona Toolkit team is happy to announce the release of Percona Toolkit version 2.1.6. This is the sixth stable release in the 2.1 series, and primarily a bug-fix release; We suggest that users upgrade to the latest version of the tools.

The complete list of changes is on the Launchpad milestone for 2.1.6, but here are some highlights the release:

• pt-online-schema-change can now handle column renames
• pt-online-schema-change’s DELETE trigger no longer fails when altering a primary key
• pt-stalk got a plugin hook interface
• pt-show-grant support for column-level grants
• pt-table-checksum will warn if slaves have a differing binlog_format

Remember that if you need help with Percona Toolkit, we provide flat-fee, unlimited

I was honored to be asked to be a member of the committee for the “big” MySQL conference: Percona Live MySQL Conference and Expo 2013 in Santa Clara, CA.  Personally, I’ve been attending this conference for 6 or 7 years and missing it only when my wife was pregnant with a due date in April (we have two children with April birthdays).

To me there was always a bit of mystery around conference talk selection committees, and this is the first public conference I’ve performed these duties for.  I’m not writing this post representing the entire committee, just as a member trying to let people in on what we get up to in general and where we’re at now.  Perhaps a few questions have crossed your mind:

The Internet Summit seems to be the largest Tech event of the year in Raleigh,NC area. I’ve attended this conference last year and I’m proud to be a speaker this time around. If you’re up for early morning talks I’m part of “Tech Track: Inside the Data Center” block of sessions, starting at 8am, where I will talk about challenges of using MySQL in the data center.

I’ll be on the show for the full day tomorrow so feel free to drop me email if you’re attending if you’d like to catch up for business or pleasure.

On November 15th at 1PM Eastern / 10 AM Pacific, I will be giving a webinar entitled “The Hazards of Multi-writing in a Dual-Master Setup“.  In my experience many people do not understand the difficulty of managing writes to RDBMS datastores in a high availability environment, especially where asynchronous replication is used (which is almost everywhere).

This talk gives an overview and concrete examples of how writing across dual-masters can and will break your assumptions about ACID compliance, how you can work around it, and some alternative solutions that are on the market today that attempt to address this problem.  This will be a great session

Percona Live, London 2012 continues streak of “not to be missed” events in London, following the footsteps of Royal Wedding, Diamond Jubilee and Summer Olympics. We have prepared great set of Tutorials and Sessions for these two day event. Here is my personal selection of the talks I’d love to attend, though I rarely have such chance

MariaDB

“devops” seems to be everywhere now, or at least everyone is talking about it. But what does that really mean? And how does the DBA integrate the movement ?

During next week’s webinar, I will explain to you the big principles of the devops culture and illustrate how DBA’s can (must) be part of the movement. Then I will explain the best practices on how to deploy MySQL in a large scale environment using tools coming from the devops world like git, puppet, vagrant, jenkins…

Be prepared for Halloween, register for this free webinar, and join me on Wednesday!

I’m pleased to announce special bundled hotel/conference pass packages for the Percona Live London MySQL Conference which is December 3-4, 2012 at The Millennium Gloucester Conference Centre in London. The conference features tutorials December 3rd and breakout sessions December 4th. A networking reception will follow the Tuesday sessions.

Four special, money-saving bundles are available, whether you will attend the conference alone or will attend the conference with a colleague and share a hotel room. As a bonus, all of the conference hotel packages include a hot English breakfast and in-room Internet access!

– One conference only pass and

Call for Papers for the annual Percona Live MySQL Conference and Expo in Santa Clara, are set to close at the end of the day tomorrow Oct. 12th. Please consider submitting one or more speaking proposals. If you are selected to speak you will receive a free full conference pass valued at over $1,500.

In addition, Super Saver Registration for this conference and Advanced Rate registration for our London conference end tomorrow as well. Sign up now before the price goes up!

Submit your papers and or register here: http://www.percona.com/live/mysql-conference-2013/

or here for London: http://www.percona.com/live/london-2012/