MySQL Master-Master Replication…

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 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.

November 16th, 2007 When you try MySQL master-master replication with two (or more) servers you may often find that in the process of configuring the original master to also act as a slave server (start slave), it fails with the following error: mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO To rectify it locate and delete the master.info file and restart the mysql server. Now try to start slave and it should work.

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.

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.

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.

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.

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.

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.

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.

January 17th, 2009 MySQL stores usernames and passwords in the user table inside the MySQL database. You can directly update a password using the following method to update or change passwords: 1) Login to the MySQL server, type the following command at the shell prompt: $ mysql -u root -p 2) Use the mysql database (type commands at the mysql> prompt): mysql> use mysql; 3) Change password for a user: mysql> update user set password=PASSWORD("newpass") where User='YOUR-USER-NAME'; 4) Reload privileges: mysql> flush privileges; mysql> quit [P.S.

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...

May 12th, 2007 Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux.

January 13th, 2009 Let's face the fact. Firefox has made our internet experience a lot easier.

May 13th, 2005 Note: My WordPress database name is wordpress. I will use it in the example below.