34 lines
1.3 KiB
Markdown
34 lines
1.3 KiB
Markdown
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.
|