On Thursday 23rd January, Thomas Nielsen and I will be hosting a webinar explaining the latest developments in managing MySQL Cluster. As always the webinar is free but please register here.

Note that we’ll be covering what’s new in MySQL Cluster Manager 1.3 which went GA this week.

By their very nature, clustered environments involve more efforts and resources to administer than standalone systems and this holds true for MySQL Cluster, the database designed for web-scale throughput with carrier-grade availability.

The MySQL Cluster Auto-Installer guides you through defining and running a well configured MySQL Cluster database – …

I was surprised to see that there is a 0.8.4 alpha release of MySQL Proxy released just a few days ago (it has been quiet for more than a year). Download it. Many of the bugs fixed are only referenced in an internal bug tracker according to the changelog. There are still about 83 bugs open in the public tracker. I reckon it is good news since it means its still getting some love from the Oracle MySQL team.

Related posts:

1. MySQL 5.1.26-rc released, and developer resources thoughts
2. …

PerconaLive 2014 program is published

After a few months of submissions and reviews, the program for PerconaLive MySQL Conference and Expo 2014 is published. The conference will be held in Santa Clara, from April 1 to 4, 2014.

Registration with early bird discount is available until February 2nd. If you plan to attend, this is probably the best time to act.

I will be presenting twice at the conference:

• MySQL Replication: Advanced features in all flavors it’s a 3 hours tutorial where I compare the …

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 …