Want to get started on the world's most trusted and depended-on open source database? Sign up for the MySQL for Beginners training course today.

In this 4-day, instructor-led course you will develop an understanding of relational databases and how to design a robust and efficient database. You will harness that power by learning SQL and use it to build databases, populate them with data and query that data through extensive hands-on practices.

You can take this live class as a:

• Live Virtual Event: Take this class from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
• In-Class Event: Travel to an education center to take this class. …

Hello Ryan,

How did you create those users in MySQL and which plugin did you use auth_pam or auth_pam_compat?

Also, if you are getting an access denied, it’s more likely that your GRANT is not applied correctly as in this guide I gave an example using localhost, but you need to use your network or IP which such user is connecting from.

When we started Percona about 7 years ago one of the ideas behind the business was to provide customer focused services, which I refereed to as “bias free” at the time.

What do I mean by customer focused services ? Is not this something most of the company out there would claim ? Not in our definition! What we have observed years ago is what many companies view the services organization as the part of sales force, looking to recommend the product and services companies sell whenever they fit or not. In fact I had conversation with consultants from number of companies asking them direct question – if you found during project delivery your solution is the better fit can you recommend against implementing it ? In most cases the answer is no, either being direct management instructions or a fear of confrontation – Sales team could be quite unhappy with sale which they have done rolling back because of “consultants fault”. We …

MySQL did not start as a durable data store and had lots of mockery for that – (ISAM? no replication?). Eventually InnoDB took over, and it brought at least parts of MySQL into a reliable storage world. Checksummed pages, decent crash recovery, good synchronous behavior had InnoDB ahead of open source competition for quite a while, as well as on par with other solutions. Unfortunately, that safety was limited only to InnoDB row operations and not DDL or replication state.

In the world where nothing before was synchronous, transitioning to reliable storage introduced lots of slowdowns, and still was not good enough.
There was lots of work done outside of internal MySQL/Sun/Oracle development to help with some of these problems. For example Google 4.0 patch tried to solve slave crash safety by storing replication state inside InnoDB – not only that …

This week we continue our interview with Noam Kritzer of Bakos & Kritzer, talking about patent case law and patent trolls. Ear Candy is temporary table ghost files, and At the Movies is Manipulating JSON with MariaDB and MySQL.

defensive vs. offensive patents

Patent trolls

Trademarks and domain names

Copyright.gov, a resource written for lay people.

read more

We know very well that database technologies need a blog presence, and how to best offer that blogging experience — without the danger of boredom — is something tons of Oracle, SQL Server, and MySQL bloggers continue to show through Log Buffer. Enjoy!

Oracle:

Various approaches exist to organize your groovy scripts and package up utilities.

Oracle Certification announces the release of the new Oracle Linux 6 certification paths.

Designed for the Cloud, the new multitenant architecture of Oracle Database 12c now enables customers to greatly simplify and accelerate database consolidation by …

Percona is glad to announce the release of Percona XtraBackup 2.1.4 on August 9th, 2013. Downloads are available from our download site here and Percona Software Repositories.

This release is the current GA (Generally Available) stable release in the 2.1 series. Percona XtraBackup is an open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.

New Features:

• Percona XtraBackup has introduced …

Recently i updated to MySQL 5.6 and we were really excited about the very good overall performance. But beside a major bug concerning wrong results when running a SELECT that includes a HAVING based on a function (see http://bugs.mysql.com/bug.php?id=69638) we also noticed that from time to time the replication breaks with the following error:

Last_SQL_Errno: 1590
Last_SQL_Error: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log

After some investigation it seemed like this happens if one modifies some user privileges, so we stumbled upon http://bugs.mysql.com/bug.php?id=68892.

Essentially the bug report says that if you use the wrong syntax for GRANT-statements the replication will break. So far, so bad. I told everyone who had the …

I have rehashed a list of useful reporting queries from my blog which I hope people would find useful for their business or clients. These are not MySQL specific, by any means.

Orders

• What is the total revenue (by segments)? - You are looking for 'peaks and troughs'. For example, found a peak season? you can plan better for it next year. Found an off-season? perhaps offer some deals for that period.
• What is the total placed orders, completed orders and abandoned/uncompleted orders?
• What is the total paid revenue vs outstanding orders? 
• What is the total number of returned/cancelled orders and lost revenue from them?

Products (Best Sellers)

• Which are the top 20% best selling products? (businesses love 80/20 comparisons and if you look at reports a lot, you will too)
• Which are the products that our best customers keep …

I’m happy to announce that the recording for my recent webinar “5 Proactive Measures to Minimize MySQL Downtime” is now available, along with the slides. They can both be found here.

My webinar focused on the top 5 operational measures that prevent or reduce downtime — along with the related business impact in a significant number of customer emergency scenarios.

As a senior consultant on Percona’s 24×7 Emergency Consulting team, I’ve helped resolve a …