[00:57:09] 10DBA, 10MediaWiki-API, 10Pywikibot, 10Pywikibot-tests, 10Wikimedia-production-error: Slow API list=recentchanges query (DBError: Lost connection to MySQL server during query) - https://phabricator.wikimedia.org/T101502 (10Krinkle) 05Open→03Resolved >>! In T149077#4602472, @Anomie wrote: > [This task... [01:09:10] 10DBA, 10Core Platform Team, 10MediaWiki-API, 10Patch-For-Review, 10Wikimedia-production-error: Certain ApiQueryRecentChanges::run api query is too slow, slowing down dewiki - https://phabricator.wikimedia.org/T149077 (10Krinkle) [12:30:31] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10aborrero) [12:31:32] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10aborrero) [12:38:51] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10aborrero) [12:40:35] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10aborrero) [13:13:55] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10ayounsi) Thanks! `lang=diff [edit firewall family inet filter cloud-in4] term labsdb { ... } + /*... [13:16:20] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10aborrero) 05Open→03Resolved a:03aborrero It works! ` aborrero@labsdb1005:~$ telnet 172.16.7.153 3306 Tr... [16:52:42] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10Bstorm) We need labstore1004 and 5 more than these. 10.64.37.18, 10.64.37.19 and 10.64.37.20 maintain-dbuser... [16:56:12] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10Bstorm) 05Resolved→03Open [16:57:51] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10Bstorm) Without labstores1004 and 1005 being able to hit the database, new user accounts on toolsdb will not b... [19:18:20] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10Bstorm) We've found a way around the criticality of this. We'll still need those components, and we should up... [19:18:34] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10Bstorm) p:05Unbreak!→03Low [19:20:25] 10DBA, 10Cloud-VPS, 10Operations, 10netops, 10cloud-services-team (Kanban): toolsdb: firewalling changes for new setup (temporal mysql replication) - https://phabricator.wikimedia.org/T216353 (10Bstorm)