790413 - decom or upgrade c01 databases to MySQL 5.1

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

The last binary log on tp-c01-master01 was written to on Aug 30th.

-rw-rw---- 1 mysql mysql 117M Aug 30 07:33 tp-c01-master01-bin.002414

And that binary log spans April through August. So very little, if anything is using this server. Decommission it or upgrade to MySQL 5.1.

Comment 1

[Dustin J. Mitchell [:dustin] (he/him)]

If this gets upgraded, it should use mysql2::server.

Comment 2

[Sheeri Cabral [:sheeri]]

Checked those files, and the Aug 30th writing was dropping users and databases:

#120830  7:33:17 server id 8070071  end_log_pos 122457120       Query   thread_id=14552410      exec_time=0error_code=0
SET TIMESTAMP=1346337197/*!*/;
drop user webdiaries@10.2.70.4
/*!*/;
# at 122457120
#120830  7:33:28 server id 8070071  end_log_pos 122457210       Query   thread_id=14552410      exec_time=0error_code=0
SET TIMESTAMP=1346337208/*!*/;
drop user 'sfx-video'@10.2.70.4
/*!*/;
# at 122457210
#121008 12:43:05 server id 8070071  end_log_pos 122457331       Query   thread_id=19023712      exec_time=0error_code=0
SET TIMESTAMP=1349725385/*!*/;
drop database if exists rockyourfirefox_com

The only write since then is updating the password for the nagiosdaemon user. Nothing's writing to these servers.

Comment 3

[Sheeri Cabral [:sheeri]]

Just FYI:

mysql> show databases;
+--------------------------------+
| Database                       |
+--------------------------------+
| information_schema             | 
| addons_forums_phpbb            | 
| air_mozilla_com_wp             | 
| basket_mozilla_com             | 
| blog_lizardwrangler            | 
| blog_mozilla_com_wp            | 
| blog_mozillafoundation_org_wp  | 
| brendaneich_com                | 
| byob                           | 
| cnmonitor                      | 
| contribute_mozilla_org         | 
| creative_mozilla_org           | 
| dnt_mozilla_org                | 
| drumbeat_org_civicrm           | 
| drumbeat_org_drupal            | 
| ebaycompanion_emails           | 
| extendfirefox_contest          | 
| extendfirefox_contest3         | 
| extendfirefox_mobile_contest   | 
| ffparty                        | 
| firefoxflicks                  | 
| firefoxflicks_wp_backstage     | 
| firefoxflicks_wp_webdiaries    | 
| getfirebug_blog                | 
| getfirebug_com_perch           | 
| hacks_mozilla_org_wp           | 
| headrush                       | 
| input_mozilla_com              | 
| jetpackgallery_mozillalabs_com | 
| kubla                          | 
| kubla_mozillaonline            | 
| labs_mozilla_org_extend_3_5    | 
| labs_smf                       | 
| labs_vanilla                   | 
| labs_wordpress                 | 
| labs_wpmu                      | 
| ldapmonitor                    | 
| livetitles_wp                  | 
| mozilla_europe                 | 
| mozilla_input_metrics          | 
| mozillaparty_com               | 
| mpl_mozilla_org                | 
| mysql                          | 
| openweb                        | 
| pastebin                       | 
| personas                       | 
| priorartshare_wp               | 
| rsvp                           | 
| securityquiz_facebook_m_c      | 
| sfx_v2                         | 
| spark_mozilla_org              | 
| spreadfirefox                  | 
| survey_firstrun                | 
| survey_mozilla_europe          | 
| survey_university              | 
| userpanel                      | 
| warnings_build_mozilla_org     | 
| wiki_evang_deki                | 
| wiki_getfirebug_com            | 
| wiki_mdc                       | 
| wiki_mdc_cluster               | 
| wiki_mozorg                    | 
| www_spreadfirefox_com_5years   | 
+--------------------------------+
63 rows in set (0.00 sec)

Comment 4

[Sheeri Cabral [:sheeri]]

dumitru can you confirm that the phx pp-lb08 load balancers show no traffic for the tp-c01-rw-zeus and tp-c01-r0-zeus VIPs?

Comment 5

[Sheeri Cabral [:sheeri]]

We have shut down mysql on the c01 slave and master, and dumitru has turned off the VIPs. After we confirm that we can shut these down next week, we will:

[17:17:54] <%dumitru> sheeri: decommission the nodes, clean up DNS, inventory, Zeus.

And I will save a backup of the db on the host just in case.

Comment 6

[Sheeri Cabral [:sheeri]]

Giving to dumitru to do all the cleanup in comment 5 and removal from nagios and puppet too. (I can help if needed)

Comment 7

[Rick Bryce [:rbryce]]

removed from puppet & nagios.  Servers powered down and marked as *decomm* in inventory.

Comment 8

[Sheeri Cabral [:sheeri]]

reopening for clarity:

Has DNS been cleaned up and Zeus updated? we no longer need the Zeus stuff either, the db-c01-ro and db-c01-rw and the corresponding pools.

Comment 9

[Dumitru Gherman [:dumitru]]

I cleaned up DNS and Zeus.