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
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)