Solution: MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master

November 18th, 2007 Replicating on two or more MySQL master database servers 1. MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master 2.

September 2nd, 2007 Have you tried Master-Master replication (bi-directional slave-master replication) for MySQL? I am finding myself in a position where I need to have this replication to support the load on my blogs and sites. I would very much appreciate if you can share your experience & suggestions with master-master replication of MySQL database.

September 1st, 2007 Working with replication systems is not easy. Learning and testing different kind of MySQL replications and fine-tuning it to your specific needs is a time-consuming endeavor.

January 14th, 2009 It happened to me just the other day. Someone deliberately got into my Firefox, cracked my login information from security options and surfed to my password secured websites at glory.

September 24th, 2007 I have significantly improved our site performance in the last month. I did all the site optimization steps by the book, found a lot of new things and fine-tuned existing ideas.

November 25th, 2008 The MySQL Query Analyzer tool monitors query performance and quickly pinpoints and corrects problems in SQL code. It promises to "turbo-boost" the speed and uptime of MySQL database applications.

March 18th, 2008 In Linux you can use the dd command to copy MBR from one hard disk to another. You can also use dd to backup your master boot record to a different (or same) media.

August 13th, 2008 I mean every word of it. I found this simple configuration tip after days of continuously looking at MySQL logs (mytop), top, slow log queries, debugging the hell out of applications, reading tons of MySQL optimization tips (and pulling my remaining hairs in frustration) on the web.

February 26th, 2009 Everyone and their dog talks about WordPress performance these days and also tells you how to scale WordPress (Read: How to really scale WordPress). When I grew up in Kharagpur (yes, the same Kharagpur which has the top IIT and yes I did my B.Tech there) everyone knew how to cure diabetes - you have to walk a lot, stop eating sweets, eat / drink varying concoction of Neem leaves and / or Nayantara leaves and / or Jamun fruit or seed and presto you are cured of diabetes.

July 13th, 2007 This is a very interesting presentation (see below) on the technologies used to make Digg, the challenges faced along the way and how they overcame it. I would recommend it to any Web 2.0 startup architects.

June 1st, 2006 The common symptom of the problem is that Apache web server suddenly fails to load as a service (on windows) or even from command line. The error message from log is as follows: FATAL: emalloc(): Unable to allocate -2103443420 bytes [Thu Jun 01 23:57:21 2006] [crit] master_main: create child process failed.

January 31st, 2009 As you may be aware, if you are following my tweets, that we are testing a highly scalable WordPress delivery platform, which can serve over 10000 requests per second from a single server and handle over 20000 concurrent requests without failure. Sounds amazing? then read on...

January 17th, 2009 Do you get this error message when you try to change the root password? mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' Or may be you need to change the MySQL password for other users. So what do you do then? To change a normal user password you need to type: $ mysqladmin -u user-name -p oldpassword newpass

July 24th, 2007 A much dreaded MySQL error message during queries is "MySQL server has gone away". An alternative message is "Lost connection to server during query".

October 16th, 2008 Postgresql command line interface psql presents a stumbling block to any mysql users. Try running psql on command line and you will get a nice and unfriendly error message: FATAL:  database "root" does not exist Most MySQL users face this problem initially with Postgresql because Postgresql works differently.