File: README.online-recovery

package info (click to toggle)
pgpool2 3.3.4-1~bpo70%2B1
  • links: PTS, VCS
  • area: main
  • in suites: wheezy-backports
  • size: 9,196 kB
  • sloc: ansic: 59,850; sh: 12,893; yacc: 10,787; lex: 4,637; sql: 743; makefile: 481; java: 469; php: 125; ruby: 98; asm: 5
file content (62 lines) | stat: -rw-r--r-- 2,156 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
/*
 * $Header$
 *
 * pgpool: a language independent connection pool server for PostgreSQL 
 * written by Tatsuo Ishii
 *
 * Copyright (c) 2003-2010	PgPool Global Development Group
 *
 * Permission to use, copy, modify, and distribute this software and
 * its documentation for any purpose and without fee is hereby
 * granted, provided that the above copyright notice appear in all
 * copies and that both that copyright notice and this permission
 * notice appear in supporting documentation, and that the name of the
 * author not be used in advertising or publicity pertaining to
 * distribution of the software without specific, written prior
 * permission. The author makes no representations about the
 * suitability of this software for any purpose.  It is provided "as
 * is" without express or implied warranty.
 *
 */

How does online reconvery work?

pcp_recovery_node calls pcp_recovery_node() API

pcp_recovery_node(int node_id) does:

  pcp_recovery_node sends "O" to pcp_child process requesting online
  recovery

    pcp_child calls start_recovery() and waits for its completion

	  start_recovery() sets Req_info->kind to NODE_RECOVERY_REQUEST
	    start_recovery calls execute_checkpoint() execute CHEKPOINT
	    command
	    start_recovery calls exec_recovery
	      exec_recovery executes SELECT pgpool_recovery()
		  execute 1st stage command		

		/* start 2nd stage */
		sets InRecovery to 1
		wait_connection_closed() to wait for all frontend exits
	    calls execute_checkpoint() execute CHEKPOINT
	    calls exec_recovery to execute 2nd stage script
		calls exec_remote_start to start postmaster
		calls check_postmaster_started to wait for postmaster starts
		up
		set pcp_wakeup request to 0
		calls send_failback_request()
		waits for failback completion every 1 second until
		pcp_wakeup_request becomes non 0.
		set pcp_wakeup request to 0

	  start_recovery calls finish_recovery()
	    finish_recovery sets InRecovery to 0
		sends SIGUSR2 signal to parent

		  Upon receiving SIGUSR2 pgpool parent calls
		  kill_all_children() which sends SIGUSR2 to all pgpool
		  children

		  child pgpool processes wake up from pause()