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 […]