MySQL Connect is rapidly approaching and one of the speakers is Peter Zaitsev, CEO of Percona. Peter volunteered to participate in our survey of MySQL Community Members.

What are your speaking about at your session?
I’m speaking about indexing best practices for MySQL, specifically focusing at a new ways MySQL 5.6 can use indexes and what opportunities does it bring.

Who would benefit most from attending your session?
This is a topic of broad interest. Developers and DBAs both need to be very familiar with a way MySQL can use sessions.

What other sessions would you recommend or are planning to attend?
There are a lot of wonderful sessions this year. Specifically I will look forward to the product information from Oracle team – MySQL 5.7 and direction of the MySQL group with State of the …

My colleague and teammate Ernie Souhrada will be presenting a webinar on Wednesday, August 21, 2013 at 10 a.m. PDT titled “MySQL Security: Armoring Your Dolphin.”

This is a popular topic with news breaking routinely that yet another Internet company has leaked private data of one form or another. Ernie’s webinar will be a great overview of security MySQL from top to bottom, including changes related to security in the 5.6 release.

Topics to be covered include:

• Basic …

September 12, 2013, Reston VA

Please join us and learn how many government agencies such as NASA, Census, NARA and DoD deploy MySQL as the default database for their mission critical applications. Oracle MySQL experts will be available to introduce new features in MySQL 5.6, MySQL Cluster 7.3, and discuss the new enterprise extensions.

First I find out the first commit that is in 5.7 that isn’t in 5.6 (using bzr missing) and then look at the authors of all of those commits. Measuring the number of commits is a really poor metric as it does not measure the complexity of the code committed, and if your workflow is to revise a patchset before committing, you get much fewer commits than if you commit 10 times a day.

There are a good number of people who are committing a lot of code to the latest MySQL development tree. (Sorry for the annoying layout of “count. number-of-commits name”)

1. 1022 Magnus Blaudd
2. 723 Jonas Oreland
3. 329 Marko Mäkelä
4. 286 Krunal Bauskar
5. 230 Tor Didriksen
6. 218 John David Duncan
7. 205 Vasil Dimov
8. 197 Sunny Bains
9. 166 Ole John Aske
10. 141 Marc Alff
11. 141 Frazer Clement
12. 140 Jimmy Yang …

MySQL Connect is rapidly approaching but there is still time for you to register. Calvin Sun from Twitter is going to be speaking and is the second of prominent MySQL Community members in this blog series to show you why you should join us.

What are your speaking about at your session?
MySQL at Twitter.

Who would benefit most from attending your session?
Scaling MySQL.

What other sessions would you recommend or are planning to attend?
MySQL 5.6 at Facebook [CON7798]
MySQL Performance: Benchmarks, Tuning, and “Best” Practices [CON2971]
MySQL @ Facebook: Lots and Lots of Small Data [CON7446]
InnoDB: Table and Index Data Structures Architecture [CON6897]
The InnoDB Buffer Pool and I/O: How It All Works [CON3497]
Unlocking MySQL: Dealing with Locking in MySQL …

Following our events earlier this year in Raleigh, Montevideo, Buenos Aires, Toronto and Portland, we bring Percona University to …

MySQL Connect is very quickly approaching and I will have some insights from prominent members of the MySQL Community about why you should join us September 21st-23rd in San Francisco. Mark Callaghan of Facebook is the first subject and his answers are short, sweet, and concise.

What are your speaking about at your session?
The reasons and process of upgrading to 5.6.

Who would benefit most from attending your session?
People considering 5.6

What other sessions would you recommend or are planning to attend?
All of the sessions on InnoDB internals

Why should ‘Joe Average’ DBA or Developer attend MySQL Connect?
Learn more, network with others in the community, let Oracle know what you need in MySQL 5.7

A big thanks to Mark for being the first …

Our bigger customers where we help to deploy Galera Cluster for MySQL set-ups have some commercial hardware (e.g. F5 or Cisco) for load balancing instead of software load balancers.

For those hardware load balancer it is not possible to see if a Galera node is available or not because the MySQL daemon is still running and responding on port 3306 but the service is not available nonetheless.
So the load balancer still serves the Galera node while he feeds for example a joiner node with a SST. This would lead to application errors which is unlovely.

One can try somehow to teach the load balancer to find out if a Galera Cluster node is really available or not. But this requires a more sophisticated load balancer, know-how how to teach the load …

With the General Availability of the standalone MySQL Utilities it now makes sense to use these to simplify (and optionally automate) your MySQL Replication and High Availability solutions. In light of that, 4 of our MySQL white papers have been updated to reflect the new opportunities:

MySQL Guide to High Availability Solutions. Data is the currency of today’s web, mobile, social, enterprise and cloud applications. Ensuring data is always available is a top priority for any organization – minutes of downtime will result in significant loss of …

Time zones are a tricky feature. You live in a given time zone, and most of the time you won’t think about that at all. You may live in a place where you are conscious of time zones, such as the United States, if your business spans across the country, where you know that New York is three hours ahead of San Francisco or Chicago and Dallas share the same time zone. Time Zone support in MySQL is a complicate business in itself. Once you have updated your time zone tables, you can set your time zone in an human readable format:

set global time_zone="America/Los_Angeles";

This is nice and well. It tells you which time zone your server is working with. However, things get a bit hairy when you need to do practical …