i dont know if this might be useful to ppl here, but this is a very good knowledge for serious siteadmins.

while i was digging for mysql backup techniques, i've found that mysql is able to do realtime replication. the idea is that there are master server and slave server. both are having the same version of mysql installed. the data flows;

Master >copy> Slave ( in realtime!)

you'll never have to manually copy the database file of wasting your time to manually use the mysqldump command. here are the links;

http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html

http://www.megalinux.net/archives/000170.html

hope it can be usefull.

I've been using MySQL for ages now and never knew about this! Great tip!

a little confused....but maybe i can get it later after finish my reading

This might be useful for me. Thanks for the info.

Excellent Post, Thanks so much
MySQL Realtime Replication

Exactly what I was Googling for. I have a Gameserver running on MySQL and I need redundancy and the ability to switch servers without the games being interrupted. This will no doubt be needed by countless other developers out there and should be a selling point for MySQL

-reply by George Molson

I try to upgrade my MySQL server from 4.018 to 4.1.10a. Firstly, I downloaded mysql-4.1.10a (not the essential one) for win XP Then I install the new version after the old version was uninstalled. After the installation process, Instance Configurator comes up to help for the ...more

How can I make data Replication in MySQL??, I'm making a web based software that's going to be used in 5 different drugstores of the same company, how can I make it so all 5 stablishments see the same data in real time?? is that possible? all 5 drugstores are in the same city but not so near ...more

Hi all, I was having 2 SQL 2000 Servers and I have enabled snapshot replication. Its working fine without any issues. Now I have upgraded one MS SQL 2000 to MS SQL 2005. Is it possible to replicate the data in SQL 2000 to SQL 2005. If possible, how can I do that? ...more