commit 89c8c3fc5b4785f84f0d6ce1c66174f324f583ce
author Petr Michalec <pmichalec@mirantis.com> Mon May 22 17:19:22 2017 +0200
committer Petr Michalec <epcim@apealive.net> Tue May 30 17:28:03 2017 +0200
tree 196deba6f2cfbffeac3dfa1fcfcce0af029ed6be
parent bca6ffa7275996be6a50b59983e5b2fb0f2a4a18

add clustercheck script (avoid splitbrain)

tests/pillar/master_cluster.sls

diff --git a/tests/pillar/master_cluster.sls b/tests/pillar/master_cluster.sls
index a12e7d7..bd27fa2 100644
--- a/tests/pillar/master_cluster.sls
+++ b/tests/pillar/master_cluster.sls
@@ -7,7 +7,7 @@
         port: 3306
       maintenance_password: password
       admin:
-        user: user
+        user: root
         password: password
       members:
       - host: 127.0.0.1
@@ -16,6 +16,13 @@
         port: 4567
       - host: 127.0.0.1
         port: 4567
+    clustercheck:
+      enabled: True
+      user: clustercheck
+      password: password
+      available_when_donor: 1
+      available_when_readonly: 1
+      port: 9200
   mysql:
     server:
       users:
@@ -27,17 +34,15 @@
         host: 127.0.0.1
       - name: clustercheck
         #host: localhost
-        password: clustercheck
+        password: password
         database: '*.*'
         grants: PROCESS
-        grant_option: False
       - name: inspector
         host: 127.0.0.1
         password: password
         databases:
-          mydb:
-            - database: mydb
-            - table: mytable
-            - grant_option: False
-            - grants:
-              - all privileges
+          - database: mydb
+            table: mytable
+            grant_option: True
+            grants:
+            - all privileges

tests/pillar/slave_cluster.sls

diff --git a/tests/pillar/slave_cluster.sls b/tests/pillar/slave_cluster.sls
index 10dfccb..73bf999 100644
--- a/tests/pillar/slave_cluster.sls
+++ b/tests/pillar/slave_cluster.sls
@@ -7,7 +7,7 @@
         port: 3306
       maintenance_password: password
       admin:
-        user: user
+        user: root
         password: password
       members:
       - host: 127.0.0.1
@@ -16,6 +16,13 @@
         port: 4567
       - host: 127.0.0.1
         port: 4567
+    clustercheck:
+      enabled: True
+      user: clustercheck
+      password: password
+      available_when_donor: 1
+      available_when_readonly: 1
+      port: 9200
   mysql:
     server:
       users:
@@ -24,4 +31,9 @@
       - name: haproxy
         host: '%'
       - name: haproxy
-        host: 127.0.0.1
\ No newline at end of file
+        host: 127.0.0.1
+      - name: clustercheck
+        #host: localhost
+        password: password
+        database: '*.*'
+        grants: PROCESS