Labswiki is now present in s6 (clouddb1015:3316, clouddb1019:3316, clouddb1021:3316).
The _p database and the grants for labsdbuser have been added.
Data has been sanitized.
The views can be created on those clouddb hosts.
Description
Description
Details
Details
Customize query in gerrit
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Duplicate | None | T237771 Make Wikitech a normal wiki | |||
| Duplicate | None | T237772 Move Wikitech's database off of M5 and onto a normal production wiki DB server | |||
| Declined | None | T171570 Rename database 'labswiki' to 'wikitechwiki' | |||
| Resolved | Milimetric | T217792 Add wikitech (labswiki) to the sqoop list | |||
| Restricted Task | |||||
| Resolved | Legoktm | T281515 June 2021 Datacenter switchover | |||
| Resolved | Marostegui | T285139 DB maintenance work to do while eqiad is passive (June 2021) | |||
| Open | None | T189531 All Wikimedia developer services should use single sign-on | |||
| In Progress | None | T161859 Make Wikitech an SUL wiki | |||
| Duplicate | None | T237773 Move Wikitech onto the production MW cluster | |||
| Resolved | Marostegui | T167973 Move database for wikitech (labswiki) to a main cluster section | |||
| Resolved | • Bstorm | T287442 Create views for labswiki (wikitech) |
Event Timeline
Comment Actions
I've had to cancel the script. It doesn't get recognized as an s6 wiki, probably because it isn't in noc.
Comment Actions
Change 711240 had a related patch set uploaded (by Bstorm; author: Bstorm):
[operations/puppet@production] wikireplicas: add labswiki manually to s6 and refactor a bit
Comment Actions
Change 711240 merged by Bstorm:
[operations/puppet@production] wikireplicas: add labswiki manually to s6 and refactor a bit
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2021-08-16T20:38:00Z] <bstorm@cumin1001> Added views for new wiki: labswiki T287442
Comment Actions
Change 713324 had a related patch set uploaded (by Bstorm; author: Bstorm):
[operations/puppet@production] wikireplicas: add CNAME for labswiki/wikitech
Comment Actions
Change 713324 merged by Bstorm:
[operations/puppet@production] wikireplicas: add CNAME for labswiki/wikitech
Comment Actions
Change 713486 had a related patch set uploaded (by Bstorm; author: Bstorm):
[operations/puppet@production] wikireplicas: add new manual config logic further down as well
Comment Actions
Change 713486 merged by Bstorm:
[operations/puppet@production] wikireplicas: add new manual config logic further down as well
Comment Actions
Ok, *now* it works with a nice mechanism that can be used for any other databases like this one.
MariaDB [labswiki_p]> select * from page limit 10; --------- ---------------- --------------------- ------------------- ------------------ ------------- ---------------- ---------------- ------------- ---------- -------------------- -------------------- ----------- | page_id | page_namespace | page_title | page_restrictions | page_is_redirect | page_is_new | page_random | page_touched | page_latest | page_len | page_content_model | page_links_updated | page_lang | --------- ---------------- --------------------- ------------------- ------------------ ------------- ---------------- ---------------- ------------- ---------- -------------------- -------------------- ----------- | 1 | 0 | Main_Page | | 0 | 0 | 0.372920469611 | 20210724211045 | 1919637 | 2682 | wikitext | 20210724211045 | NULL | | 3 | 8 | Sidebar | | 0 | 0 | 0.691730873296 | 20210219021958 | 1899374 | 551 | wikitext | 20210219021958 | NULL | | 5 | 10 | Nova_Resource | | 1 | 0 | 0.12773059768 | 20200707112405 | 1755766 | 35 | wikitext | 20170407231048 | NULL | | 91 | 4 | About | | 1 | 0 | 0.95119184283 | 20210724211210 | 1919638 | 22 | wikitext | 20210724211210 | NULL | | 120 | 2 | Eloquence | | 0 | 0 | 0.570383222492 | 20170509182007 | 129042 | 73 | NULL | 20170329084806 | NULL | | 149 | 10 | Border-radius | | 0 | 0 | 0.101410148771 | 20210224034902 | 306200 | 165 | wikitext | 20210302173442 | NULL | | 150 | 10 | Documentation | | 0 | 0 | 0.104208962479 | 20210302173252 | 1901246 | 1164 | wikitext | 20210302173428 | NULL | | 151 | 10 | Documentation/core | | 0 | 0 | 0.001265143328 | 20190728205214 | 102265 | 5621 | wikitext | 20170329084809 | NULL | | 152 | 10 | Documentation/core2 | | 0 | 0 | 0.900110482336 | 20170509182008 | 102266 | 936 | wikitext | 20170329084809 | NULL | | 159 | 10 | Fmbox | | 0 | 0 | 0.308471436621 | 20210224034902 | 102244 | 1367 | wikitext | 20210302173429 | NULL | --------- ---------------- --------------------- ------------------- ------------------ ------------- ---------------- ---------------- ------------- ---------- -------------------- -------------------- ----------- 10 rows in set (0.00 sec)