From http://dev.mysql.com/doc/refman/5.5/en/purge-binary-logs.html:

"You can also set the expire_logs_days system variable to expire binary log files automatically after a given number of days... you should set the variable no lower than the maximum number of days your slaves might lag behind the master."

Most DBAs probably don't have to think about binary logs all that much (assuming the option is enabled).  As comically inadequate as that advice from dev.mysql.com is, most users can get away with it unless two or more of the following are true about their production environment:

• Lots of mysqld servers.  I mean A LOT
…

From http://dev.mysql.com/doc/refman/5.5/en/purge-binary-logs.html:

"You can also set the expire_logs_days system variable to expire binary log files automatically after a given number of days... you should set the variable no lower than the maximum number of days your slaves might lag behind the master."

Most DBAs probably don't have to think about binary logs all that much (assuming the option is enabled).  As comically inadequate as that advice from dev.mysql.com is, most users can get away with it …

LGPL release of MariaDB connectors opens up new possibilities for application developers

As I said last month, SkySQL has the goal of being THE provider of valuable, performance-enhancing and revenue-generating solutions for the 15 million users of open source MySQL and MariaDB databases in enterprise and cloud computing. 

read more

Tired of the same old holiday tunes year after year? Join us as we Rock around the Fractal Tree here at Tokutek.

We’ve fiddled with the chorus; won’t you join us?

Rockin’ around the Fractal Tree
(sung to the tune of Rockin’ around the Christmas Tree)

Rockin’ around the Fractal Tree
As the bits begin to hop
Leaves are full on trees that are not B
Our indexes cannot be stopped

Rockin’ around the Fractal Tree
Let the MySQL spirit ring
Time to compress all into an SSD
And watch out for the Merciless Ming

You will get a sensational feeling when you hear voices singing
“No, not a fable; online changes done with alter table!”
Rockin’ around the Fractal Tree
Have a happy holiday
Everyone’s coding …

Oracle have just announced that MySQL Cluster Manager 1.2 is Generally Available. For anyone not familiar with MySQL Cluster Manager – it’s a command-line management tool that makes it simpler and safer to manage your MySQL Cluster deployment – use it to create, configure, start, stop, upgrade…. your cluster.

So what has changed since MCM 1.1 was released?

The first thing is that a lot of work has happened under the covers and it’s now faster, more robust and can manage larger clusters. Feature-wise you get the following (note that a couple of these were released early as part of post-GA versions of MCM 1.1):

• Automation of on-line backup and restore
• Single command to start MCM and a single-host Cluster …

With data volumes exploding, it is vital to be able to ingest and query data at high speed. For this reason, MySQL has implemented NoSQL interfaces directly to the InnoDB and MySQL Cluster (NDB) storage engines, which bypass the SQL layer completely. Without SQL parsing and optimization, Key-Value data can be written directly to MySQL tables up to 9x faster, while maintaining ACID guarantees.

In addition, users can continue to run complex queries with SQL across the same data set, providing real-time analytics to the business or anonymizing sensitive data before loading to big data platforms such as Hadoop, while still maintaining all of the advantages of their existing relational database infrastructure.

This and more is discussed in the latest Guide to MySQL and …

One of my favorite performance improvements in 5.6 is "faster non-persistent connections". I couldn't find this information from release notes, but non-persistent connection is really faster in 5.6.

Here are sysbench micro-benchmark results. I tested from 100 concurrent clients, running remotely. Clients simply connected and disconnected repeatedly.

On December 19th at 1 PM Eastern / 10 AM Pacific, I will be giving a
webinar entitled “10 Percona Toolkit Tools Every MySQL DBA Should Know
About”.

As a Consultant, I make heavy use of Percona Toolkit tools while
solving customers’ problems, and I have used this experience to select
what I consider to be the top 10 tools everyone working with MySQL
should know about. I will present each of the selected tools using
examples based on real-world cases.

You can sign up by clicking the “Register” button here. Hope to see
you next week!

Today, the explosion in content creation is more than ever before with its growing role in marketing strategy & analysis, tapping new opportunities and reaching new prospects. Now, the way content is generated for different platforms for better web experiences is, obviously, bringing new challenges for enterprises in terms of quick content delivery with proper quality, and at preferably lower cost. To be consistent with these challenges, everyday companies take new approaches. But, building websites with features that speed-up content delivery process, integrate seamlessly with third-party apps for content sharing, replicate content on several DBs to keep new content in sync, as well as give better capability to handle traffic surges… come with unique challenges. And when you work at bigger scale, the question of having a robust system do arises. If you are a non-tech savvy person, what irks you most in managing your website: coding new pages …

The MySQL Community continues its good work in testing and refining MySQL 5.6, and as such the next iteration of the 5.6 Release Candidate is now available for download.  You can get MySQL 5.6.9 here (look under the "Development Releases" tab).  This version is the result of feedback we have gotten since MySQL 5.6.7 was announced at MySQL Connect in late September. As iron sharpens iron, Community feedback sharpens the quality and performance of MySQL so please download 5.6.9 and let us know how we can improve it as we move toward the production-ready product release in early 2013.

MySQL 5.6 is designed to meet the agility demands of the next generation of web apps and services and includes across the board improvements to the …