… KEY UPDATE is very powerful but often forgotten MySQL feature. It was introduced in MySQL 4.1 but I still constantly see people… I like this feature big deal because it is designed in truly MySQL style – very efficient solution for freqent task while keeping… shows one more neat feature of MySQL – inet_aton and inet_ntoa functions which can convert IP address strings to integers and back…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…, changing data type, converting data to different character set – MySQL master-master replication especially …current active master) and db2 (standby master) in it. Precautions: Before applying any changes, …you must change application to use different IP for MySQL or ensure some load balancer/proxy…
Post: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
… go into the toilet. And when that happens, MySQL mysteriously stops letting users log in, and all kinds of chaos ensues. Worse…_resolve in your my.cnf file and restart MySQL. But before you do that, run the following command: mysql> SELECT user, host FROM mysql… need to be converted to use IP addresses, IP address wildcards, or ‘localhost’ or they won’t be able to log in after you…
