6 MySQL Database Replication Tips

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.

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.

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.

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

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.

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.

August 30th, 2008 Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL. Use mdbtools utilities as described below: mdb-tables displays the list of tables in MS Access mdb-scheme export the MS Access schema to MySQL database.

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.

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.

October 23rd, 2006 First of all I want to make it clear that having a MySQL database without a password set (on your root account) is a very very bad idea. However I wanted to set it up on my home machine which has XAMPP installed.

January 17th, 2009 Do you want to recover the MySQL root password. its by no means, easy.

April 27th, 2009 Suppose you want to change and enable the remote access to MySQL DB on your linux server (Debian). By default, you don't get such privileges so you will have to work your way through this.

June 12th, 2007 ANALYZE TABLE analyzes and stores the key distribution for a table. The MySQL query optimizer is the magic inside MySQL that decides which keys, if any, to use to in the query.

April 18th, 2008 I am serious. While MySQL is a great open source database, I have full respect to Sun's plan to provide high-end features for paying customers only.

September 3rd, 2009 Summary Box: EU applies brakes to Oracle-Sun dealSLOW DOWN: European Union regulators are launching a formal antitrust investigation into Oracle Corp.'s proposed $7.4 billion takeover of Sun Microsystems Inc. Oracle expected to complete the acquisition this summer, but European regulators now have until Jan.