-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
hi,
the new s2 server (daphne) is online, and should have caught up with replication later today. however, it is using a new MySQL build (version 5.1.35), which contains a critical InnoDB bug causing server crashes when innodb_locks_unsafe_for_binlog is enabled. since we need this option to support long queries, we won't switch servers until a patch is available. (this is a new bug, unrelated to the previous one.) i hope this will happen later this week.
when we switch, user databases currently on the s2 server will _not_ be moved, and the 'sql' alias will continue to point at the old server (zedler). therefore, if you have created tables on the old server which you need to join to s2 databases, you will need to move these to the new server yourself. do not move normal user databases, they should remain on 'sql' as before.
- river.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
River Tarnell:
it is using a new MySQL build (version 5.1.35), which contains a critical InnoDB bug causing server crashes
this problem seems to be fixed now; we will switch over to the new server later this week. if you haven't yet moved any databases to the new server which need to be moved, you should start doing so now.
if necessarily, you can temporarily change 'sql-s2' to 'daphne' in your tools to force use of the new server; however, you must revert this once the change is complete.
- river.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
River Tarnell:
we will switch over to the new server later this week.
sql-s2 is now pointing to the new server.
- river.
River Tarnell wrote:
sql-s2 is now pointing to the new server.
I assume this is why my weekly MIME type statistics query for Commons has suddenly sped up by a factor of 100 (from around 20 minutes in the past to 10 seconds today)?
Anyway, thanks. And WOW! :)
(Ref: http://toolserver.org/~vyznev/commons_mime_statistics_log.txt)
toolserver-l@lists.wikimedia.org