projects
/
pgpool-online-recovery
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
5a3ce21
)
test killing slave, recovery, killing master
author
Dobrica Pavlinusic
<dpavlin@rot13.org>
Wed, 23 Aug 2017 07:05:08 +0000
(09:05 +0200)
committer
Dobrica Pavlinusic
<dpavlin@rot13.org>
Wed, 23 Aug 2017 07:05:08 +0000
(09:05 +0200)
README.md
patch
|
blob
|
history
diff --git
a/README.md
b/README.md
index
603e386
..
1ddcfcc
100644
(file)
--- a/
README.md
+++ b/
README.md
@@
-28,11
+28,11
@@
If you edited local files, push changes to all nodes using:
make push
make push
-To restart
all services (pgoool and postgresql
) do:
+To restart
pgpool (and cleanup it's state
) do:
make restart
make restart
-If you want to see systemd status of
pgpool and replication
just type:
+If you want to see systemd status of
services
just type:
make status
make status
@@
-40,11
+40,21
@@
make status
Now you can start './t/80-insert-test.sh' in one terminal to create insert and select load on cluster and
kill one of nodes with 'echo b > /proc/sysrq-trigger'
Now you can start './t/80-insert-test.sh' in one terminal to create insert and select load on cluster and
kill one of nodes with 'echo b > /proc/sysrq-trigger'
-To issue online recovery, you can use
+For example, kill slave:
+
+ssh root@10.200.1.62 'echo b > /proc/sysrq-trigger'
+
+pgpool should detect broken back-end and remove it.
+You can verify that using just 'make' and see that one node is down.
+To issue online recovery, you can use:
make fix
make fix
+now, try to kill master:
+
+ssh root@10.200.1.61 'echo b > /proc/sysrq-trigger'
+FIXME: pgpool is stuck and needs to be restarted
If installing on existing streaming replication you will need to tell pgpool where current master is with:
If installing on existing streaming replication you will need to tell pgpool where current master is with: