Thanks to the MySQL Community for all of the support around the past MySQL Innovation Day.  We had a great turnout on-line and in-person. It was exciting to hear about all the features coming in MySQL 5.6. The community and engineers also had time to interact about some of the new features at the BOFs afterwards.

If you missed anything.. all the slides are now available for you to download. If you watched the webcast of the AM sessions, do not forget the afternoon had great sessions as well. All of the sessions slides and some video are now available here.


Look forward to seeing everyone at …

Conferences
The 1st Latin American Conference on MySQL, NoSQL and Cloud Technologies will be held in Buenos Aires from Tuesday June 26 through Thursday June 28th at the Hilton Buenos Aires.

OSCon will be held Monday Jul 16th through 20th

MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps.

read more

While the agenda is still subject to change and some updates are certainly coming, we have a first look at the great content at the MySQL Connect Conference this year.

Oracle's is sending some of their talented MySQL engineers and they will have sessions on Backups, Performance Schema, InnoDB, Replication, Utilities, PHP, Python, the new Optimizer and etc etc...

We also have some talks from the MySQL Oracle ACEs :

• Ronald Bradford - Founder & CEO, EffectiveMySQL -  Oracle Ace …

The third book of the Effective MySQL series provides the reader with the tools, knowledge and tips for managing a scalable MySQL Replication environment.

Chapters

1. The Five Minute DBA
2. Diagnosing Common Replication Problems
3. Improving Standard Replication Features
4. Understanding Multi-Master Replication
5. MySQL Replication Tools
6. Extending Replication for Practical Needs
7. MySQL Configuration Options
8. Monitoring Replication

You can find the code examples from this book at
https://github.com/effectiveMySQL/ReplicationTechniques

Order Now

This title is available in print, PDF and Kindle formats from these retailers.

Version 1.0.1 of the Percona Monitoring Plugins is released. This is a routine bug-fix release that addresses several minor issues.

The Percona Monitoring Plugins are high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.

The plugins are fully supported for customers with a Percona Support contract, and free installation services are provided as part of some contracts. You can find links to downloads, …

Yo!

    Time for a new release of my MySQL JSON loader. I have added a bunch of features and fixed some bugs since last. So nothing revolutionary there. The program is still a C-program, using autotools to build and set up. It has been tested on 64-bit Linux (Ubuntu) but should work on other platforms too. One bugfix in particular makes a difference, I didn't really handle auto-commit the way I should in 1.0, but that is fixed now. Among the features I think that SQL retry is a useful one, as is the ability to skip over leading JSON records and the ability to run arbitrary SQL before starting to load.
    Download from sourceforge!
    Stay tuned, as I will release 1.0 of my JSON unload / export tool real soon. I have used it for a while, I'm in the process of writing some docs and cleaning …

We've had a number of questions from customers lately about a change in Enterprise Linux 6 that introduces compatibility problems between older vendor RPMs (those from dev.mysql.com or Monty Program AB, for instance) and newer OS packages (the ones available from the OS distribution's package repository). Specifically, there is a new "mysql-libs" package that some other EL packages require. In particular, postfix requires mysql-libs, any many packages require postfix, which is the default MTA in EL6.

read more

Heather Sullivan, Senior DBA, describes how Constant Contact architected their replication strategy. Constant Contact has chosen Continuent's Tungsten for their replication needs, which provides a means to manage a highly available environment with disaster recovery, and greatly simplifies the day-to-day management of MySQL replication. Continuent Tungsten also helps to lay the foundation for

We're growing like crazy and looking for awesome people across the entire company, but in particular we want to add a few good MySQL DBAs to our team.  I know there is a lot of competition out there for database experts, and for good reason.  MySQL is used at so many companies, and as they grow from small startups to some of the largest in the world they all need experts to help grow their databases.
Why choose Box?
Our TechOps team is awesome.  Our developers are great to work with. We're growing fast.  There are many difficult things -- common pain points -- that we already handle well.  The list of interesting, challenging problems we have yet to tackle is long.  You'd be able to choose to work on what interests you most.
Box is aiming to be the market leader in enterprise file sharing; it's an amazing opportunity to start here early and see the infrastructure grow to a massive scale and …

These past couple of weeks have been quite intense and generated a lot of news.

What stood out to me was the escalation in the race between MySQL/Oracle and MariaDB to be better. I have to say that all of us are benefiting from this competition. I am also not fully sure that Oracle would have put in such effort if Monty and his team was not pushing so hard. Certainly, Thomas Ulin has his agenda, but Monty is doing a great job for his product and in pushing the competitor to do his best. The result is that MySQL is becoming a better product day by day.

Thanks guys!

MySQL Internals

Is it a crazy idea to use MySQL for Json and HTTP embedded? I love crazy things, and this seems crazy, but it is closer to our reality than we can imagine:

“PoC: HTTP, JSON, JavaScript, Map&Reduce built-in to MySQL

What if MySQL had an HTTP interface and would reply JSON? What if MySQL …