Re: [Toolserver-l] Re-importing of several database clusters

2011-06-21 Thread Platonides
River Tarnell wrote:
> Hi,
>
> I'm about to re-import several database clusters from WMF: s3, s4, s6
> and s7.  This will be done on the secondary server first, so users won't
> be affected, except that queries on these clusters might be a bit slower
> for a while.
>
> This will resolve the following TS issues:
>
> TS-948 creating of rue.wiki
> TS-926 Cassia and hyacinth are missing the ruewiki-database
> TS-1013 metawiki Database seems to be corrupt
>
> And might resolve the following issues, although they don't provide
> enough information to be sure of the cause:
>
> TS-1024 cswikisource_p needs reimport
> TS-1048 cswiktionary_p needs reimport

cswikisource_p needs reimport is TS-1049, not TS-1024

Also related, TS-1074 (some data missing in s3)
https://jira.toolserver.org/browse/TS-1074

> This reimport might take longer than usual because I will be testing a
> new way of configuring database servers (which hopefully reduce database
> corruption in the future).

Do you know/suspect what caused the corruption? Trainwreck dropped some 
statements, perhaps?

Databases should er... -you know- store data without corrupting it :)

___
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: 
https://wiki.toolserver.org/view/Mailing_list_etiquette


[Toolserver-l] Re-importing of several database clusters

2011-06-21 Thread River Tarnell
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

I'm about to re-import several database clusters from WMF: s3, s4, s6 
and s7.  This will be done on the secondary server first, so users won't 
be affected, except that queries on these clusters might be a bit slower 
for a while.

This will resolve the following TS issues:

TS-948 creating of rue.wiki
TS-926 Cassia and hyacinth are missing the ruewiki-database
TS-1013 metawiki Database seems to be corrupt

And might resolve the following issues, although they don't provide 
enough information to be sure of the cause:

TS-1024 cswikisource_p needs reimport
TS-1048 cswiktionary_p needs reimport

This reimport might take longer than usual because I will be testing a 
new way of configuring database servers (which hopefully reduce database 
corruption in the future).

Once this is done, I'll switch user databases to the secondary server 
(during which they will be offline for a couple of hours), and then 
reimport the other server.

s1, s2 and s5 will be done later.

- river.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (SunOS)

iEYEARECAAYFAk4AxugACgkQIXd7fCuc5vIELACdF8k2zkgsakxSo6x+jyrySy2o
KEwAnigGCyqS8td/t7gcQT97wjAwAOvV
=citf
-END PGP SIGNATURE-

___
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: 
https://wiki.toolserver.org/view/Mailing_list_etiquette