On Mon, Oct 12, 2009 at 11:55 AM, JimCifarelli <[email protected]> wrote:
> I have not decided between MySQL or Postgres. It sounds like > DB Replication is a must in developing a good practice for a safe > migration to new servers? I would think if there's the possibility of users continuing to hit the old system for some time -- and I've seen just ridiculously long DNS caching in the past -- that you would need something like a circular (master <-> master) replication to keep primary keys from getting reused. But that may depend on your ratio of writes to reads, etc. If this were my project, I would set up a comparable configuration with pair of test machines/VMWare instances and experiment with different DB replication types and timing. HTH, -- Hassan Schroeder ------------------------ [email protected] twitter: @hassan --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
