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.