Facebook released a kernel module called Flashcache this wednesday, which is used to speed up MySQL by caching data in faster media like SSD disks.  It’s only tested for kernel versions 2.6.18 and 2.6.20.

If you have binary logging enabled on your MySQL server (i.e. the log-bin parameter is set in the config file), then you may notice a bulk of large files in the MySQL data directory over time. Generally you only need to enable this binary logging if your server is acting as a relication master or if [...]

How can I change user password under MySQL server when I lost my password? Here’s I’ll show two examples. The first example is about how to change password for normal user using Linux command line option, and the second example is on how to reset MySQL DBA password (By default, this user [...]

Cassandra is an open source distributed database management system. It was initially developed by Facebook for storing very large amounts of data. Jeff Hammerbacher, who led the Facebook Data team at the time, has described Cassandra as a BigTable data model running on a Amazon Dynamo-like infrastructure.

Let’s keep this post smart. It’s intended to help you rebuild a crashed MySQL replication. We assume that bin-log has been enabled at the master side. Basically what you need to do is to retrival a snapshot of your master database. It covers three types of information, a snapshot of your [...]

The 13th international workshop on HPTS held at October 25-28, 2009, Pacific Grove, CA. It’s all about real systems problems for real systems builders! The papers are listed at its official website. These papers are really really very informative, it’s suggested to have a read! Every two [...]

This post is originally created by Baron Schwartz at MPB (A.k.a. MySQLPerformanceBlog.com) days ago. What follows is not a realistic benchmark, it’s not scientific, it’s just some quick and dirty tinkering. Baron threw up an Ubuntu 9.04 small server on Amazon. (Because there’s a .deb [...]

What follows for the next few posts is a somewhat edited version of a set of advice I am giving to a Sun team on redesigning a C++ application which was built for MySQL, ported to PostgreSQL, and never performance optimized. It occurred to me that this advice would be generally useful to the community, [...]

If you set up MySQL replication, you probably have ever faced this problem. there are invalid MySQL queries which cause the replication not to work anymore. Here I’ll explain how you can repair the replication on MySQL slave without rebuilding the whole repication environment. There are two steps [...]

MySQLPerformanceBlog has issue “Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM.