On 11/11/12 17:37, DaB. wrote:
I will switch sql-s1-user to read-only at
tomorrow, Monday after 20:05 UTC
and than dump the user-databases (and import them on thyme). I do not know how long this will take, but I guess the hole European night. When the import is done somewhen on Tuesday I will switch sql-s1-user to thyme and switch it to read/write. Later (or in parallel to the user-database-dumping, not sure yet) Nosy or I will dump commons from rosemary too for a later re-import. When everything is dumped and imported I will re-setup rosemary with the fresh dump too.
Sincerely, DaB.
Remember that there is a trick where you dump the user-databases with the binlog enabled (and noting its position), leaving the database writable. You then transfer and import the dump. Finally you make it readonly, copy the changes from the binlog (which will be much smaller and thus results in a shorter read-only interval) and point the dns to the other server.
Regards