757224 - addons slowlog copy into puppet

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

we are copying addons slow query logs to webdev1, let's put that into puppet. The parts are:

0) actual copy script in /root/bin
1) /root/bin directory
2) cron script that runs /root/bin/scriptname
3) ssh key for root

Comment 1

[Brian Hourigan [:digi]]

:sheeri

I think we're trying to move away from /root/bin, hier(7) suggests /usr/local/bin. I can puppetize this for you if it's already setup on a host

Comment 2

[Sheeri Cabral [:sheeri]]

Sure! this was more of a reminder for me to do. Everything is already set up using /root/bin. According to what's showing up on webdev, the following hosts are set up properly:

addons1.db.phx1.mozilla.com
addons2
addons3
addons4
addons5
addons7
addons8
addons9


(it's set up ok on 6 but slow query logging isn't working fine).

If you want to do it, more power to you! Just make sure to delete the existing cron jobs and move the files to /usr/local/bin or wherever.

Comment 3

[Brian Hourigan [:digi]]

In addition to addons[12345689].db.phx1.mozilla.com utilizing mysql::cluster, I found addons[2345].stage.db.phx1.mozilla.com and addons[23456789].db.scl3.mozilla.com were using it as well

Being unsure whether or not all hosts using mysql::cluster need the backup-slowlogs.sh script to run I created a boolean parameter to mysql::init and mysql::cluster which controls this behavior.

In the case of the hosts mentioned in this bug I added the following in nodes/databases.pp:

            slowlogs => true

You can add this to any host utilizing the mysql module and the script will be managed by puppet. I also changed the location to /usr/local/sbin from /root/bin, and ensured the script in /root/bin is absent.