MySQL Realtime Replication how to replicate mysql in realtime

[whafizi 0]

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://forums.xisto.com/no_longer_exists/

 

http://forums.xisto.com/no_longer_exists/

 

hope it can be usefull.

[iGuest 3]

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

[orzorz 0]

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

[cybernaut 0]

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

[iGuest 3]

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