Why do we have to bother about built-in GTID support in MySQL 5.6 at all? Sure, it is a tremendous step forward for a lazy primary copy system like MySQL Replication. Period. GTIDs make server-side failover easier (slides). And, load balancer, including PECL/mysqlnd_ms as an example of a driver integrated load balancer, can use them to provide session consistency. Please, see the slides. But…

MySQL 5.6 Global Transaction IDs - Use case: (session) consistency
View more presentations on MySQL and …

I recently joined Facebook. I relocated to Redwood City (less than 10km from Facebook Menlo Park office) and I commute by bicycle (or caltrain + shuttle on rainy days). I'm currently taking a bootcamp training with Lachlan and other new employees, and will soon join database team.

I really enjoyed MySQL life at DeNA. This was actually the first time experience for me to manage hundreds to thousands of rapidly growing servers. I believe DeNA is the most technically advanced MySQL users in Japan. As you may know, DeNA is a creator of HandlerSocket NoSQL plugin. I created MHA for automating master failover and semi-online master switch. When I worked as a consultant at MySQL/Sun/Oracle, it was very difficult to allocate enough time for creating new products since I spent most of the time for 1-5 day consulting delivery to achieve sales/billing targets. I like short-term consulting, but I like long-term development/enhancement engagements, …

Complex multi-master solutions made easy with Tungsten by Robert Hodges & Giuseppe MaxiaFriday, April 13 at 1:00 pmTungsten has broken new ground how to make previously complex or completely unattainable solutions very simple and easy to deploy. Tungsten Replicator offers improvements in replication topologies and performance, using technologies that were either unknown or not used together

I’ll be speaking at the Shenandoah Ruby Users Group Monthly Meetup tomorrow in Harrisonburg, Virginia. The topic is “Seven Things To Know About MySQL Performance.” See you there!

Further Reading:

• Speaking at the Shenandoah Ruby Users Group
• Central Virginia MySQL Meetup has reached cruising altitude
• New Ruby Conference: Ruby on Ales 2011
• …

Introducing Anemometer - MySQL Slow Query Visualization
The DBA team at Box.com has just open sourced our in-house tool for tracking sql queries.  It's really been a huge help to us in terms of growing our company while maintaining consistent database performance.
This uses the pt-query-digest tool for collection -- you can set it up on cron to sample slow logs at regular intervals from all your db servers and insert the results into a database.  Anemometer makes it easier to dig through that information and see your query stats.
Here's a quick sample of what it looks like:
Enjoy!
Anemometer Wiki
…

We’re very pleased with community support for Percona Live MySQL Conference and Expo. We’ve got wonderful speakers providing content of phenomenal session lineup for the conference this year. We have community helping by spreading the world, about conference, picking talks and all king of other
wonderful contributions.

We also have series of events organized by Community and different organizations, taking place around the conference which you surely should not miss:

Pythian is stepping in to organize traditional …

If you are not part of 36 percent(1) of respondents have taken steps to ensure your applications are not subject to SQL injection attacks, it would be worth your time to look at the Oracle Database Firewall and the GreenSQL Database Firewall.

Those that missed the Defend MySQL Database with Oracle Database Firewall On-Demand Webcast can now watch it on-demand. The Oracle Database Firewall establishes a defensive perimeter around databases, while monitoring and enforcing normal application behavior in real-time to help prevent SQL injection attacks as well as unauthorized attempts to access sensitive …

The binary version for MySQL Cluster 7.2.5 has now been made available at http://www.mysql.com/downloads/cluster/ (GPL version) or https://support.oracle.com/ (commercial version).

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.2.5 (compared to 7.2.4) will appear in the 7.2.5 Change log.

I’ll be speaking at the Shenandoah Ruby Users Group Monthly Meetup tomorrow in Harrisonburg, Virginia. The topic is “Seven Things To Know About MySQL Performance.” See you there!

Right after Percona Live Santa Clara (which MariaDB is quite present for), its worth noting there are a few more events happening on Friday, April 13, 2012 at the Hyatt Regency Santa Clara. MariaDB will be present at 2/3 of those events.

• SkySQL & MariaDB Solutions Day – go ahead and register
• Sphinx Search Day – if you dig full-text search, you should be present so go ahead and register

The one event MariaDB won’t be present at is the Drizzle Day. That …