mariadb: systemctl status accessor in mysql_legacy
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	ABran-WMF
	Oct 14 2024, 12:47 PM

Description

as seen in T374191 code review, we could bank an easy win adding a systemctl accessor to poll for mariadb's systemd service status

Subject	Repo	Branch	Lines +/-
mariadb: clone cookbook maintenance	operations/cookbooks	master	+184 -155
mysql_legacy: reuse old code pattern to avoid potential issue	operations/software/spicerack	master	+3 -0
mysql_legacy: get systemd status for instance	operations/software/spicerack	master	+27 -0

Status	Assigned	Task
		Unknown Object (Task)
Resolved	Jhancock.wm	T342174 Q1:rack/setup/install db21[88-95]
Resolved	ABran-WMF	T343674 Productionize db21[88-95]
Resolved	LSobanski	T156461 [META ticket] Automation for our DBs tracking task
Open	ABran-WMF	T239814 Automate DB upgrades
Resolved	Volans	T362893 Spicerack support for dbctl
Resolved	ABran-WMF	T368881 Make sre.mysql.clone handling pooling/depooling
Open	ABran-WMF	T374191 upgrade clone cookbook
Declined	ABran-WMF	T376712 mysql_legacy: SQL query quote escape
Resolved	ABran-WMF	T376701 mysql_legacy data_directory getter
Resolved	ABran-WMF	T377129 mariadb: systemctl status accessor in mysql_legacy

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

ABran-WMF triaged this task as Medium priority.Oct 14 2024, 12:48 PM

ABran-WMF moved this task from Triage to In progress on the DBA board.

Change #1080019 had a related patch set uploaded (by Arnaudb; author: Arnaudb):

[operations/software/spicerack@master] mariadb: get systemd status for instance

Change #1071155 had a related patch set uploaded (by Arnaudb; author: Arnaudb):

[operations/cookbooks@master] mariadb: clone cookbook maintenance

Change #1080019 merged by jenkins-bot:

[operations/software/spicerack@master] mysql_legacy: get systemd status for instance

Change #1082469 had a related patch set uploaded (by Arnaudb; author: Arnaudb):

[operations/software/spicerack@master] mysql_legacy: reuse old code pattern to avoid potential issue

Change #1082469 abandoned by Arnaudb:

[operations/software/spicerack@master] mysql_legacy: reuse old code pattern to avoid potential issue

Reason:

as discussed, this will be replaced by a comment on the cookbook where it was found, so if it fails it is identifiable.

code is implemented, needs to be tested under T374191