decom tm-amo01-master01 and tm-amo01-slave01

RESOLVED FIXED

Status

RESOLVED FIXED
7 years ago
4 years ago

People

(Reporter: scabral, Assigned: scabral)

Tracking

Details

(Whiteboard: check general logs again)

(Assignee)

Description

7 years ago
tm-amo01-master01 and tm-amo01-slave01 are no longer used in production.

Let's take a look at what we need to do to get rid of these.
(Assignee)

Comment 1

7 years ago
I turned on the general log on tm-amo01-master01 earlier today, and I am still seeing some queries from the remora user on 10.2.81.55, which nslookup tells me is mrapp55.mozilla.org:

		  19008 Connect     remora@10.2.81.55 on 
		  19008 Init DB     addons_remora
		  19008 Query       SELECT `AddonTag`.`addon_id`, `AddonTag`.`tag_id`, `AddonTag`.`feature`, `AddonTag`.`feature_locales` FROM `addons_tags` AS `AddonTag`   WHERE `AddonTag`.`addon_id` IN (220)
		  19008 Query       SELECT `File`.`id`, `File`.`version_id`, `File`.`platform_id`, `File`.`filename`, `File`.`size`, `File`.`hash`, `File`.`codereview`, `File`.`status`, `File`.`datestatuschanged`, `File`.`created`, `File`.`modified` FROM `files` AS `File`   WHERE `File`.`version_id` = '1267075'
		  19008 Query       SELECT `AddonTag`.`addon_id`, `AddonTag`.`tag_id`, `AddonTag`.`feature`, `AddonTag`.`feature_locales` FROM `addons_tags` AS `AddonTag`   WHERE `AddonTag`.`addon_id` IN (10550)
		  19008 Query       SELECT `File`.`id`, `File`.`version_id`, `File`.`platform_id`, `File`.`filename`, `File`.`size`, `File`.`hash`, `File`.`codereview`, `File`.`status`, `File`.`datestatuschanged`, `File`.`created`, `File`.`modified` FROM `files` AS `File`   WHERE `File`.`version_id` = '1267054'
		  19008 Query       SELECT `AddonTag`.`addon_id`, `AddonTag`.`tag_id`, `AddonTag`.`feature`, `AddonTag`.`feature_locales` FROM `addons_tags` AS `AddonTag`   WHERE `AddonTag`.`addon_id` IN (329008)
		  19008 Query       SELECT `AddonTag`.`addon_id`, `AddonTag`.`tag_id`, `AddonTag`.`feature`, `AddonTag`.`feature_locales` FROM `addons_tags` AS `AddonTag`   WHERE `AddonTag`.`addon_id` IN (552)
		  19008 Query       SELECT `File`.`id`, `File`.`version_id`, `File`.`platform_id`, `File`.`filename`, `File`.`size`, `File`.`hash`, `File`.`codereview`, `File`.`status`, `File`.`datestatuschanged`, `File`.`created`, `File`.`modified` FROM `files` AS `File`   WHERE `File`.`version_id` = '457614'
		  19008 Query       SELECT `Version`.`id`, `Version`.`addon_id`, `Version`.`license_id`, `Version`.`version`, `Version`.`approvalnotes`, `Version`.`releasenotes`, `Version`.`created`, `Version`.`modified` FROM `versions` AS `Version`   WHERE `Version`.`id`  =  1267075
		  19008 Query       SELECT `Version`.`id`, `Version`.`addon_id`, `Version`.`license_id`, `Version`.`version`, `Version`.`approvalnotes`, `Version`.`releasenotes`, `Version`.`created`, `Version`.`modified` FROM `versions` AS `Version`   WHERE `Version`.`id`  =  1267054
		  19008 Query       SELECT `Version`.`id`, `Version`.`addon_id`, `Version`.`license_id`, `Version`.`version`, `Version`.`approvalnotes`, `Version`.`releasenotes`, `Version`.`created`, `Version`.`modified` FROM `versions` AS `Version`   WHERE `Version`.`id`  =  457614
		  19008 Quit
(Assignee)

Comment 2

7 years ago
I'll leave the general log on for at least a day and then revisit, and get a full listing of what's done.
(Assignee)

Updated

7 years ago
Assignee: server-ops-database → scabral
(Assignee)

Comment 3

7 years ago
In fact I turned it off a few days later:

[root@tm-amo01-master01 mysql]# ls -lh general.log 
-rw-rw---- 1 mysql mysql 495M Jan 16 07:16 general.log

There are some SELECT queries from the plugins user and a remora user:

plugins_user@10.2.83.15 on 
plugins_user@10.2.83.16 on 
plugins_user@10.2.83.17 on 
plugins_user@10.2.83.19 on 
remora@10.2.81.55 on 

remora user is coming from:
[root@tm-amo01-master01 mysql]# nslookup 10.2.81.55
Server:         10.2.70.5
Address:        10.2.70.5#53

55.81.2.10.in-addr.arpa name = mrapp55.mozilla.org.


As for the plugins_users:

[root@tm-amo01-master01 mysql]# nslookup 10.2.83.15
Server:         10.2.70.5
Address:        10.2.70.5#53

15.83.2.10.in-addr.arpa name = pm-app-amo03.mozilla.org.
16.83.2.10.in-addr.arpa name = pm-app-amo04.mozilla.org.
17.83.2.10.in-addr.arpa name = pm-app-amo05.mozilla.org.
19.83.2.10.in-addr.arpa name = pm-app-amo07.mozilla.org.
(Assignee)

Comment 4

7 years ago
mrapp55 has been turned off. 

I have turned general logging on again for tm-amo01-master01 to see if there's anything left accessing it.
(Assignee)

Updated

7 years ago
Whiteboard: check general logs again
(Assignee)

Comment 5

7 years ago
From 3/26 to 4/3, here are the connections - mostly nagios and root@loclhost, and replication. There are a few "plugins_user" but not many.

   3874   nagiosdaemon@10.2.74.123 on 
   3867   nagiosdaemon@10.2.70.200 on 
    208   root@localhost on 
    195   root@localhost on mysql
    195   replication-user@10.2.70.13 on 
      7   plugins_user@10.2.83.19 on 
      5   plugins_user@10.2.83.15 on 
      4   plugins_user@10.2.83.16 on 
      4 d for user 'root'@'10.2.70.4' (using password: YES)
      3   plugins_user@10.2.83.17 on 
      3 @10.2.70.200 on 
      2 d for user 'test'@'10.2.70.4' (using password: NO)
      2 d for user 'root'@'10.2.70.4' (using password: NO)
      2 d for user 'root'@'10.2.70.200' (using password: YES)
      2 d for user 'myusername'@'10.2.70.4' (using password: YES)
      2 d for user 'monty'@'10.2.70.4' (using password: YES)
      2 d for user 'jeffrey'@'10.2.70.4' (using password: YES)
      2 d for user 'dummy'@'10.2.70.4' (using password: NO)
      2 d for user 'custom'@'10.2.70.4' (using password: YES)
      2 d for user 'admin'@'10.2.70.4' (using password: YES)
      2 d for user ''@'10.2.70.4' (using password: NO)
      2   Access denied for user 'admin'@'10.2.70.4' (using password: NO)
      1 d for user 'test'@'10.2.70.200' (using password: NO)
      1 d for user 'root'@'10.2.70.200' (using password: NO)
      1 d for user 'myusername'@'10.2.70.200' (using password: YES)
      1 d for user 'monty'@'10.2.70.200' (using password: YES)
      1 d for user 'jeffrey'@'10.2.70.200' (using password: YES)
      1 d for user 'dummy'@'10.2.70.200' (using password: NO)
      1 d for user 'custom'@'10.2.70.200' (using password: YES)
      1 d for user 'admin'@'10.2.70.200' (using password: YES)
      1 d for user ''@'10.2.70.200' (using password: NO)
      1   Access denied for user 'UNKNOWN_MYSQL_US'@'localhost' (using password: YES)
      1   Access denied for user 'admin'@'10.2.70.200' (using password: NO)
      1 @10.2.74.123 on
(Assignee)

Comment 6

7 years ago
shut down today. These are being moved/repurposed on Monday anyway.
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.