Posted by joseph on August 25, 2012 ·
Well, this is just a forwarded version from Xaprb.com, the highlighted points are a good summary. I don’t fully understands all the germs till now. The manual page is worth a careful read if you want to know more details.
Posted by joseph on February 18, 2012 ·
Supposed you have a table that being updated by MySQL triggers and the DB is a master of replication, how do the triggers act in the environment? Here we might have a list of questions:
Q1, Will the definition sql of the triggers be replicated?
Q2, Will the data manipulation sqls triggered by triggers [...]
Posted by joseph on July 29, 2011 ·
MySQL 5.5.15 GA has been released in 28 July 2011.
Functionality Added or Changed
The undocumented –all option for perror is deprecated and will be removed in MySQL 5.6.
InnoDB Storage Engine: A failed CREATE INDEX operation for an InnoDB table could result in some memory being [...]
Posted by joseph on January 21, 2011 ·
By default, MongoDB does not supply any auto start/stop scripts for instance management. Here we’ll share a smart script to do so. It’s tested OK on ubuntu servers, and should work on Debian too. All you need to do are two steps:
1, Create a configuration file for MongDB, which is located [...]
Posted by joseph on April 30, 2010 ·
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.
Posted by joseph on March 9, 2010 ·
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 [...]
Posted by joseph on January 1, 2010 ·
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 [...]
Posted by joseph on December 11, 2009 ·
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.
Posted by joseph on November 27, 2009 ·
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 [...]
Posted by joseph on November 25, 2009 ·
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 [...]