Page MenuHomePhabricator

Prepare and check storage layer for hi.wikiversity
Closed, ResolvedPublic

Description

New public project.

Event Timeline

Thanks, please let us know when the database is actually created.

MarcoAurelio added a subscriber: Dereckson.

@jcrespo You're welcome. I think @Dereckson said he'll do that so I'll add him to this task so he can notify you.

Wiki has also been created today

Mentioned in SAL (#wikimedia-operations) [2017-08-04T06:47:14Z] <marostegui> Sanitize hiwikiversity on sanitarium and sanitarium2 - T171829

Marostegui moved this task from Pending comment to Done on the DBA board.

Hi,

Triggers are working fine and anonymizing the data correctly (I have checked my user-data after registering). So the DBA side is done here.
cloud-services-team you can create all the views now for the new labs infra be aware of: T172496

We are all either at wikimania or on vacation, I expect this will be addressed in the coming week. :)

The blocker is fixed and so is this one too:

mysql:root@localhost [hiwikiversity_p]> show tables;
+---------------------------+
| Tables_in_hiwikiversity_p |
+---------------------------+
| abuse_filter              |
| abuse_filter_action       |
| abuse_filter_log          |
| archive                   |
| archive_userindex         |
| babel                     |
| category                  |
| categorylinks             |
| change_tag                |
| externallinks             |
| filearchive               |
| filearchive_userindex     |
| geo_tags                  |
| global_block_whitelist    |
| globalblocks              |
| image                     |
| imagelinks                |
| interwiki                 |
| ipblocks                  |
| ipblocks_ipindex          |
| iwlinks                   |
| l10n_cache                |
| langlinks                 |
| linter                    |
| logging                   |
| logging_logindex          |
| logging_userindex         |
| math                      |
| module_deps               |
| oldimage                  |
| oldimage_userindex        |
| page                      |
| page_props                |
| page_restrictions         |
| pagelinks                 |
| protected_titles          |
| recentchanges             |
| recentchanges_userindex   |
| redirect                  |
| revision                  |
| revision_userindex        |
| site_identifiers          |
| site_stats                |
| sites                     |
| tag_summary               |
| templatelinks             |
| transcode                 |
| updatelog                 |
| user                      |
| user_former_groups        |
| user_groups               |
| user_properties           |
| valid_tag                 |
| wbc_entity_usage          |
+---------------------------+
54 rows in set (0.00 sec)


mysql:root@localhost [hiwikiversity_p]> show create table tag_summary\G
*************************** 1. row ***************************
                View: tag_summary
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `tag_summary` AS select `hiwikiversity`.`tag_summary`.`ts_id` AS `ts_id`,`hiwikiversity`.`tag_summary`.`ts_rc_id` AS `ts_rc_id`,`hiwikiversity`.`tag_summary`.`ts_log_id` AS `ts_log_id`,`hiwikiversity`.`tag_summary`.`ts_rev_id` AS `ts_rev_id`,`hiwikiversity`.`tag_summary`.`ts_tags` AS `ts_tags` from `hiwikiversity`.`tag_summary`
character_set_client: utf8
collation_connection: utf8_general_ci
1 row in set (0.00 sec)
Marostegui claimed this task.