Maybe some file-transfering magic can be done to add the index in the other dbs by copying it from rosemary?
Daniel Kinzler schrieb: > Hi all > > I have started adding the index on sql-s1-fast (rosemary) to see how long it > takes. I will probably do the other db servers tomorrow and/or on Wednesday. > > -- daniel > > Daniel Kinzler schrieb: >> Hi all >> >> In the next few days, I will be adding a new index to the globalimagelinks >> table >> in the commonswiki database. creating this index will take a couple of hours, >> and the table will be locked during that time. This also means that >> replication >> of the commonswiki database will stop for the time it takes to create the >> index, >> and may take some time to catch up again after is is finished. >> >> This task will be repeated for each database server, since commons is >> replicated >> to each. I will try to avoid doing it at peak times, but since I don't know >> yet >> how long it takes, and I should be around to watch it, I can't promise if it >> will work out that way. >> >> -- daniel _______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
