Page MenuHomePhabricator

Prepare and check storage layer for bbcwiki
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Related Objects

Event Timeline

Marostegui triaged this task as Medium priority.Nov 2 2023, 12:13 PM
Marostegui moved this task from Triage to Blocked on the DBA board.
Marostegui subscribed.

Let us know when the wiki is created so we can sanitize it

Marostegui added a project: Data-Platform-SRE.
Marostegui added a subscriber: BTullis.

All done, ready for the views creation.

Mentioned in SAL (#wikimedia-operations) [2023-11-07T11:45:26Z] <btullis@cumin1001> Added views for new wiki: bbcwiki T350372

BTullis moved this task from In Progress to Done on the Data-Platform-SRE board.

This is now working, including the DNS alias.

btullis@tools-sgebastion-10:~$ sql bbcwiki
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 425612078
Server version: 10.4.22-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [bbcwiki_p]> select * from page limit 2;
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
| page_id | page_namespace | page_title      | page_is_redirect | page_is_new | page_random    | page_touched   | page_links_updated | page_latest | page_len | page_content_model | page_lang |
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
|       1 |              0 | Pogu_ni_Alaman  |                0 |           0 | 0.713055345025 | 20231107011506 | 20231107011506     |           4 |     1407 | wikitext           | NULL      |
|       2 |              8 | Sitesupport-url |                0 |           1 | 0.436606342244 | 20231106092351 | 20231106092351     |           2 |      109 | wikitext           | NULL      |
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
2 rows in set (0.002 sec)

MariaDB [bbcwiki_p]>