Replication 1

[whosrdaddy]

Hi,

I have 2 MySQL servers (windows environmment).
I want to setup one way replication between them; Server B must contain the same data as Server A, but if change data on Server B, this change may not be propagated to server A.
Is this possible and how do I proceed?

Thanks,
Daddy


-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[hvass]

Yes possible this does sound like standard replcation covered in detail at

http://dev.mysql.com/doc/refman/5.0/en/replication.html

Classically you would not make any changes to data on the slave you would update/insert/delete only on the master... but there is nothing to stop you just updating the slave that I know of ... obviously you need to be very careful that any changes on the slaves do not mess up any changes that might later come from the master.....
The obvious question is what are you trying to achieve? there may be a better way than replication....

 

[whosrdaddy]

I just want to create a "hot" standby server, in case the master server goes down.

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[hvass]

Yes that is straight replication out of the manual.

 

[whosrdaddy]

Thanks for the info!

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!