Decommissioned as of 1/18/23 because we have a lot of other monitoring and alerting tools that tell us if DBs are broken.
This Python 3.6 script tries to connect to databases and sends a Slack alert with error text if it fails.
- Create a Python 3.6 virtualenv:
virtualenv -p /path/to/python3 venv - Activate the virtualenv:
source venv/bin/activate - Install requirements:
pip install -r requirements.txt - Create a settings file and fill it out:
cp settings.py.example settings.py - Run script with
python check_dbs.py
pip install pip==9.0.3, since zappa requires an older version of pipcp zappa_settings.json.example zappa_settings.py, fill ins3_bucketwith a unique bucket name, and change anything else you want.zappa deploy production
- Add support for email and SMS alerts.