cumin hosts have a .my.cnf that is configured so we can access clouddb* host just reading it while using db-mysql:
[clientlabsdb] user = root password = XXX
With an-redacteddb1001 we need to tell db-mysql to also read that entry.
@BTullis can you send a patch so that can be fixed, as otherwise an-redactddb1001 can not be accessed from cumin hosts with the current tooling, I believe dbutil.py is what we need to start changing - @Ladsgroup can you confirm?
| Title | Reference | Author | Source Branch | Dest Branch | |
|---|---|---|---|---|---|
| Prepare version 0.1.5 release | repos/sre/wmfdb!17 | btullis | release_v_0_1_5 | main | |
| Configure mysql client preferences for an-redacteddb* hosts | repos/sre/wmfdb!16 | btullis | switch_redacteddb | main |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Unknown Object (Task) | |||||
| Resolved | BTullis | T355571 Q#:rack/setup/install an-redacteddb1001 | |||
| Resolved | BTullis | T365453 Bring an-redacteddb1001 into service to replace clouddb1021 | |||
| Open | BTullis | T368354 Modify db-mysql to connect to an-redacteddb1001 from cumin hosts |
I believe dbutil.py is what we need to start changing - @Ladsgroup can you confirm?
Actually I think that file is not used anymore or only used in switchover and some other scripts. You need to change the scripts in wmfdb: https://gitlab.wikimedia.org/repos/sre/wmfdb
btullis opened https://gitlab.wikimedia.org/repos/sre/wmfdb/-/merge_requests/16
Configure mysql client preferences for an-redacteddb* hosts
Thanks both. I have created a merge request here: https://gitlab.wikimedia.org/repos/sre/wmfdb/-/merge_requests/16
See if you think it's OK.
btullis merged https://gitlab.wikimedia.org/repos/sre/wmfdb/-/merge_requests/16
Configure mysql client preferences for an-redacteddb* hosts
btullis opened https://gitlab.wikimedia.org/repos/sre/wmfdb/-/merge_requests/17
Prepare version 0.1.5 release