SSM Params: Create MySql Wrappers

[terrywbrady]

• [x] Create repo: https://github.com/cdluc3/uc3-aws-cli
• [x] Create mysql wrapper code (Terry)
• [x] Deploy jq to all boxes (Ashley)
• [x] Deploy uc3-aws-cli to all boxes (Ashley)
• [ ] Deploy Merritt Billing cron (stage)
• [ ] Deploy Merritt Billing cron (prod)
• Retire old billing process <-- Moved to #431

  ./uc3-mysql.sh billing readwrite -- -e 'call update_billing_range();' 
  ./uc3-mysql.sh billing readwrite -- -e 'call update_object_size();' 

[terrywbrady]

Some duplication of #393

[terrywbrady]

In the interim, I have setup a cron in my home account on the ops box.

bash-4.2$ crontab -l
0 1 * * * ~/dbSyncCron.sh
bash-4.2$ cat dbSyncCron.sh 
#!/bin/bash

uc3-mysql.sh billing -rp (stage path) -- -e 'call update_billing_range();'
uc3-mysql.sh billing -rp (stage path) -- -e 'call update_object_size();'
uc3-mysql.sh billing -rp (prod path) -- -e 'call update_billing_range();'
uc3-mysql.sh billing -rp (prod path) -- -e 'call update_object_size();'

[ashleygould]

This tool set has been deployed to all uc3 merritt hosts via puppet.

[terrywbrady]

@ashleygould , will you create the cron entries within the dpr2 account or is that something that I can do?

[ashleygould]

@terrywbrady I will do it. You don't have write access to puppet.

https://www.pivotaltracker.com/story/show/174181456