Using MySQL as a NoSQL – A story for exceeding 750,000 qps on a commodity server

This article describe an example of using MySQL as a NoSQL in which the application can exceed 750,000 qps on a commodity server. This is originated from UPDATE: Oracle officially released memcached daemon plugin that talks with InnoDB. I’m glad to see that NoSQL+MySQL has become an official solution. It’s still preview release […]

MySQL Replication :: Recovering from corrupted relay logs

Recently, due to a unknown problem, mysql replication in our server was stopped. Checking the log, we found the following error 130225 21:17:32 [ERROR] Error in Log_event::read_log_event(): ‘read error’, data_len: 261, event_type: 2 130225 21:17:32 [ERROR] Error reading relay log event: slave SQL thread aborted because of I/O error 130225 […]

Host ‘yourhost’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’

When there are many errors when connecting to a mysql server, the following error might appear and the application cannot connect to the db server any more: Host ‘yourhost’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ The above error might appear when the application server and […]

MySQL Replication :: Migrate master database to another server/host

In a MySQL Replication based system, How to migrate a master database to another server/host? Scenario in short goes: dump out master databases, import data on the new master server and point slave to the new master server. If you follow this simple steps, master migration should proceed without problems. Export databases from […]

MySQL Engines: InnoDB and MyISAM – A Comparison of Pros and Cons

The 2 major types of table storage engines for MySQL databases are InnoDB and MyISAM. To summarize the differences of features and performance: InnoDB is newer while MyISAM is older. InnoDB is more complex while MyISAM issimpler. InnoDB is more strict in data integrity while MyISAM is loose. InnoDB implements row-level lock for inserting and updating […]

[News] – Twitter, PayPal reveal database performance

This excellent article talks about database performance on very big system at Twitter and Paypal. The article is originated from Driving big performance using MySQL Engineers at Twitter, Paypal have joined Facebook in offering a look under the hood of the massive MySQL deployments that drive their web services. Database […]