|
|
MySQL Realtime Replication - how to replicate mysql in realtime | ||
Discussion by wanhafizi with 4 Replies.
Last Update: August 28, 2008, 4:53 am | |||
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.
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
I've been using MySQL for ages now and never knew about this! Great tip!
Wed Dec 12, 2007 Reply New Discussion
a little confused....but maybe i can get it later after finish my reading
Wed Jan 2, 2008 Reply New Discussion
This might be useful for me. Thanks for the info.
Sat Feb 16, 2008 Reply New Discussion
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
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
MySQL what is mysql (1)
|
(1) MySQL Cluster
|
Index




