In May we proposed deprecating and removing the old password format in MySQL 5.7. I am happy to report, that this proposal has gone ahead, and can already be seen in the 5.7 DMR5 release notes!

With old passwords removed, and with recent versions of MySQL also offering new options for authenticating to MySQL, today I wanted to write about three additional proposed changes that follow suit:

1. Deprecate the PASSWORD() function

   As we already support multiple authentication methods (and may desire additional in the future), calling the PASSWORD() function to generate a password hash has a strange user experience.

   What I mean by this, is that PASSWORD() is not able …

In keeping with a MySQL tradition, we will be holding a storage engine vendors meeting to coincide with MySQL Central @ Open World this year.

The day and venue is TBD, but will be in the San Francisco/Bay Area week of 29th September - October 3rd.

For an invitation, please send me an email!

We are pleased to announce our attendance at the PyCon New Zealand in Wellington, New Zealand, on September 12-14, 2014! This time we do not have a booth, but will be very actively going around and talk to you. Find our staff wearing MySQL t-shirt!

Anyway if you are interested our colleague from the Solaris Modernization team, James C. McPherson is going to have a talk on Why Python rocks Solaris. Come to hear James' talk scheduled for Saturday, Sep 13 @ 11:20 am (Track 1). 

Download MariaDB Galera Cluster 5.5.39

Release Notes Changelog What is MariaDB Galera Cluster?

MariaDB APT and YUM Repository Configuration Generator

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.39. This is a Stable (GA) release.

See the …

Jeremy Cole recently blogged about the feature SET GLOBAL sql_log_bin. In his blog post, Jeremy suggested that there is no strong use-case for this feature, and that it is too easy to run accidentally (i.e. SET GLOBAL instead of SET [SESSION]). The result of this incorrect usage is that slaves will drift out of sync from masters.

We discussed Jeremy's request in the MySQL team, and we agree that the syntax should produce an error in MySQL 5.7. However, we have not yet determined which steps should be taken for MySQL 5.5 and MySQL 5.6. The two proposals we would like to float are:

1. The statement SET GLOBAL sql_log_bin=N produces a warning.
2. The statement SET GLOBAL sql_log_bin=N produces an error.

Option #1 does not …

Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.20.

In particular:

• Thank you to Jeremy Cole for reporting a case where InnoDB's redo log could become corrupt with externally stored blobs. Jeremy also provided a testcase to demonstrate the problem. Bug #69477.
• Thank you to Ronald Bradford for identifying that MySQL would continue to operate even though the binary log could not be written. Our team picked up Ronald's blog post, and filed a bug in response. Bug #51014.
• Thank you to Daniël van Eeden, Andrew Garner, Detlef Ulherr and Bjoern Boschman …

Restarting production database servers with gigabytes of memory is difficult. It can lead to cold caches and other operational complexities.

The InnoDB team is looking to make improvements so that restarting MySQL is required as little as possible. Please help them out by answering which configuration settings you are most eager to see made dynamic.

Thanks!

Download MariaDB 10.0.13

Release Notes Changelog What is MariaDB 10.0?

MariaDB APT and YUM Repository Configuration Generator

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.13. This is a Stable (GA) release.

See the Release Notes and …

Last week we released Connector/Python v2.0 (alpha); today we publish the source on GitHub. Yes, we are using Git internally and are now able to push it out on each release. Previous versions are still available through LaunchPad.

Here is the full process to get Connector/Python installed in a virtual environment. You’ll need Git installed of course.

shell> git clone https://github.com/oracle/mysql-connector-python.git cpy
shell> virtualenv ENVCPY
shell> source ENVCPY/bin/activate
(ENVCPY)shell> cd cpy
(ENVCPY)shell> python setup.py install
(ENVCPY)shell> python
>>> import mysql.connector
>>> mysql.connector.__version__ …

The frm file has provided long service since the earliest days of MySQL. Now, it is time to replace it with a native InnoDB-based Data Dictionary.

This is a change that has been on our wish list for a long time, as well as others in the MySQL development community:

• Brian Aker on Drizzle, The Death of FRM
• Jan Kneschke on MySQL Internals: screens (or .frm files)
• Stewart Smith on The FRM file format, Goodbye FRM (or at least the steps to it), …