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
: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
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.
In addition to addons.db.phx1.mozilla.com utilizing mysql::cluster, I found addons.stage.db.phx1.mozilla.com and addons.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.
Status: NEW → RESOLVED
Last Resolved: 6 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.