A week ago we launched our first GA release of Percona Server 5.6 and it’s a real game-changer for us. The release of Percona Server 5.6 (our enhanced, drop-in replacement for MySQL) not only provides stability and performance but also provides key features only available in Oracle’s MySQL 5.6 Enterprise Edition. As usual, Percona Server 5.6 is 100 percent Free and Open Source Software.

On Oct. 16 I’ll lead a webinar that will present what’s new in Percona Server 5.6 that makes it the most powerful, highest performance, and most manageable free version of MySQL available today. The one-hour webinar starts at 1 p.m. Pacific time Wednesday. You can register here. …

MySQL Server 5.6 has seen fast adoption - the list of performance improvements and features make a convincing argument all on their own.

Join those adopting the MySQL database by taking the MySQL for Database Administrators training course.

This 5-day course teaches you all the core dba skills including what MySQL Server 5.6 brings you in terms of Replication. You will learn about:

• Managing the MySQL Binary Log
• MySQL replication threads and files
• Using MySQL Utilities for Replication
• Designing Complex Replication Topologies
• Multi-Master and Circular Replication
…

MySQL is one of the most famous Open Source Relational Database Management System (RDBMS) created by Michael Widenius. Default choice in systems as WordPress and used by top companies as Google and Wikipedia. Due its simplicity and large community, it is largely used by developers and webmasters around the world. MySQL is under dual license: […]

#DBHangOps 10/16/13 -- Resource Management, Compliance, and more

This weeks #DBHangOps is a wrap. Check out the recording below:

Hello everyone!

This Wednesday, October 16th, 2013 at 12:00pm pacific (19:00 GMT), #DBHangOps is coming up with discussion on:

• How do you constrain over-consumption of resources by competing applications?

• Network vs. Local storage for MySQL

  • How do you use this for HA? Do you use DRBD or floating VIPs?

• Secure connections to MySQL (using SSL) (requested by Daniel)

  • Do you have experience with this? What's the performance impact?
• PCI Certification with MySQL -- what changed for you?

• MySQL-isms!

  • (From Gerry) Sub SELECTs -- Why aren't these as mature as …

[ This is a quick post for my french followers about DBHangOpsFr ]

I’m sure you heard about DBHangOps, the famous virtual DBA meeting launched by Geoffrey Anderson from Box.net.
But did you know that some talented and passionate frenchies have launched DBHangOpsFr a few month ago?

DBHangOpsFr is THE virtual french DBA meeting you would love to attend.
I invite you to visit this page for more details : http://www.mysqlplus.fr/category/dbhangopsfr/

The next session will take place in November, follow me on twitter, looking for …

TSA Method in class (SmartOS)

There are two basic performance analysis methodologies you can use for most performance issues. The first is the resource-oriented USE Method, which provides a checklist for identifying common bottlenecks and errors. The second is the thread-oriented TSA Method, for identifying issues causing poor thread performance. I summarized the TSA Method in my Stop The Guessing talk at Velocity conf this year, and it is also covered in the Applications chapter of my Systems …

Since introducing TokuMX, we’ve discussed benefits that TokuMX has for existing MongoDB applications that require no changes. In this post, I introduce an extension we’ve made to the indexing API: clustering indexes, a tool that can tremendously improve query performance. If I were to speak to someone about clustering indexes, I think the conversation could go something like this…

What is a Clustering Index?

A clustering index is an index that stores the entire document, not just the defined key.

A common example is …

This week we discuss features of Percona Server 5.6 compared to MySQL 5.6. Ear Candy is about pt-upgrade, and At the Movies is a set of lightning talks.

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center

Training
SkySQL Trainings

read more

Extreme performance is the key to excellence. One example of it is the winning of 34th America Cup by Team Oracle USA, another example is the Pythian’s legendary love of  data, and this Log Buffer edition loves the blogs again, as it does weekly.

Oracle:

The 10 commandments of being a good DBA manager.

Oracle ADF Mobile #{row.index} is Not Supported After Installing Upgrade Patch

With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is restarted.

The …

Percona is glad to announce the release of Percona Monitoring Plugins 1.0.5 for MySQL. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.

Changelog:

* Added mysql-ca option to ss_get_mysql_stats.php (bug 1213857)
* Added user info to the idle_blocker_duration check of pmp-check-mysql-innodb (bug 1215317)
* Extended pmp-check-mysql-processlist with more locking states (bug 1213859)
* ss_get_mysql_stats.php did not work with custom mysql port (bug 1213862)
* ss_get_mysql_stats.php silently failed when a query returns too many rows (bug 1225070)
* Wrong description of percona-cacti-templates deb package (bug 1217782)

A new tarball is available from …