The problem is that I don't want to replicate everything. The way I understand it, and correct me if I am wrong b/c I have never set up master/slave replication in MySQL, every time there is a insert/update/delete to the database, it will replicate to the others automatically in real-time. I don't want this to happen, because I am running a script that updates 16 million rows and takes 20 hours to complete... replication would affect performance on the live slaves. In parallel to this script running I am making live changes to the data in my app via a web interface. These changes (small portion compared to the script running) will need to write to all 4 databases at the same time. I am assuming mysql replication is all or none and can't do this... meaning replicate some times and not others?? -- Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
