We are pleased to announce the third release in the 0.6 series of mydumper, a tool for performing logical MySQL backups. In this release, we focused on simplifying compiling the code and added new features for making logical backups. These new features include enhancements to AWS RDS support and extending TokuDB support.

Due to recent changes (or not so much) on mysql libs, it became impossible to compile mydumper without the complete mysql source code. To simplify this, we had to disable the binlog functionality by default, as it was the one affected by the mysql libs changes. Now you should be able to compile against any mysql version without issues. If you still want the binlog feature, it is still there and you can enable it with:

cmake . -DWITH_BINLOG=ON

The one caveat is that you will need to compile against a mysql version greater than 5.5.34. It’s also possible to …

I’m excited to once again be heading to San Francisco next week for Oracle OpenWorld, and also very pleased to have a booth there this year along with some great speakers from Percona.

The scope of Oracle OpenWorld 2014, which runs Sept. 28-Oct. 2, is enormous and there are several keynotes and sessions I’m looking forward to attending. Especially the talks focused on the areas of:

• MySQL architecture and application development
• Cloud and Big Data
• Database administration and DevOps
• High-Availability and Replication
• Performance and Scalability

I also have the honor of speaking on the topic of “ …

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.2. This is a GA release for 1.3.x. It can be used for production environments.

MySQL for Excel is installed using the MySQL Installer for Windows which comes in 2 versions:

• Full (150 MB) which includes a complete set of MySQL products with their binaries included in the download
• Web (1.5 MB - a network install) which will just pull MySQL for Excel over the web and install it when run.

You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/.

Several new features were added the 1.3.x branch, for more information see What Is New In MySQL for Excel 1.3 ( …

The MySQL Windows Experience team is proud to announce the release of MySQL Notifier version 1.1.6.

MySQL Notifier is installed using the MySQL Installer for Windows which comes in 2 versions:

• Full (150 MB) which includes a complete set of mysql products with their binaries included in the download
• Web (1.5 MB - a network install) which will just pull the MySQL Notifier over the web and install it when run.

You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/.

As an update to the previous announcement from Jun10, 2014 please find below the updated list of events where MySQL Community team is attending and/or supporting. Same as last time, you can find EMEA, APAC & events in America/Canada below.  EMEA

• SymfonyLive, UK, London, September 25-26, 2014
  • Andrew Morgan will run the Lightening talk on Automated High Availability and Sharding with MySQL Fabric on Sep 26th at 9:15 am.  
  • Do not forget to come to our booth to talk to our MySQL experts on Friday, Sep 26th!. 
• DrupalCon Amsterdam, The Netherlands, September 29-Oct 3, 2014
  …

MySQL Central @ Open World is coming up next week. I look forward to present “Evolving the MySQL Server Architecture”, Tue, Sep 30th 5pm-5.45pm at Moscone room 250.

Join me to discuss the big picture and directions for MySQL Server Architecture evolution.

In this talk I will discuss the driving forces and challenges motivating changes, and outline the vision for the MySQL Server Architecture. Topics to be discussed include the main architectural themes:

• Server Refactoring / Modularity
• Extensibility
• Performance and Scalability
• Security
• Integration and Manageability
• Everything online

I will demonstrate with examples how these principles are …

The MySQL developer tools team announces 6.2.3 as our GA release for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the new version for the official MySQL
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL
5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5,
with features such as:

• A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and taking advantage of the new GIS capabilities in MySQL 5.7.
  
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
  
• Metadata Locks View shows the locks connections are blocked or waiting on.
  
• MySQL Fabric cluster connectivity - Browsing, view status, and connect to any MySQL instance in a Fabric Cluster.
  
• MS Access migration Wizard - easily move to …

Dear MySQL users,

The MySQL developer tools team announces 6.2.3 as our GA release for
MySQL Workbench 6.2.

MySQL Workbench 6.2 is the new version for the official MySQL
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL
5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5,
with features such as:

• A new spatial data viewer, allowing graphical views of result sets
  containing GEOMETRY data and taking advantage of the new GIS
  capabilities in MySQL 5.7.
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
• Metadata Locks View shows the locks connections are blocked or waiting on.
• MySQL Fabric cluster connectivity – Browsing, view status, and connect
  to any MySQL instance in a Fabric Cluster.
• MS Access migration Wizard …

I will be presenting two sessions at MySQL Central @ Oracle OpenWorld in San Francisco next Thursday (2nd Ocotber). I hope to see as many of you there as possible and I’ll be around after the session to continue answering any questions.

NoSQL and SQL: The Best of Both Worlds [CON2853]

There’s a lot of excitement about NoSQL data stores, with the promise of simple access patterns, flexible schemas, scalability, and high availability. The downside comes in the form of losing ACID transactions, consistency, flexible queries, and data integrity checks. What if you could have the best of both worlds? This session shows how MySQL Cluster provides simultaneous SQL and native NoSQL access to your data—whether it’s in a simple key-value API (memcached) or REST, JavaScript, Java, or C++. You will hear how the …

This Wednesday I’ll be discussing two common types of big data: machine-generated data and user-generated content. These types of big data are amenable to sharding, a commonly used technique for spreading data over more than one database server.

I’ll be discussing this in-depth during a live webinar at 10 a.m. Pacific time on Sept. 24. I’ll also talk about two major sharding frameworks: MySQL Fabric and Shard-Query for OLTP or OLAP workloads, respectively. Following the webinar there will be a brief Q/A session.

Find the webinar link here: “How to Scale Big Data Applications Using MySQL Sharding Frameworks” for more information or register directly …