Raffi Krikorian, VP Platform Engineering at Twitter, blogged about Twitter's New Tweets per second record and how they achieved it:

"Recently, something remarkable happened on Twitter: On Saturday, August 3 in Japan, people watched an airing of Castle in the Sky, and at one moment they took to Twitter so much that we hit a one-second peak of 143,199 Tweets per second...To give you some context of how that compares to typical numbers, we normally take in more than 500 million Tweets a day which means about 5,700 Tweets a second, on average. This particular spike was around 25 times greater than our steady state."

Read the blog to …

We receive this question about the ibdata1 file in MySQL very often in Percona Support.

The panic starts when the monitoring server sends an alert about the storage of the MySQL server – saying that the disk is about to get filled.

After some research you realize that most of the disk space is used by the InnoDB’s shared tablespace ibdata1. You have innodb_file_per_table enabled, so the question is:

What is stored in ibdata1?

When you have innodb_file_per_table enabled, the tables are stored in their own tablespace but the shared tablespace is still used to store other InnoDB’s internal …

One thing you might have missed from the MariaDB 10.0.4 Alpha release announcement is that SPIDER is finally in-tree, inside MariaDB. I’ve been watching the SPIDER engine for quite some years and fondly remember the time when Kentoku Shiba dressed up as spiderman at a MySQL Conference.

There are many factors that plays to an engines success. Distribution is one of them. Having a company backing it with services is another, so it is with great pleasure that I also show you Spiral Arms Ltd by Kentoku and Goto.

Overall, a good time to celebrate and I’m very happy for Kentoku and Goto. Now to promote its use. …

Hey all!

Coming up this Wednesday, August 21st, 2013 at 12:00pm pacific (19:00 GMT) join in to talk about:

• Gerry from Tokutek to talk about B-Tree indexes in InnoDB and fractal indexes TokuDB!
• Schema Versioning
  • How do you manage schema versions in your development pipeline?
  • How are your schema changes deployed? Is it automated?
  • Some automated schema management tools:
    • South -- http://south.aeracode.org/ -- a DJango (python) friendly migration tool
    • Flyway -- http://flywaydb.org/ -- A database migration framework for java
    • Liquibase -- …

MySQL is the number one IT skill demanded for Linux related jobs and continues to grow in importance according to the Linux Careers IT Skills Watch update 2013. So boost your career with the authentic MySQL Curriculum.

During the top selling course, the MySQL for Database Administrator, you will learn to install MySQL products, partition data, check and repair tables, perform backups and configure replication, create secured users and enable SSL security, and much more.

You can take this instructor-led course as a:

• Live-virtual event: Take this course from your own …

Warning: this is a mixture of historical content, biases, stupid marketing and unknown/proprietary/closed source technologies. Proceed with caution.

NuoDB marketing was sending out this message, encouraging me to blog (they were looking for bloggers too):

And while Facebook sharded MySQL 4000 times, even they call it a “fate worse than death.”

We’ve seen this phrase before and it did not come from us. For whatever reason NewSQL echo chamber is repeating this with less and less truth in it. In various whitepapers (all behind registration walls) they mention some analyst estimates and try to put a parallel between operating costs of large companies and something a new developer would do, as if everyone is living under same constraints.

I don’t know if NuoDB is a good technology for the customer they’re targeting, all their diagrams essentially …

I’ll be joining Percona for a free day of MySQL education and insight at their upcoming Percona University Washington DC event on September 12th. My topic is accessing MySQL from Google’s Go programming language. I’ve learned a lot about this over the past year or so, and hopefully I can help you get a quick-start.

If you’re not familiar with Go, it’s the darling of the Hacker News crowd these days. Anything with “Go” in its title gets to the front page for at least a little while! Go is a great systems programming language. It’s safe to say I’ve fallen in love with it, and it’s now my favorite programming language of all those I’ve used over my entire career. I chose it because it’s ideally suited for VividCortex’s agent programs (zero dependencies, compiled, lightweight, high performance, robust, makes concurrency …

Giuseppe Maxia has long been a leader of the MySQL Community and is going to be a presenter at MySQL Connect. It is hard to list everything he has done for MySQL (and harder to try to find something he has not done).

What are your speaking about at your session?
a) MySQL in a laptop, or how to test and run database servers in a single box
b) juggling your data with Tungsten replicator, or the joys of complex topologies at your fingertips.

Who would benefit most from attending your session?
DBAs, testers, database designers, application designers

What other sessions would you recommend or are planning to attend?
MySQL Replication Roadmap [CON2615]
MySQL Replication: Deep Dive into GTIDs for Scaling and High Availability [CON2610]
Big Data with MySQL and Hadoop [CON2342]
…

I’ll be joining Percona for a free day of MySQL education and insight at their upcoming Percona University Washington DC event on September 12th. My topic is accessing MySQL from Google’s Go programming language. I’ve learned a lot about this over the past year or so, and hopefully I can help you get a quick-start. If you’re not familiar with Go, it’s the darling of the Hacker News crowd these days.

MySQL 5.6 surely changes the game when it comes to security vs ease of use. Before MySQL 5.6 we would get default MySQL installation being pretty insecure – the user “root” will be created with no password as well as anonymous user with limited access from local host (though still enough to cause DOS attack or crash MySQL Server.

There were some exception to this rule – such as Debian/Ubuntu install scripts would interactively suggest you to set password for root user if it was not set. Still most users would get MySQL install with root account and no password.

This is not the case with MySQL 5.6 when you’re doing fresh MySQL install! Installing official RPM on CentOS6 I’m getting this:

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.
You must …