PostgreSQL 2

# PostgreSQL - MySQL ์ฐจ์ด์ 

PostgreSQL๊ณผ MySQL ๊ฐ„์˜ ๊ธฐ๋Šฅ๋ณ„ ํŠน์ง• ์ฐจ์ด๋ฅผ ์•„๋ž˜ ํ‘œ๋กœ ์ •๋ฆฌํ–ˆ๋‹ค. ๊ฒฐ๋ก  ์–ด๋–ค DB๊ฐ€ ๋” ์ข‹์€์ง€ ์–˜๊ธฐํ•˜๋Š”๊ฑด ๋ฌด์˜๋ฏธํ•œ ๋…ผ์Ÿ์ด์ง€๋งŒ ๊ฐœ์ธ์ ์œผ๋กœ PostgreSQL์„ ๋” ์„ ํ˜ธํ•œ๋‹ค. ์ด์œ ๋กœ๋Š” MySQL์— ๋น„ํ•ด ๋” ๋งŽ์€ ๊ธฐ๋Šฅ์„ ์ง€์›ํ•˜๊ณ  ๋Œ€์šฉ๋Ÿ‰ ์‹œ์Šคํ…œ์— ๋”์šฑ ์ ํ•ฉํ•˜๋‹ค๊ธฐ ๋•Œ๋ฌธ์ด๋‹ค. ๊ทธ๋ ‡์ง€๋งŒ ๋งŒ์•ฝ ๋Œ€์šฉ๋Ÿ‰ ์‹œ์Šคํ…œ์ด ์•„๋‹ˆ๋ฉฐ, ๋‹จ์ˆœํ•œ ์ฟผ๋ฆฌ๋ฅผ ์ด์šฉํ•œ ์ฝ๊ธฐ ์ค‘์‹ฌ์˜ ์ž‘์—…์ด ๋งŽ์€ ๊ฒฝ์šฐ MySQL์ด ์„ฑ๋Šฅ์ƒ ๋” ํšจ์œจ์ ์ผ ์ˆ˜ ์žˆ๊ธฐ ๋•Œ๋ฌธ์— ๊ฐ์ž์˜ ์‹œ์Šคํ…œ์— ๋”ฐ๋ฅธ ์ ํ•ฉํ•œ DB๋ฅผ ์„ ํƒํ•ด์•ผ ํ•  ๊ฒƒ์ด๋‹ค. ์ฐธ๊ณ  DB ์šฉ์–ด * OLTP (Online Transaction Processing) - ์˜จ๋ผ์ธ ํŠธ๋žœ์žญ์…˜ ์ฒ˜๋ฆฌ DB์—์„œ์˜ ๋นˆ๋ฒˆํ•œ ์ž…๋ ฅ, ์ˆ˜์ •, ์‚ญ์ œ ๊ณผ์ •์—์„œ์˜ ํšจ์œจ์„ฑ, ์ฆ‰ ํšจ๊ณผ์ ์ธ DB ๊ฐฑ์‹ ์ด ๋ชฉํ‘œ RDB ์—์„œ ์ •๊ทœํ™”๋ž€ ๋ฐ์ดํ„ฐ๊ฐ€ ํ•จ์ˆ˜์  ..

Database 2020.10.12

# PostgreSQL Streaming Replication ๊ตฌ์„ฑ

์ด์ „ ๊ธ€(# PostgreSQL Streaming Replication ๊ฐœ๋…)์—์„œ PostgreSQL Replication์— ๋Œ€ํ•œ ๊ฐœ๋…์„ ์‚ดํŽด๋ดค๊ณ  ์ด์ œ ์‹ค์ œ ๊ตฌ์„ฑ์„ ํ•ด๋ณด์ž. Step 1. PostgreSQL11 ์„ค์น˜ $ rpm -Uvh https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm $ yum install -y postgresql11-server postgresql11-contrib Step 2. PostgreSQL ์‹คํ–‰ # init db $cd /usr/pgsql-11/bin $ ./postgresql-11-setup initdb # postgresql ์‹คํ–‰ $ sys..

Database/PostgreSQL 2019.10.23