Basically I want to setup a replication server for mysql datbase. I am completely new to this concept and appreciate any help pointing me in the right direction. If at all the slave goes down, will it effect the master in anyway?
Thanks.
A:
No, it will not affect the master if the slave goes down. The Slaves connect to the master and request the changes.
Rufinus
2010-03-31 09:23:29
I would appreciate any links for setting up this in windows
JPro
2010-03-31 09:25:33
http://www.google.at/search?q=mysql+replication+windows
Rufinus
2010-03-31 11:31:24
A:
If you intend on having 2 servers replicated, then you can use Master-Master replication. This means that either one of the database servers can go down without loss of data or access. This is extremely resilient to failure however you can get duplicate key errors on fast successive inserts, like using MySQL to handle sessions. This can be solved programatically through.
The downside of the Master-Slave set up is that if the master fails you have to manually assign another Master, fix the failed master and then bring back into the group. Otherwise failure of any or all Slaves will not affect the Master.
Giles Smith
2010-03-31 09:31:02