๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
  • A space that records me :)

Connection pool1

[PostgreSQL] Pgpool-II + Watchdog setting [2021.10.29] PostgreSQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„œ๋ฒ„ 2๋Œ€๋ฅผ ๊ตฌ์„ฑํ•˜๋˜ ์ค‘, PostgreSQL๋งŒ์œผ๋กœ๋Š” ์ž๋™ ์•„์นด์ด๋น™ ๋ณต์ œ๋Š” ๋˜์ง€๋งŒ ์ž๋™ failover๋Š” ๋˜์ง€ ์•Š๋Š”๋‹ค๋Š” ๊ฒƒ์„ ์•Œ๊ฒŒ๋˜์—ˆ๋‹ค. Auto Failovr ๋ฅผ ์œ„ํ•ด ์•Œ์•„๋ณด๋˜ ์ค‘ ๋Œ€ํ‘œ์ ์ธ Pgpool-II์„ ์•Œ๊ฒŒ๋˜์—ˆ๊ณ , ์ด ํˆด์ด PostgreSQL์˜ ์ปค๋„ฅ์…˜ ํ’€ ๊ด€๋ฆฌ๋„ ํ•ด์ค€๋‹ค๋Š” ๊ฒƒ์„ ์•Œ๊ฒŒ๋˜์—ˆ๋‹ค. failback๋„ ์ž๋™์œผ๋กœ ์ง€์›ํ•ด์ฃผ๋Š” ๊ฒƒ ๊ฐ™์ง€๋งŒ, ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„œ๋ฒ„ ์ปค๋„ฅ์…˜์„ ์–ป์–ด์˜ค์ง€ ๋ชปํ•œ๋‹ค๋Š” ๊ฒƒ์€, ํ˜„์žฌ ๊ทธ ์„œ๋ฒ„์— ์–ด๋–ค ๋ฌธ์ œ๊ฐ€ ์žˆ๋‹ค๋Š” ๊ฒƒ์ด๊ณ  ์‚ฌ๋žŒ์˜ ์ง์ ‘์ ์ธ ๋ถ„์„์ด ํ•„์š”ํ•˜๋ฏ€๋กœ failback์€ ์ž๋™์œผ๋กœ ๊ตฌ์„ฑํ•˜์ง€ ์•Š์•˜๋‹ค. ๋Œ€์‹  recovery -> start -> pgpool attach node ๋‹จ๊ณ„๋ณ„๋กœ ์ œ๊ณตํ•˜๋Š” ์Šคํฌ๋ฆฝํŠธ๋ฅผ ๋งŒ๋“ค์—ˆ๋‹ค. ์‹œํ–‰์ฐฉ์˜ค๊ฐ€ ์ •๋ง ๋งŽ.. 2021. 10. 29.

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”