Hello,
I am considering Wednesday 27th (next week) at 14:00 UTC to do this change.
If no one says otherwise, I will go ahead and schedule it.
Thanks
Manuel.
On Wed, Oct 20, 2021 at 8:17 AM Manuel Arostegui <marostegui(a)wikimedia.org>
wrote:
> On Wed, Oct 20, 2021 at 1:23 AM Kunal Mehta <legoktm(a)wikimedia.org> wrote:
>
>>
>> Hi,
>>
>> On 10/19/21 6:00 AM, Manuel Arostegui wrote:
>> > My idea is to decrease the current TTL from m5-master (from 5 minutes
>> to
>> > 1 minute, so we can revert faster if needed).
>> > Once that is in place, I will simply change the CNAME to point to
>> > dbproxy1017.eqiad.wmnet. Everything should be transparent (if the
>> grants
>> > are correct), and connections should smoothly change to the proxy in
>> the
>> > next few days unless you want to restart the applications right away.
>>
>> Sounds good. I think it's probably just easier for us to restart mailman
>> and mailman-web soon after to find any issues right away than later on.
>>
>> -- Kunal
>>
>
> Sounds good! I will email this thread and update the task once I've
> decided a day/time for this change for next week.
>
Hello everyone,
I want to go ahead and finish the dbproxy installation on m5 (
https://phabricator.wikimedia.org/T288093).
If you are receiving this email is cause you have databases on that section.
Currently we have:
+---------------------+
| Database |
+---------------------+
| labsdbaccounts |
| mailman3 |
| mailman3web |
| striker |
| test_labsdbaccounts |
| toolhub |
+---------------------+
I have reviewed the grants and I think they are all in place (but it is a
very hard task given how messy our grants are at the moment, so I might
have missed some)
My idea is to decrease the current TTL from m5-master (from 5 minutes to 1
minute, so we can revert faster if needed).
Once that is in place, I will simply change the CNAME to point to
dbproxy1017.eqiad.wmnet. Everything should be transparent (if the grants
are correct), and connections should smoothly change to the proxy in the
next few days unless you want to restart the applications right away.
I don't think I will have time to do this during this week (as I just came
back from holidays) but I am planning to do so next week. I will email once
it is done, but please subscribe to the task too and let me know if you see
something weird with your applications after the switch.
Thanks
Manuel.