Page MenuHomePhabricator
Create Task
Maniphest T297618

Write replacement for wmfmiaradbpy/mysql.py
Closed, ResolvedPublic
Actions

Description

There is an out-standing CR for this, but it still needs to be packaged and deployed so people can use it.

  • Write replacement.
  • Build package and deploy
  • Update various operations/software scripts:
    • change_mw_mysql_pass.sh
    • depool-and-wait
    • check-master-heartbeat.sh
    • master-pos
    • host-to-instance
    • section
    • sys/apply
    • check_flags_per_dc.sh
    • auto_schema/auto_schema/host.py
    • report_users.sh
    • switchover-tmpl.sh
  • Update db-switchover to reference db-mysql instead of mysql.py

Details

Show related patches Customize query in gerrit

Related Objects

Event Timeline

Kormat created this task.Dec 13 2021, 3:47 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 13 2021, 3:47 PM
gerritbot added a comment.Dec 13 2021, 3:48 PM

Change 745857 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software/wmfdb@master] wmfdb/cli_admin: Add db_mysql

https://gerrit.wikimedia.org/r/745857

gerritbot added a project: Patch-For-Review.Dec 13 2021, 3:48 PM
Kormat added a comment.Dec 13 2021, 3:59 PM

When this is deployed, and stable, scripts which call mysql.py (e.g. in operations/software/dbutils) should be updated to call db-mysql instead, with appropriate changes to how the hostname is supplied.

Kormat added a comment.Dec 13 2021, 4:18 PM

Affected files:

operations/software.git/dbtools/change_mw_mysql_pass.sh
operations/software.git/dbtools/depool-and-wait
operations/software.git/dbtools/check-master-heartbeat.sh
operations/software.git/dbtools/master-pos
operations/software.git/dbtools/host-to-instance
operations/software.git/dbtools/section
operations/software.git/dbtools/sys/apply
operations/software.git/dbtools/check_flags_per_dc.sh
operations/software.git/dbtools/auto_schema/auto_schema/host.py
operations/software.git/dbtools/report_users.sh
operations/software.git/dbtools/switchover-tmpl.sh
Kormat moved this task from Backlog to In Progress on the wmfdb board.Dec 14 2021, 9:55 AM
gerritbot added a comment.Dec 14 2021, 2:17 PM

Change 745857 merged by jenkins-bot:

[operations/software/wmfdb@master] wmfdb/cli_admin: Add db_mysql

https://gerrit.wikimedia.org/r/745857

Kormat mentioned this in rOSWD28a94b43c71d: wmfdb/cli_admin: Add db_mysql.Dec 14 2021, 2:19 PM
Maintenance_bot removed a project: Patch-For-Review.Dec 14 2021, 3:10 PM
gerritbot added a comment.Dec 15 2021, 11:46 AM

Change 747501 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software/wmfdb@master] debian: Initial debian packaging.

https://gerrit.wikimedia.org/r/747501

gerritbot added a project: Patch-For-Review.Dec 15 2021, 11:46 AM
gerritbot added a comment.Dec 15 2021, 11:49 AM

Change 747501 merged by Kormat:

[operations/software/wmfdb@master] debian: Initial debian packaging.

https://gerrit.wikimedia.org/r/747501

Kormat mentioned this in rOSWD5e6800928ff8: debian: Initial debian packaging..Dec 15 2021, 11:50 AM
Maintenance_bot removed a project: Patch-For-Review.Dec 15 2021, 12:10 PM
Stashbot added a comment.Dec 15 2021, 1:28 PM

Mentioned in SAL (#wikimedia-operations) [2021-12-15T13:28:37Z] <kormat> uploaded wmfdb 0.1 to apt.wm.o for buster+bullseye T297618

gerritbot added a comment.Dec 15 2021, 1:53 PM

Change 747511 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software/wmfdb@master] wmfdb/cli_admin: Support wikireplicas auth.

https://gerrit.wikimedia.org/r/747511

gerritbot added a project: Patch-For-Review.Dec 15 2021, 1:53 PM
gerritbot added a comment.Dec 15 2021, 2:05 PM

Change 747511 merged by jenkins-bot:

[operations/software/wmfdb@master] wmfdb/cli_admin: Support wikireplicas auth.

https://gerrit.wikimedia.org/r/747511

Kormat mentioned this in rOSWD5d5ea4413cc9: wmfdb/cli_admin: Support wikireplicas auth..Dec 15 2021, 2:05 PM
Stashbot added a comment.Dec 15 2021, 2:23 PM

Mentioned in SAL (#wikimedia-operations) [2021-12-15T14:23:50Z] <kormat> uploaded wmfdb 0.1.1 to apt.wm.o for buster+bullseye T297618

gerritbot added a comment.Dec 15 2021, 2:33 PM

Change 747521 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software/wmfdb@master] wmfdb/cli_admin: Fix ordering of --defaults-group-suffix

https://gerrit.wikimedia.org/r/747521

gerritbot added a comment.Dec 15 2021, 3:12 PM

Change 747521 merged by jenkins-bot:

[operations/software/wmfdb@master] wmfdb/cli_admin: Fix ordering of --defaults-group-suffix

https://gerrit.wikimedia.org/r/747521

Kormat mentioned this in rOSWDf7c48c548720: wmfdb/cli_admin: Fix ordering of --defaults-group-suffix.Dec 15 2021, 3:12 PM
Kormat updated the task description. (Show Details)Dec 15 2021, 4:25 PM
Marostegui added a subscriber: Marostegui.Dec 15 2021, 4:27 PM
gerritbot added a comment.Dec 15 2021, 10:48 PM

Change 747624 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/software@master] auto_schema: Move away from mysql.py

https://gerrit.wikimedia.org/r/747624

gerritbot added a comment.Dec 16 2021, 6:07 AM

Change 747681 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/software@master] report_users: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747681

gerritbot added a comment.Dec 16 2021, 6:09 AM

Change 747681 merged by jenkins-bot:

[operations/software@master] report_users: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747681

Marostegui added a comment.Dec 16 2021, 6:13 AM

report_users.sh tested and changed.

gerritbot added a comment.Dec 16 2021, 6:16 AM

Change 747682 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/software@master] section: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747682

Marostegui added a comment.Dec 16 2021, 6:17 AM

section tested and changed.

gerritbot added a comment.Dec 16 2021, 6:17 AM

Change 747682 merged by jenkins-bot:

[operations/software@master] section: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747682

gerritbot added a comment.Dec 16 2021, 6:23 AM

Change 747684 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/software@master] check_flags_per_dc.sh: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747684

Marostegui added a comment.Dec 16 2021, 6:24 AM

check_flags_per_dc.sh tested and changed.

gerritbot added a comment.Dec 16 2021, 6:24 AM

Change 747684 merged by jenkins-bot:

[operations/software@master] check_flags_per_dc.sh: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747684

gerritbot added a comment.Dec 16 2021, 7:49 AM

Change 747790 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/software@master] master-pos: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747790

Marostegui added a comment.Dec 16 2021, 7:50 AM

master-pos tested and changed.

gerritbot added a comment.Dec 16 2021, 7:50 AM

Change 747790 merged by jenkins-bot:

[operations/software@master] master-pos: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747790

Kormat updated the task description. (Show Details)Dec 16 2021, 9:54 AM
gerritbot added a comment.Dec 16 2021, 10:02 AM

Change 747799 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/software@master] section: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747799

gerritbot added a comment.Dec 16 2021, 10:06 AM

Change 747799 merged by jenkins-bot:

[operations/software@master] section: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/747799

Kormat updated the task description. (Show Details)Dec 16 2021, 10:06 AM
Marostegui updated the task description. (Show Details)Dec 16 2021, 10:06 AM
gerritbot added a comment.Dec 16 2021, 10:10 AM

Change 747803 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software@master] master-pos: Simplify db-mysql params.

https://gerrit.wikimedia.org/r/747803

gerritbot added a comment.Dec 16 2021, 10:12 AM

Change 747803 merged by Kormat:

[operations/software@master] master-pos: Simplify db-mysql params.

https://gerrit.wikimedia.org/r/747803

gerritbot added a comment.Dec 16 2021, 10:14 AM

Change 747804 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software@master] host-to-instance: Switch to db-mysql.

https://gerrit.wikimedia.org/r/747804

gerritbot added a comment.Dec 16 2021, 10:15 AM

Change 747804 merged by Kormat:

[operations/software@master] host-to-instance: Switch to db-mysql.

https://gerrit.wikimedia.org/r/747804

Kormat updated the task description. (Show Details)Dec 16 2021, 10:15 AM
gerritbot added a comment.Dec 16 2021, 10:19 AM

Change 747807 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software@master] dbtools/sys/apply: Switch to db-mysql.

https://gerrit.wikimedia.org/r/747807

gerritbot added a comment.Dec 16 2021, 10:20 AM

Change 747807 merged by Kormat:

[operations/software@master] dbtools/sys/apply: Switch to db-mysql.

https://gerrit.wikimedia.org/r/747807

Kormat updated the task description. (Show Details)Dec 16 2021, 10:20 AM
gerritbot added a comment.Dec 16 2021, 10:24 AM

Change 747808 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software@master] switchover-tmpl.sh: Switch to db-mysql

https://gerrit.wikimedia.org/r/747808

gerritbot added a comment.Dec 16 2021, 10:27 AM

Change 747808 merged by Kormat:

[operations/software@master] switchover-tmpl.sh: Switch to db-mysql

https://gerrit.wikimedia.org/r/747808

Kormat updated the task description. (Show Details)Dec 16 2021, 10:27 AM
gerritbot added a comment.Dec 16 2021, 10:42 AM

Change 747810 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software@master] check-master-heartbeat.sh: Switch to db-mysql

https://gerrit.wikimedia.org/r/747810

gerritbot added a comment.Dec 16 2021, 10:46 AM

Change 747810 merged by Kormat:

[operations/software@master] check-master-heartbeat.sh: Switch to db-mysql

https://gerrit.wikimedia.org/r/747810

Kormat updated the task description. (Show Details)Dec 16 2021, 10:46 AM
gerritbot added a comment.Dec 16 2021, 10:55 AM

Change 747811 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software@master] change_mw_mysql_pass: Switch to db-mysql

https://gerrit.wikimedia.org/r/747811

gerritbot added a comment.Dec 16 2021, 11:19 AM

Change 747624 merged by jenkins-bot:

[operations/software@master] auto_schema: Move away from mysql.py

https://gerrit.wikimedia.org/r/747624

gerritbot added a comment.Dec 16 2021, 11:20 AM

Change 747811 merged by Kormat:

[operations/software@master] change_mw_mysql_pass: Switch to db-mysql

https://gerrit.wikimedia.org/r/747811

Kormat updated the task description. (Show Details)Dec 16 2021, 11:20 AM
Kormat updated the task description. (Show Details)
gerritbot added a comment.Dec 16 2021, 11:27 AM

Change 747817 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software@master] depool-and-wait: Switch to db-mysql

https://gerrit.wikimedia.org/r/747817

gerritbot added a comment.Dec 16 2021, 11:30 AM

Change 747817 merged by Kormat:

[operations/software@master] depool-and-wait: Switch to db-mysql

https://gerrit.wikimedia.org/r/747817

Kormat updated the task description. (Show Details)Dec 16 2021, 11:32 AM
gerritbot added a comment.Dec 17 2021, 7:38 AM

Change 748064 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] jynus,kormat.bashrc: Replace mysql.py with db-mysql

https://gerrit.wikimedia.org/r/748064

gerritbot added a comment.Dec 20 2021, 12:09 PM

Change 748064 abandoned by Marostegui:

[operations/puppet@production] jynus,kormat.bashrc: Replace mysql.py with db-mysql

Reason:

They'll take care of their own /home files

https://gerrit.wikimedia.org/r/748064

gerritbot added a comment.Dec 23 2021, 10:36 AM

Change 749699 had a related patch set uploaded (by Kormat; author: Kormat):

[operations/software/wmfmariadbpy@master] switchover.py: Change references to db-mysql.

https://gerrit.wikimedia.org/r/749699

gerritbot added a comment.Dec 23 2021, 10:46 AM

Change 749699 merged by jenkins-bot:

[operations/software/wmfmariadbpy@master] switchover.py: Change references to db-mysql.

https://gerrit.wikimedia.org/r/749699

Kormat closed this task as Resolved.Dec 23 2021, 10:46 AM
Kormat claimed this task.

All done!

Kormat updated the task description. (Show Details)Dec 23 2021, 10:46 AM
Kormat mentioned this in rOSMD5964f282e751: switchover.py: Change references to db-mysql..Dec 23 2021, 11:03 AM
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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