Page MenuHomePhabricator

Write replacement for wmfmiaradbpy/mysql.py
Closed, ResolvedPublic

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

Event Timeline

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

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.

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

Change 745857 merged by jenkins-bot:

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

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

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

Change 747501 merged by Kormat:

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

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

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

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

Change 747511 merged by jenkins-bot:

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

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

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

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

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

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

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

Change 747681 merged by jenkins-bot:

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

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

report_users.sh tested and changed.

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

Change 747682 merged by jenkins-bot:

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

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

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

check_flags_per_dc.sh tested and changed.

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

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

Change 747790 merged by jenkins-bot:

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

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

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

Change 747799 merged by jenkins-bot:

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

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

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

Change 747803 merged by Kormat:

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

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

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

Change 747804 merged by Kormat:

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

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

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

Change 747807 merged by Kormat:

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

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

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

Change 747808 merged by Kormat:

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

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

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

Change 747810 merged by Kormat:

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

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

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

Change 747624 merged by jenkins-bot:

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

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

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)

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

Change 747817 merged by Kormat:

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

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

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

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

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

Change 749699 merged by jenkins-bot:

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

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

Kormat claimed this task.

All done!