Hello all,
I will switch sql-s1-rr from thyme to rosemary and back after
19:00 UTC this evening.
You should notice no difference, but everything at sql-s1 will be a little bit slower while sql-s1-rr is on rosemary (and all queries running on thyme will be killed). The background of the switches is that I finally extracted the mysql-files from the wmf-binary dump and so I can re-setup thyme now with an unbroken version of s1. If everything works as planed I will handle rosemary during the next week too, so the hole s1-cluster will be unbroken again.
Just to let you know.
Sincerely, DaB.
Hello all,
I just started the thyme with a fresh dump from the WMF. The import took longer than thought because some files had to decompressed first. I let it catch-up in replication for the next hours. The next steps are the following: 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.
Hello all, At Monday 12 November 2012 22:31:44 DaB. wrote:
I will switch sql-s1-user to read-only at
tomorrow, Monday after 20:05 UTC
this is postponed to unknown timestamp. We have problems to reach thyme since 14 o'clock. Looks like we will need a manually reboot there.
Sincerely, DaB.
At Monday 12 November 2012 22:37:52 DaB. wrote:
this is postponed to unknown timestamp.
on second thought: I postpone the hole thing to
tomorrow, Tuesday after 20:05 UTC.
Sincerely, DaB.
toolserver-announce@lists.wikimedia.org