It is the start of the traveling season for the MySQL Community Team and many of the engineering teams. I will be at Skiphp this weekend,
Sunshinephp, The Los Angeles MySQL User Group on Feb. 20th, and SCaLE. Morgan Tocker will be at Confoo, FOSDEM, and PHPUK.

You can see some of our engineers at Percona Live.

• Oracle talks at Percona Live
• “MySQL 5.7: Core Server Improvements,” Morgan Tocker and Rune Humborstad, Oracle
• “MySQL 5.7: InnoDB – What’s New,” Sunny Bains, Oracle
• “Sharding and Scale-out using MySQL Fabric,” Mats Kindahl, …

Last night, after my previous blog post, everyone in attendance at the SkySQL developer meeting in Barcelona gathered for dinner at El Cangrejo Loco, which, if my High School Spanish is working, translates as The Crazy Crab. After the excellent food, the tradition of singing at MySQL/MariaDB developer meetings was preserved.

Today the MariaDB developers in attendance at the SkySQL developer meeting in Barcelona got together to work on plans for MariaDB 10.1. We also paused for a group photo:

Many tasks have been identified for possible inclusion in 10.1. Some have already been marked as such in JIRA. A summary is available for those that are interested. More will be added as the plans for 10.1 firm up, so check back.

…

MySQL for Visual Studio is a new product including all of the Visual Studio integration previously available as part of Connector/Net.  The 1.1.3 version is now released as GA and is appropriate for use in production environments.  It is compatible with MySQL Server versions 5.0-5.7 and Visual Studio versions 2008 to 2013.

I’m very pleased to announce that the breakout session and tutorial schedules for the third annual Percona Live MySQL Conference and Expo 2014 are now online. The conference will be at The Hyatt Regency Santa Clara and Santa Clara Convention Center, April 1-4, 2014. I wish to personally thank our dedicated Conference Committee members who put in many hours evaluating hundreds of submissions in order to create these schedules.

Breakout Session Schedule

We have a strong and diverse schedule of breakout sessions which will take place April 2-4, following each morning’s keynote addresses. The speaker list includes top MySQL practitioners from …

Hi I try to follow your tutorial but I can’t log in the mysql system.

I have created my two user with auth_pam and auth_pam_compat with localhost and %
The mysql doesn’t reply that the password is wrong just that my access is denied .

How can I debug that ? I have looked in the mysql log nothing is here …

[myuser@TEST_BDD_LDAP ~]$ mysql -p
Enter password:
ERROR 1698 (28000): Access denied for user ‘myuser’@’localhost’

I’ve been blogging a lot about some of the new things you can expect with Percona XtraDB Cluster 5.6 and Galera 3.x – and GA is coming …

Oracle has released the Critical Patch Update (CPU) advisory for January 2014.

The affected MySQL products are:

• Oracle MySQL Enterprise Monitor, versions 2.3, 3.0 

• Oracle MySQL Server, versions 5.1, 5.5, 5.6

So this means that you should consider updating MySQL. For MySQL Enterprise the updates should be available on My Oracle Support and for the Community version the new versions are on the regular download locations. I guess the official repositories are already updated.

For MySQL 5.6 you should upgrade to 5.6.15
For MySQL 5.5 you should upgrade to 5.5.35
For MySQL 5.1 you should upgrade to 5.1.73

If you use the MySQL release from your distribution …

Several MariaDB developers are attending SkySQL’s annual engineering meeting being held this week in Barcelona. While some of the discussions are SkySQL-specific (customers, internal projects, and so on), there are, naturally, lots of MariaDB discussions happening.

Patrik Sallner, CEO of SkySQL, opened the meeting this morning with a short presentation about SkySQL’s goals for 2014. While the plan includes standard business-like things that include growing the company and sales goals, the top two goals for 2014 are:

1. Help make MariaDB into the leading open source database

2. Help increase awareness and adoption of MariaDB

Looking back at 2013, it was an excellent year for MariaDB. It is now the default database in Fedora, OpenSUSE, Mageia, and others and it is included in the recently released Red Hat Enterprise Linux 7  preview. During the last …

MySQL has sometimes faced criticism for being too relaxed at allowing invalid values, or inserting but truncating values that are out of range. For example:

mysql> CREATE TABLE unsigned_int (a int unsigned);
Query OK, 0 rows affected (0.03 sec)

mysql> INSERT INTO unsigned_int (a) VALUES (-1);
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> SELECT * FROM unsigned_int;
+------+
| a    |
+------+
|    0 |
+------+
1 row in set (0.00 sec)

In MySQL 5.0 two strict sql_mode options were introduced to be able to change this behaviour:

• STRICT_ALL_TABLES – Behave more like the SQL standard and produce errors when data is out of range.
• STRICT_TRANS_TABLES – Behave more like the SQL standard and produce errors when data is out of range, but only on transactional storage …

UPDATED: explaining the role of innodb_strict_mode and correcting introduction of innodb_file_format

Compressed tables is an example of an InnoDB feature that became available with the Barracuda file format, introduced in the InnoDB plugin. They can bring significant gains in raw performance and scalability: given the data is stored in a compressed format the amount of memory and disk space necessary to hold it and move it around (disk/memory) is lower, thus making them attractive for servers equipped with SSD drives of smaller capacity.

The notion of “file formats” (defined by the variable innodb_file_format) was first introduced when InnoDB was still a …