sprinterfreak
/
galeranotify
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
Python E-Mail script for use with Galera wsrep_notify_cmd
12 Commits 1 Branch 0 Tags 39 KiB
Python 100%
Go to file
Jan 8d64c39019 Introduce pip installable package 
* Added configuration support
  * Drop identical notifications
  * Provide install routine for pip
 		2019-04-04 14:00:27 +02:00
galeranotify Introduce pip installable package 2019-04-04 14:00:27 +02:00
.gitignore Introduce pip installable package 2019-04-04 14:00:27 +02:00
LICENSE Initial commit 2013-09-26 11:13:12 -07:00
README.md Introduce pip installable package 2019-04-04 14:00:27 +02:00
galeranotify.pp initial commit 2013-09-26 11:31:36 -07:00
galeranotify.py Introduce pip installable package 2019-04-04 14:00:27 +02:00
galeranotify.te initial commit 2013-09-26 11:31:36 -07:00
galeranotify.yml Introduce pip installable package 2019-04-04 14:00:27 +02:00
setup.py Introduce pip installable package 2019-04-04 14:00:27 +02:00

README.md

galeranotify

Python E-Mail script for use with Galera wsrep_notify_cmd

This script immediately generates an E-Mail if Your cluster state changes, so You won't miss a second. Also duplicates are dropped. Using Galera for instance in combination with commercial backup software like Comvault leads to a whole buch of notifications without a state change. This is caused by Comvault illegaly LOCKing slave-tables while dumping data out of the cluster. Since the LOCK didn't last too long, the locked slave is pulled back to synced shortly after. Each locked table causes an E-Mail. Therefore galeranotify remembers its previous state and drops the message if no state change has really happend.

Installation

Install it via pip is the easiest way

pip install git+https://git.binary-kitchen.de/sprinterfreak/galeranotify
  • Place the galeranotify.yml under /etc/mysql and configure it.
  • Set 'wsrep_notify_cmd = galeranotify' in your my.cnf file
  • Restart MySql.

SELinux

A SELinux policy (galeranotify.pp) is also included that allows the mysql user to connect to a standard remote smtp port (port 25). If you are using an alternate SMTP port (common with SSL), this rule will not work for you.

Usage:

semodule -i galeranotify.pp

This rule was generated on Centos 6.4 64-bit. It may or may not work for your particular setup.