 MySQL Realtime Replication, how to replicate mysql in realtime |
|
|
|
|
  |
 Jan 6 2005, 03:30 PM
Post
#1
|
|
|
Advanced Member  Group: Members Posts: 145 Joined: 13-December 04 Member No.: 1,734  |
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. |
 |
 
|
|
Dec 12 2007, 06:03 AM
Post
#2
|
|
|
Newbie [ Level 1 ] Group: Members Posts: 0 Joined: 1-November 07 Member No.: 25,869 |
I've been using MySQL for ages now and never knew about this! Great tip!
|
|
|
|
|
Jan 2 2008, 12:23 AM
Post
#3
|
|
|
Newbie [ Level 1 ] Group: Members Posts: 1 Joined: 2-January 08 Member No.: 27,285 |
a little confused....but maybe i can get it later after finish my reading
|
|
|
|
|
Feb 16 2008, 03:01 AM
Post
#4
|
|
|
Newbie [ Level 2 ] Group: Members Posts: 14 Joined: 15-February 08 Member No.: 28,427 |
This might be useful for me. Thanks for the info.
|
|
|
|
|
Aug 28 2008, 04:53 AM
Post
#5
|
|
|
Newbie [ Level 1 ] Group: Members Posts: 0 Joined: 1-November 07 Member No.: 25,869 |
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 |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 5th December 2008 - 01:31 AM |