Page MenuHomePhabricator
Create Task
Maniphest T240772

Prepare and check storage layer for ngwikimedia
Closed, ResolvedPublic
Actions

Description

New wiki requested at T240771. The wiki should be Fishbowl. Readable by all, requires account to edit

Related Objects
Search...

Event Timeline

Ammarpad created this task.Dec 14 2019, 10:47 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 14 2019, 10:47 PM
Ammarpad added a subtask: T240771: Create a wiki for Wikimedia User Group Nigeria.Dec 14 2019, 10:48 PM
Ammarpad added projects: Cloud-Services, DBA.Dec 14 2019, 10:51 PM
Ammarpad removed subscribers: Cloud-Services, DBA.
• Urbanecm removed a subtask: T240771: Create a wiki for Wikimedia User Group Nigeria.Dec 14 2019, 11:36 PM
• Urbanecm added a parent task: T240771: Create a wiki for Wikimedia User Group Nigeria.
Ammarpad mentioned this in T240771: Create a wiki for Wikimedia User Group Nigeria.Dec 15 2019, 6:49 AM
• Marostegui triaged this task as Medium priority.Dec 16 2019, 6:23 AM
• Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board.
• Marostegui subscribed.

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

Ammarpad updated the task description. (Show Details)Dec 19 2019, 6:40 AM
• Urbanecm subscribed.Feb 11 2020, 7:03 PM

@Marostegui I've created the database now!

• Marostegui claimed this task.Feb 12 2020, 6:28 AM
Stashbot added a comment.Feb 12 2020, 6:46 AM

Mentioned in SAL (#wikimedia-operations) [2020-02-12T06:46:11Z] <marostegui> Redact ngwikimedia on db1124:3313 and db2094:3313 T240772

• Marostegui added a comment.Feb 12 2020, 6:47 AM

I have sanitized both databases, and it looks fine now.
Is it possible to create another user to make sure the triggers are applied correctly?

• Urbanecm added a comment.Feb 12 2020, 9:49 AM

@Ammarpad Please ping here when you created users for the rest of your user group

Ammarpad added a comment.Feb 12 2020, 5:40 PM

Done. I created additional users.

• jcrespo subscribed.Feb 12 2020, 5:43 PM

I checked users table, looking good, but will let manuel close this.

• Marostegui moved this task from Blocked external/Not db team to Done on the DBA board.Feb 13 2020, 7:22 AM
• Marostegui added a project: cloud-services-team.
• Marostegui added subscribers: • Bstorm, • JHedden, bd808.

This is ready for WMCS to create the views.
I have created ngwikimedia_p and granted labsdbuser grants for it.
cloud-services-team please go ahead and create the views on labsdb1009, labsdb1010, labsdb1011 and labsdb1012

bd808 edited projects, added cloud-services-team (Kanban); removed cloud-services-team.Feb 13 2020, 3:53 PM
bd808 edited projects, added Data-Services; removed Cloud-Services.
bd808 moved this task from Inbox to Blocked on the cloud-services-team (Kanban) board.
bd808 moved this task from Blocked to Clinic Duty on the cloud-services-team (Kanban) board.
• Marostegui removed • Marostegui as the assignee of this task.Feb 18 2020, 6:56 AM
bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.Mar 4 2020, 5:00 PM
Stashbot added a comment.Mar 4 2020, 9:37 PM

Mentioned in SAL (#wikimedia-cloud) [2020-03-04T21:37:27Z] <bd808> Running wmcs-wikireplica-dns to add service names for ngwikimedia.*.db.svc.eqiad.wmflabs (T240772)

bd808 closed this task as Resolved.Mar 4 2020, 9:44 PM
bd808 claimed this task.
$ sql ngwikimedia_p -- show tables
More than one argument given; joining SQL query words with spaces.
+--------------------------+
| Tables_in_ngwikimedia_p  |
+--------------------------+
| abuse_filter             |
| abuse_filter_action      |
| abuse_filter_history     |
| abuse_filter_log         |
| actor                    |
| actor_archive            |
| actor_filearchive        |
| actor_image              |
| actor_ipblocks           |
| actor_logging            |
| actor_oldimage           |
| actor_recentchanges      |
| actor_revision           |
| actor_user               |
| archive                  |
| archive_compat           |
| archive_userindex        |
| babel                    |
| category                 |
| categorylinks            |
| change_tag               |
| change_tag_def           |
| comment                  |
| comment_filearchive      |
| comment_image            |
| comment_ipblocks         |
| comment_logging          |
| comment_oldimage         |
| comment_protected_titles |
| comment_recentchanges    |
| comment_revision         |
| content                  |
| content_models           |
| externallinks            |
| filearchive              |
| filearchive_compat       |
| filearchive_userindex    |
| geo_tags                 |
| global_block_whitelist   |
| image                    |
| image_compat             |
| imagelinks               |
| interwiki                |
| ip_changes               |
| ipblocks                 |
| ipblocks_compat          |
| ipblocks_ipindex         |
| ipblocks_restrictions    |
| iwlinks                  |
| l10n_cache               |
| langlinks                |
| linter                   |
| logging                  |
| logging_compat           |
| logging_logindex         |
| logging_userindex        |
| module_deps              |
| oldimage                 |
| oldimage_compat          |
| oldimage_userindex       |
| page                     |
| page_compat              |
| page_props               |
| page_restrictions        |
| pagelinks                |
| protected_titles         |
| protected_titles_compat  |
| recentchanges            |
| recentchanges_compat     |
| recentchanges_userindex  |
| redirect                 |
| revision                 |
| revision_actor_temp      |
| revision_compat          |
| revision_userindex       |
| site_identifiers         |
| site_stats               |
| sites                    |
| slot_roles               |
| slots                    |
| templatelinks            |
| transcode                |
| updatelog                |
| user                     |
| user_former_groups       |
| user_groups              |
| user_properties          |
| wbc_entity_usage         |
+--------------------------+
$ sql --cluster=web ngwikimedia_p -- show tables
More than one argument given; joining SQL query words with spaces.
+--------------------------+
| Tables_in_ngwikimedia_p  |
+--------------------------+
| abuse_filter             |
| abuse_filter_action      |
| abuse_filter_history     |
| abuse_filter_log         |
| actor                    |
| actor_archive            |
| actor_filearchive        |
| actor_image              |
| actor_ipblocks           |
| actor_logging            |
| actor_oldimage           |
| actor_recentchanges      |
| actor_revision           |
| actor_user               |
| archive                  |
| archive_compat           |
| archive_userindex        |
| babel                    |
| category                 |
| categorylinks            |
| change_tag               |
| change_tag_def           |
| comment                  |
| comment_filearchive      |
| comment_image            |
| comment_ipblocks         |
| comment_logging          |
| comment_oldimage         |
| comment_protected_titles |
| comment_recentchanges    |
| comment_revision         |
| content                  |
| content_models           |
| externallinks            |
| filearchive              |
| filearchive_compat       |
| filearchive_userindex    |
| geo_tags                 |
| global_block_whitelist   |
| image                    |
| image_compat             |
| imagelinks               |
| interwiki                |
| ip_changes               |
| ipblocks                 |
| ipblocks_compat          |
| ipblocks_ipindex         |
| ipblocks_restrictions    |
| iwlinks                  |
| l10n_cache               |
| langlinks                |
| linter                   |
| logging                  |
| logging_compat           |
| logging_logindex         |
| logging_userindex        |
| module_deps              |
| oldimage                 |
| oldimage_compat          |
| oldimage_userindex       |
| page                     |
| page_compat              |
| page_props               |
| page_restrictions        |
| pagelinks                |
| protected_titles         |
| protected_titles_compat  |
| recentchanges            |
| recentchanges_compat     |
| recentchanges_userindex  |
| redirect                 |
| revision                 |
| revision_actor_temp      |
| revision_compat          |
| revision_userindex       |
| site_identifiers         |
| site_stats               |
| sites                    |
| slot_roles               |
| slots                    |
| templatelinks            |
| transcode                |
| updatelog                |
| user                     |
| user_former_groups       |
| user_groups              |
| user_properties          |
| wbc_entity_usage         |
+--------------------------+
bd808 mentioned this in T246948: Add systemd timer to run `maintain-meta_p` daily on all Wiki Replica servers.Mar 5 2020, 4:06 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits