Hello all,
yesterday at highnoon the master-db-servers were switched because of an huge schema-update. Because we have only one cluster of db-servers at the moment we couldn't do the schema-update the same way like the foundation (the foundation stops one of their slaves, does the schema-update, waits, start it again, stops another slave, does the schema-update and so on until all slaves are updated, and declare one slave as new master, runs the schema-update on the old master = no downtime) and so it took several hours until the schema-update was done and we could switch to the new master-servers. I deleted the view on the logging-table during the update to speed the update up and killed several long-running queries too tonight. The update was finish before I wake-uped, and I just finished the masterswitch, restarted replication and recreated the logging-tables (see maintaince-log for details). So in a few hours everything should be normal again.
Happy Corpus Christi (it's an holiday here :)).
Sincerly, DaB.
Where could I read more on the huge schema-update? Mashiah
On Thu, Jun 11, 2009 at 5:25 PM, DaB. WP@daniel.baur4.info wrote:
Hello all,
yesterday at highnoon the master-db-servers were switched because of an huge schema-update. Because we have only one cluster of db-servers at the moment we couldn't do the schema-update the same way like the foundation (the foundation stops one of their slaves, does the schema-update, waits, start it again, stops another slave, does the schema-update and so on until all slaves are updated, and declare one slave as new master, runs the schema-update on the old master = no downtime) and so it took several hours until the schema-update was done and we could switch to the new master-servers. I deleted the view on the logging-table during the update to speed the update up and killed several long-running queries too tonight. The update was finish before I wake-uped, and I just finished the masterswitch, restarted replication and recreated the logging-tables (see maintaince-log for details). So in a few hours everything should be normal again.
Happy Corpus Christi (it's an holiday here :)).
Sincerly, DaB.
-- wp-blog.de
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/toolserver-l
On Fri, Jun 12, 2009 at 11:09 AM, Mashiah Davidsonmashiah.davidson@gmail.com wrote:
Where could I read more on the huge schema-update? Mashiah
On the WikiTech-l mailing list [1] and there is a breif overview of the sql files names on the wikitech wiki[2].
[1]. http://lists.wikimedia.org/pipermail/wikitech-l/2009-June/043344.html [2]. http://wikitech.wikimedia.org/view/Schema_changes
Hello, Am Friday 12 June 2009 03:09:12 schrieb Mashiah Davidson:
Where could I read more on the huge schema-update?
that's a good question. All I found was a email by Tim to the tech-ML that points to http://wikitech.wikimedia.org/view/Schema_changes. I personaly saw index-creations and index-alterations in the logging-table.
Mashiah
Sincerly, DaB.
P.S: No ToFu please.
toolserver-l@lists.wikimedia.org