MYsql replication questions.
Have a question about replication. I read this statement on MYsql's website:
"•Data security - because data is replicated to the slave, and the slave can pause the replication process, it is possible to run backup services on the slave without corrupting the corresponding master data. "
Question 1: Does this mean everytime a backup script is run in ispconfig 2 there is a chance I could corrupt my databases? Is it a minute possiblity or is it fairly common?
Question 2: I found a few different replication tutorials on HowToForge, one covering master-slave and one covering master-master. Is a master-master vulnerable to the same corruption? Is a master-slave scenario safer all the way around?
Question 3: In falko's tutorial "http://www.howtoforge.com/mysql5_master_master_replication_debian_etch" he mentions:
"The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master"
Does this mean if I use a master-slave replication I have to tell ISPConfig 2 to only wrtite to the master or something like that?
Thanks as always folks,
Last edited by scottrill2; 18th August 2010 at 04:13.
Reason: Had another question.