Maniphest T220395

TEC6: Database Automation
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	CDanis
	Apr 8 2019, 2:21 PM

Tags

Referenced Files

None

Subscribers

Description

Automate common operational tasks around service deployment, maintenance and incident response and build automated workflows for data center infrastructure, network, and equipment lifecycle management

FY18-19 Q4 Goal

Complete and deploy the tool for pooling/depooling databases dynamically from MediaWiki (dbconfig)
~~Migrate MediaWiki to use etcd for the database configuration in production~~ [moved to Q1 goal]
~~[stretch] Write Spicerack cookbooks to automate 2 common DBA workflows~~

FY19-20 Q1 Goal

Productionize dbctl (deploy, import data, set up alerts)
Set up MediaWiki to optionally read the database configuration from etcd
Gradually migrate all MediaWiki instances to read the database configuration from etcd

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		None	T172492 Database alerting
		Resolved		jcrespo	T177782 Reduce false positives on database pages
		Resolved		CDanis	T220395 TEC6: Database Automation
		Resolved		CDanis	T197126 Create tool to handle the state of database configuration in MediaWiki in etcd
		Resolved		Volans	T197531 Data model for dbconfig
		Resolved		CDanis	T229070 phased rollout of dbctl, etcd-backed database configuration in Mediawiki
		Resolved		CDanis	T229631 noc.wm.o/db.php: remove hosts information, or fetch it from etcd somehow
		Resolved		Joe	T226965 conftool: upgrade fleet to use existing python3-conftool

Event Timeline

CDanis created this task.Apr 8 2019, 2:21 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 8 2019, 2:21 PM

CDanis added a subtask: T197126: Create tool to handle the state of database configuration in MediaWiki in etcd.Apr 8 2019, 2:22 PM

• Marostegui added a subscriber: • Marostegui.Apr 8 2019, 2:23 PM

Volans closed subtask T226965: conftool: upgrade fleet to use existing python3-conftool as Resolved.Jul 4 2019, 2:01 PM

Volans triaged this task as Medium priority.Jul 18 2019, 8:39 AM

Volans updated the task description. (Show Details)

CDanis added a subtask: T229070: phased rollout of dbctl, etcd-backed database configuration in Mediawiki.Jul 25 2019, 11:01 PM

CDanis closed subtask T229070: phased rollout of dbctl, etcd-backed database configuration in Mediawiki as Resolved.Aug 1 2019, 10:14 PM

CDanis closed this task as Resolved.Aug 1 2019, 11:37 PM

CDanis updated the task description. (Show Details)

CDanis closed subtask T197126: Create tool to handle the state of database configuration in MediaWiki in etcd as Resolved.