All pages
1 of 1

Loading...

OpenSQL ๊ฐœ์š”

OpenSQL v3.0 ์€ ์˜คํ”ˆ์†Œ์Šค ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ด€๋ฆฌ์‹œ์Šคํ…œ (RDBMS) ์ธ PostgreSQL์„ ๊ธฐ๋ฐ˜์œผ๋กœ ๋†’์€ ์„ฑ๋Šฅ๊ณผ ๊ณ ๊ฐ€์šฉ์„ฑ์„ ์ œ๊ณตํ•˜๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํด๋Ÿฌ์Šคํ„ฐ์ž…๋‹ˆ๋‹ค.

OpenSQL v3.0 ๊ตฌ์„ฑ ์˜ˆ์‹œ

OpenSQL Components

OpenSQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค

PostgreSQL ๊ธฐ๋ฐ˜์˜ ์˜คํ”ˆ์†Œ์Šค ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ด€๋ฆฌ ์‹œ์Šคํ…œ์œผ๋กœ ๋›ฐ์–ด๋‚œ ํ™•์žฅ์„ฑ๊ณผ SQL ํ‘œ์ค€์„ ์ค€์ˆ˜ํ•ฉ๋‹ˆ๋‹ค.

OpenHA

OpenSQL ํด๋Ÿฌ์Šคํ„ฐ์˜ ๊ณ ๊ฐ€์šฉ์„ฑ์„ ๋‹ด๋‹นํ•˜๋Š” ์†”๋ฃจ์…˜์œผ๋กœ, OpenHA Cluster Manager์™€ OpenHA DCS๋กœ ๊ตฌ์„ฑ๋ฉ๋‹ˆ๋‹ค.

  • OpenHA Cluster Manager Patroni ๊ธฐ๋ฐ˜์˜ ํด๋Ÿฌ์Šคํ„ฐ ๊ด€๋ฆฌ ๋ชจ๋“ˆ๋กœ, ๊ฐ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋…ธ๋“œ์˜ ์ƒํƒœ๋ฅผ ์‹ค์‹œ๊ฐ„ ๊ฐ์ง€ํ•˜๊ณ  ์ž๋™ Failover, Primary ๋…ธ๋“œ ์„ ์ถœ, ๊ตฌ์„ฑ ๋ณ€๊ฒฝ ๊ด€๋ฆฌ ๊ธฐ๋Šฅ์„ ์ˆ˜ํ–‰ํ•ฉ๋‹ˆ๋‹ค.

  • OpenHA DCS(Distributed Configuration Store)

    etcd ๊ธฐ๋ฐ˜์˜ ๋ถ„์‚ฐ ํ‚ค-๊ฐ’ ์ €์žฅ์†Œ๋กœ, OpenSQL ํด๋Ÿฌ์Šคํ„ฐ์˜ ๋ฉค๋ฒ„์‹ญ ๋ฐ ๊ตฌ์„ฑ ์ •๋ณด๋ฅผ ์•ˆ์ •์ ์œผ๋กœ ์ €์žฅยท๊ณต์œ ํ•ฉ๋‹ˆ๋‹ค.

PostgreSQL ์ปค๋„ฅ์…˜ํ’€๋ง, ๋กœ๋“œ๋ฐธ๋Ÿฐ์‹ฑ ๋ฐ VIP Failover ๊ธฐ๋Šฅ์„ ์ œ๊ณตํ•˜๋ฉฐ, Rust ์–ธ์–ด๋กœ ์ž‘์„ฑ๋œ ๊ณ ์„ฑ๋Šฅ Connection Pooler ์ž…๋‹ˆ๋‹ค.

Full, ์ฆ๋ถ„, ์ฐจ๋ถ„ ๋ฐฑ์—… ๋ฐฉ์‹์„ ์ œ๊ณตํ•˜๋ฉฐ, Python ์–ธ์–ด๋กœ ์ž‘์„ฑ๋œ ์˜คํ”ˆ์†Œ์Šค PostgreSQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฐฑ์—… ๊ด€๋ฆฌ ์†”๋ฃจ์…˜์ž…๋‹ˆ๋‹ค.

OpenProxy

Barman