MySQL Master-Master Replication...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.
Solution: MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on MasterNovember 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.
6 MySQL Database Replication TipsNovember 18th, 2007 Replicating on two or more MySQL master database servers
1. MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master
2.
Sun Restricts MySQL Query Analyzer Tool To Gold Subscribers OnlyNovember 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.
How to Reset Master Password in Firefox in Case You Have Forgotten itJanuary 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.
Improving Site Performance...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.
One MySQL Configuration Tip That Can Dramatically Improve MySQL PerformanceAugust 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.
How To Copy Master Boot Record (MBR) Between Hard DisksMarch 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.
WordPress Scaling & Performance - A Picture Which Speaks Thousand Words and MoreFebruary 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.
Digg: Technologies Used & Challenges FacedJuly 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.
Notes on a highly scalable WordPress Delivery Platform - Over 10K live requests / second, 20K concurrent connectionsJanuary 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...
Two Points To Remember Before You Trust Firefox FullyJanuary 13th, 2009 Let's face the fact. Firefox has made our internet experience a lot easier.
Desperate Spammers Do Bible ThumpingJuly 17th, 2007 A spammer finally resorted to heavy quoting of scriptures from Bible just to get in his comments and a heavy one at that. But there's more much more.
How to Recover MySQL Root PasswordJanuary 17th, 2009 Do you want to recover the MySQL root password. its by no means, easy.
How to Update or Change Password for a Single User in MySQL and Reload PrivilegesJanuary 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.
2 Comments | 
Email this Article
Loading ...
February 27th, 2009 at 4:04 pm
[...] multiple MySQL instances in a master-slave ( as WordPress.con does ) or master-master replication (notes). Interestingly, despite our heavy and ever increasing traffic, we managed to avoid [...]
October 23rd, 2009 at 12:37 am
We provide the best-suited web hosting services according to the requirement of customer’s need. For the nascent one, who doesn’t know much about the top 10 web hosting services, we not only make aware to him/her but also provide the best-packaged service close to customer’s needs.