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

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Sheeri Cabral [:sheeri]]

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.

Comment 1

[Sheeri Cabral [:sheeri]]

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

Comment 2

[Sheeri Cabral [:sheeri]]

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

Comment 3

[Sheeri Cabral [:sheeri]]

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.

Comment 4

[Sheeri Cabral [:sheeri]]

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.

Comment 5

[Sheeri Cabral [:sheeri]]

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

Comment 6

[Sheeri Cabral [:sheeri]]

shut down today. These are being moved/repurposed on Monday anyway.