eRadical · September 12, 2017 09:44 · Nov 30, 2015
diff --git a/clustercheck.socket b/clustercheck.socket
@@ -0,0 +1,11 @@
+# /etc/systemd/system/clustercheck.socket
+
+[Unit]
+Description=MySQL Clustercheck Socket
+
+[Socket]
+ListenStream=9200
+Accept=true
+
+[Install]
+WantedBy=sockets.target
diff --git a/[email protected] b/[email protected]
@@ -0,0 +1,10 @@
+# /etc/systemd/system/[email protected]
+
+[Unit]
+Description=MySQL Clustercheck
+After=network.target
+
+[Service]
+User=nobody
+ExecStart=-/usr/bin/clustercheck clustercheck AoWdTTItrUqNo9aNY
+StandardInput=socket
diff --git a/mysql_clustercheck.conf b/mysql_clustercheck.conf
@@ -0,0 +1,6 @@
+# /etc/rsyslog.d/mysql_clustercheck.conf
+#
+# systemd log fixup - No, we don't want to log mysql clustercheck systemd
+# messages everytime haproxy connects (every 500ms per LB in our case)
+if $programname == 'systemd' and $msg contains 'Starting MySQL Clustercheck' then stop
+if $programname == 'systemd' and $msg contains 'Started MySQL Clustercheck' then stop
diff --git a/systemd_MySQL_Clustercheck.md b/systemd_MySQL_Clustercheck.md
@@ -0,0 +1,11 @@
+## Systemd Clustercheck
+Clustercheck is a script to make a proxy (ie. haproxy) capable of monitoring Percona XtraDB Cluster nodes properly.
+This is a config to run clustercheck/mysqlchk from systemd instead of xinetd.
+
+## INSTALL
+```
+cp clustercheck.socket /etc/systemd/system
+cp [email protected] /etc/systemd/system
+systemctl enable clustercheck.socket
+systemctl start clustercheck.socket
+```