This sounds like the best idea yet :) I have a couple of questions:
- I need to keep the data in x_shadow while still creating table x.. will copying accomplish the same thing? I'm guessing it will be slower, but keeping the 'shadow' table around is important. - Will either / both of these (rename and copy) preserve indexes? Each table has ~5 indexes, and I don't want to reindex. Thanks for the ideas Ross On Wed, 2003-06-04 at 02:43, Martin Waite wrote: > Run a MySQL replication chain from stage to prod to replicas. > > On stage, prepare the data on shadow tables > with different names to those used in prod. > > Say, if your real tables are one, two, three, four, five > then create shadow tables one_shadow, two_shadow, three_shadow... > > Once the data is ready in the shadow tables, do a rename: > > rename table one to one_old, one_shadow to one, > two to two_old, two_shadow to two, ... > > Replication will apply the rename to all your replicas > and you should get a fairly snappy switchover. > > The only drawback is that you have two copies of your tables, > which might be impractical depending on the amount of data involved. > > regards, > Martin -- Ross Simpson <[EMAIL PROTECTED]> MapQuest.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]