Sun Restricts MySQL Query Analyzer Tool To Gold Subscribers Only

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. One software developers reported it tripled his performance.

Full article (173 words) »

6 MySQL Database Replication Tips

Replicating on two or more MySQL master database servers

1. MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master

Full article (112 words) »

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

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

Full article (97 words) »

Improving Site Performance…

Site UptimeI 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. There are a couple of good ideas I am yet to implement like using Lighttpd server instead of Apache 2.

Full article (184 words) »

How To Test Master-Master / Master-Slave / Standard / Circular Replication on MySQL

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. Also you need to have several MySQL servers at your disposal. To overcome these limitations, Stardata created a MySQL 5 Replication Playground, a painless installation of 4 replicating nodes in one server, using MySQL 5.

Full article (176 words) »
Protected by Comment Guard Pro