MySQL Realtime Replication how to replicate mysql in realtime

	MySQL Realtime Replication - how to replicate mysql in realtime
	Discussion by wanhafizi with 4 Replies. Last Update: August 28, 2008, 4:53 am

wanhafizi

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.

Thu Jan 6, 2005 Reply New Discussion

FeedBacker

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

Wed Dec 12, 2007 Reply New Discussion

orzorz

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

Wed Jan 2, 2008 Reply New Discussion

cybernaut

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

Sat Feb 16, 2008 Reply New Discussion

iGuest-George Molson

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

Thu Aug 28, 2008 Reply New Discussion