AWS Database Server

Contents

  • Database

  • RDS (Relational Database Services)

  • Amazon RDS for MySQL

Useful Informations

  1. AWS ์—์„œ๋Š” ํŠน์ • application ์‚ฌ์šฉ ์‚ฌ๋ก€์— ๋งž์ถœ ์ˆ˜ ์žˆ๋„๋ก ํŠน๋ณ„ํžˆ ๊ตฌ์ถ•๋œ ๋งค์šฐ ๋‹ค์–‘ํ•œ ๊ด€๊ณ„ํ˜• ๋ฐ ๋น„๊ด€๊ณ„ํ˜• database๋ฅผ ์ œ๊ณตํ•œ๋‹ค

  2. AWS ์™„์ „ ๊ด€๋ฆฌํ˜• database service๊ฐ€ ์ œ๊ณตํ•˜๋Š” ๊ฒƒ

    • Transaction application์„ ์œ„ํ•œ ๊ด€๊ณ„ํ˜• database

    • Internet ๊ทœ๋ชจ์˜ application์„ ์œ„ํ•œ ๋น„๊ด€๊ณ„ํ˜• database

    • ๋ถ„์„์„ ์œ„ํ•œ data warehouse

    • Caching, real-time workload๋ฅผ ์œ„ํ•œ In-memory data store

    • ์ƒํ˜ธ ์—ฐ๊ฒฐ์„ฑ์ด ๋†’์€ data๊ฐ€ ์žˆ๋Š” application ๊ตฌ์ถ•์„ ์œ„ํ•œ Graph Database

AWS Database

๋ชจ๋“  application์˜ ์š”๊ตฌ์— ๋งž์ถฐ ํŠน๋ณ„ํžˆ ๊ตฌ์ถ•๋œ database

  • Cloud ๋•๋ถ„์— storage ๋ฐ computing ๋น„์šฉ์ด ์ง€์†์ ์œผ๋กœ ํ•˜๋ฝํ•จ์— ๋”ฐ๋ผ ์ƒˆ๋กœ์šด ์„ธ๋Œ€์˜ application์ด ๋“ฑ์žฅํ•˜์—ฌ database์— ๋Œ€ํ•œ ์ƒˆ๋กœ์šด ์š”๊ตฌ ์‚ฌํ•ญ๋“ค์ด ์ œ๊ธฐ๋˜๊ณ  ์žˆ์Œ

  • Database๋ฅผ ํ…Œ๋ผ๋ฐ”์ดํŠธ์—์„œ ํŽ˜ํƒ€๋ฐ”์ดํŠธ ๊ทœ๋ชจ๋กœ ์ €์žฅํ•˜๊ณ , ๋ฐ€๋ฆฌ์ดˆ ๋‹จ์œ„ ์ง€์—ฐ ์‹œ๊ฐ„์œผ๋กœ data์— accessํ•˜๊ณ , ์ดˆ๋‹น ์ˆ˜๋ฐฑ๋งŒ ๊ฑด์˜ ์š”์ฒญ์„ ์ฒ˜๋ฆฌํ•˜๊ณ , ์ „ ์„ธ๊ณ„์ ์œผ๋กœ ์ˆ˜๋ฐฑ๋งŒ ๋ช…์˜ ์‚ฌ์šฉ์ž๋ฅผ ์ง€์›ํ•˜๋„๋ก ํ™•์žฅํ•  ์ˆ˜ ์žˆ์–ด์•ผํ•จ

    • Application์˜ ํŠน์ • ์š”๊ตฌ๋ฅผ ์ฒ˜๋ฆฌํ•˜๋„๋ก ํŠน๋ณ„ํžˆ ๊ตฌ์ถ•๋œ ๊ด€๊ณ„ํ˜• ๋ฐ ๋น„๊ด€๊ณ„ํ˜• database๊ฐ€ ๋ชจ๋‘ ํ•„์š”ํ•จ

  • AWS์—์„œ๋Š” ํŠน์ • application ์‚ฌ์šฉ ์‚ฌ๋ก€์— ๋งž์ถœ ์ˆ˜ ์žˆ๋„๋ก ํŠน๋ณ„ํžˆ ๊ตฌ์ถ•๋œ ๋‹ค์–‘ํ•œ database๋ฅผ ์ œ๊ณตํ•จ

  • ๊ธฐ์กด database๋ฅผ AWS๋กœ migration ํ•  ๋•Œ์—๋Š” AWS Database Migration Service ๋ฅผ ์‚ฌ์šฉํ•ด์„œ ์‰ฝ๊ณ  ๋น„์šฉ ํšจ์œจ์ ์ด๊ฒŒ migration ํ•  ์ˆ˜ ์žˆ์Œ

AWS ์™„์ „ ๊ด€๋ฆฌํ˜• Database Service

  1. RDBMS for Transaction application

  2. NoSQL Internet size application

  3. Data warehouse for analytics

  4. In-memory store for caching & real-time workload

    • ๊ฒŒ์ž„ ์ˆœ์œ„ํ‘œ, ์•ฑ ๊ธฐ๋ฐ˜ ์ฐจ๋Ÿ‰ ํ˜ธ์ถœ(ride hailing), Social Media Messaging, On-line shopping ๋“ฑ์˜ ์‹ค์‹œ๊ฐ„ application ์‚ฌ์šฉ ์‚ฌ๋ก€์—๋Š” micro์ดˆ ๋‹จ์œ„์˜ ์ง€์—ฐ ์‹œ๊ฐ„๊ณผ ๋†’์€ ์ฒ˜๋ฆฌ๋Ÿ‰์ด ํ•„์š”ํ•จ

    • ๋” ๋Š๋ฆฐ disk ๊ธฐ๋ฐ˜ database์— ์ „์ ์œผ๋กœ ์˜์กดํ•˜๊ธฐ ๋ณด๋‹ค๋Š”, ๋น ๋ฅธ ๊ด€๋ฆฌํ˜• In-memory data store & cache ์—์„œ ์ •๋ณด๋ฅผ ๊ฒ€์ƒ‰ํ•˜์—ฌ ์‹ค์‹œ๊ฐ„ application ์‚ฌ์šฉ ์‚ฌ๋ก€์˜ ์„ฑ๋Šฅ์„ ๊ฐœ์„  ํ•  ์ˆ˜ ์žˆ์Œ

    • Amazon ElasticCache ๋Š” cloud์—์„œ In-memory data store & cache๋ฅผ ์†์‰ฝ๊ฒŒ ๋ฐฐํฌ, ์‹คํ–‰ ๋ฐ ํ™•์žฅ ํ•  ์ˆ˜ ์žˆ๊ฒŒ ์ง€์›ํ•˜๋Š” Redis ๋˜๋Š” Memcached ํ˜ธํ™˜ In-memory data store & caching service

  5. ์ƒํ˜ธ ์—ฐ๊ฒฐ์„ฑ์ด ๋†’์€ data๊ฐ€ ์žˆ๋Š” application ๊ตฌ์ถ•์„ ์œ„ํ•œ Graph database

  6. ์‹œ๊ฐ„์— ๋”ฐ๋ฅด ๋ณ€ํ™”๋ฅผ ์ธก์ •ํ•˜๊ธฐ ์œ„ํ•œ ์‹œ๊ณ„์—ด database

  7. ์™„์ „ํ•˜๊ณ  ๊ฒ€์ฆ ๊ฐ€๋Šฅํ•œ transaction record๋ฅผ ์œ ์ง€/๊ด€๋ฆฌ ํ•˜๊ธฐ ์œ„ํ•œ ์›์žฅ database

Amazon Relational Database Service (RDS)

Click ๋ช‡ ๋ฒˆ์œผ๋กœ Cloud์—์„œ ๊ด€๊ณ„ํ˜• database๋ฅผ ์„ค์ •, ์šด์˜, ํ™•์žฅ

  • Cloud์—์„œ RDBMS๋ฅผ ๊ฐ„ํŽธํ•˜๊ฒŒ ์„ค์ •/์šด์˜ ํ•  ์ˆ˜ ์žˆ์Œ

  • Hardware provisioning, database ์„ค์ •, ํŒจ์น˜ ๋ฐ backup๊ณผ ๊ฐ™์€ ์‹œ๊ฐ„ ์†Œ๋ชจ์ ์ธ ๊ด€๋ฆฌ ์ž‘์—…์„ ์ž๋™ํ™”ํ•˜๋ฉด์„œ ๋น„์šฉ ํšจ์œจ์ ์ด๊ณ  ํฌ๊ธฐ ์กฐ์ • ๊ฐ€๋Šฅํ•œ ์šฉ๋Ÿ‰์„ ์ œ๊ณตํ•จ

  • ์‚ฌ์šฉ์ž๊ฐ€ Application์— ์ง‘์ค‘ํ•˜์—ฌ application์— ํ•„์š”ํ•œ ์„ฑ๋Šฅ, ๊ณ ๊ฐ€์šฉ์„ฑ (HA), ๋ณด์•ˆ ๋ฐ ํ˜ธํ™˜์„ฑ์„ ์ œ๊ณตํ•  ์ˆ˜ ์žˆ๋„๋ก ์ง€์›ํ•จ

  • Amazon RDS๋Š” ์—ฌ๋Ÿฌ database instance ์œ ํ˜• (memory, performance, I/O optimization) ์œผ๋กœ ์ œ๊ณต๋˜๋ฉฐ Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database ๋ฐ SQL Server๋ฅผ ๋น„๋กฏํ•œ 6๊ฐœ์˜ database engine ์ค‘์—์„œ ์„ ํƒํ•  ์ˆ˜ ์žˆ์Œ

  • AWS Database Migration Service ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๊ธฐ์กด database๋ฅผ Amazon RDS ๋กœ migration or duplicate ๊ฐ€๋Šฅ

Amazon RDS Database Engine

1. Amazon Aurora

  • ๊ณ ์„ฑ๋Šฅ ์ƒ์šฉ database์˜ ์†๋„์™€ ๊ฐ€์šฉ์„ฑ์— open source database์˜ ๊ฐ„ํŽธ์„ฑ๊ณผ ๋น„์šฉ ํšจ์œจ์„ฑ์„ ๊ฒฐํ•ฉํ•œ MySQL ๋ฐ PostgreSQL ํ˜ธํ™˜ RDBMS engine

  • MySQL๋ณด๋‹ค 5๋ฐฐ ๋›ฐ์–ด๋‚œ ์„ฑ๋Šฅ๊ณผ ์ƒ์šฉ database์˜ ๋ณด์•ˆ์„ฑ, ๊ฐ€์šฉ์„ฑ ๋ฐ ์•ˆ์ •์„ฑ์„ 1/10์˜ ๋น„์šฉ์œผ๋กœ ์ œ๊ณตํ•จ

2. Oracle

  • Amazon RDS์—์„œ๋Š” ๋น„์šฉ ํšจ์œจ์ ์ด๋ฉด์„œ ํฌ๊ธฐ ์กฐ์ •์ด ๊ฐ€๋Šฅํ•œ hardware ์šฉ๋Ÿ‰์„ ๊ฐ–์ถ˜ ์—ฌ๋Ÿฌ version์˜ Oracle Database๋ฅผ ๋ช‡ ๋ถ„ ๋งŒ์— ๋ฐฐํฌ ํ•  ์ˆ˜ ์žˆ์Œ

  • ๊ธฐ์กด์˜ Oracle license๋ฅผ ๊ฐ€์ ธ์˜ค๊ฑฐ๋‚˜ 1์‹œ๊ฐ„ ๋‹จ์œ„๋กœ license ์‚ฌ์šฉ๋ฃŒ๋ฅผ ์ง€๋ถˆํ•  ์ˆ˜ ์žˆ์Œ

  • RDS๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด provisioning backup, patch, monitor, hardware expansion ๋“ฑ ๋ณต์žกํ•œ database ๊ด€๋ฆฌ ์ž‘์—…์„ ๊ด€๋ฆฌํ•ด์ฃผ๋ฏ€๋กœ ์‚ฌ์šฉ๋Š” application ๊ฐœ๋ฐœ์— ์ง‘์ค‘ ํ•  ์ˆ˜ ์žˆ์Œ

3. (Microsoft) SQL Server

  • SQL Server์šฉ Amazon RDS๋ฅผ ํ™œ์šฉํ•˜๋ฉด cloud์—์„œ SQL Server๋ฅผ ์‰ฝ๊ฒŒ ์„ค์น˜, ์šด์˜ ๋ฐ ํ™•์žฅ ํ•  ์ˆ˜ ์žˆ์Œ

  • Express, Web, Standard ๋ฐ Enterprise ๋ฅผ ํฌํ•จํ•œ ์—ฌ๋Ÿฌ version์˜ SQL Server๋ฅผ ๋ฐฐํฌ ํ•  ์ˆ˜ ์žˆ์Œ

  • SQL Server์šฉ Amazon RDS๋Š” SQL Server์˜ ๊ธฐ๋ณธ ๊ธฐ๋Šฅ์— ์ง์ ‘ access ํ•  ๊ถŒํ•œ์„ ์ œ๊ณตํ•˜๊ธฐ ๋•Œ๋ฌธ์— ์‚ฌ์šฉ์ค‘์ธ application๊ณผ ๋„๊ตฌ๋“ค์€ ์•„๋ฌด๋Ÿฐ ๋ณ€๊ฒฝ ์—†์ด ์ž‘๋™ํ•ด์•ผํ•จ

4. MySQL

  • ๋งค์šฐ ๋งŽ์€ web supplication์—์„œ ์‚ฌ์šฉํ•˜๋Š” open source RDBMS

  • ๊ธฐ์กด database ์—์„œ ์ด๋ฏธ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋Š” code, application, ๋„๊ตฌ ๋“ฑ์„ ์•„๋ฌด๋Ÿฐ ๋ณ€๊ฒฝ ์—†์ด Amazon RDS์—์„œ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Œ

5. PostgreSQL

  • ํ™•์žฅ์„ฑ ๋ฐ ํ‘œ์ค€ ์ค€์ˆ˜์— ์ค‘์ ์„ ๋‘” ๊ฐ•๋ ฅํ•œ enterprise ๊ธ‰ open source RDBMS

  • ์—ฌ๋Ÿฌ๊ฐ€์ง€ ์ •๊ตํ•œ ๊ธฐ๋Šฅ๋“ค์„ ์ž๋ž‘ํ•˜๋ฉฐ Java, Perl, Python, Ruby, Tcl, C/C++ ๋ฐ Oracle์˜ PL/SQL๊ณผ ์œ ์‚ฌํ•œ ์ž์ฒด PL/pgSQL์„ ํฌํ•จํ•ด 12๊ฐœ ์ด์ƒ์˜ programming languages๋กœ ์ €์žฅ๋œ procedure๋ฅผ ์‹คํ–‰ํ•จ

6. MariaDB

  • MySQL์˜ ํ•œ ๊ฐˆ๋ž˜์— ์†ํ•˜๋Š” MySQL ํ˜ธํ™˜ database engine์œผ๋กœ์„œ MySQL์˜ ์ตœ์ดˆ ๊ฐœ๋ฐœ์ž๋“ค์ด ๊ฐœ๋ฐœํ•˜๊ณ  ์žˆ์Œ

  • Amazon RDS๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด cloud์—์„œ MySQL ๋ฐฐํฌ๋ฅผ ์†์‰ฝ๊ฒŒ ์„ค์ •, ์šด์˜ ๋ฐ ํ™•์žฅํ•  ์ˆ˜ ์žˆ์Œ

  • Amazon RDS์—์„œ๋Š” ๋น„์šฉ ํšจ์œจ์ ์ด๋ฉฐ ํฌ๊ธฐ ์กฐ์ •์ด ๊ฐ€๋Šฅํ•œ hardware ์šฉ๋Ÿ‰์„ ๊ฐ–์ถ˜ ํ™•์žฅ ๊ฐ€๋Šฅํ•œ MariaDB database๋ฅผ ๋ช‡ ๋ถ„ ๋งŒ์— ๋ฐฐํฌํ•  ์ˆ˜ ์žˆ์Œ

Amazon RDS for MySQL

Click ๋ช‡ ๋ฒˆ์œผ๋กœ cloud์—์„œ RDBMS๋ฅผ ์„ค์ •, ์šด์˜ ๋ฐ ํ™•์žฅ

  • Amazon RDS๋Š” MySQL Community Edition version 5.5, 5.6, 5.7 ๋ฐ 8.0์„ ์ง€์›ํ•˜๋ฏ€๋กœ ํ˜„์žฌ ์‚ฌ์šฉ์ค‘์ธ ์ฝ”๋“œ, application, ๋„๊ตฌ์—์„œ Amazon RDS๋ฅผ ์‚ฌ์šฉ ํ•  ์ˆ˜ ์žˆ์Œ

  • MySQL์šฉ Amazon RDS๋Š” ๋‹ค์ˆ˜์˜ ์‚ฐ์—… ํ‘œ์ค€์„ ์ค€์ˆ˜ํ•จ

    • Region ๋ณ„๋กœ ์ค€์ˆ˜๋˜๋Š” ํ‘œ์ค€์ด ๋‹ค๋ฅด๋ฏ€๋กœ ๊ฐ๊ฐ ์กฐ์‚ฌํ•  ํ•„์š” ์žˆ์Œ!

  • FedRAMP (์—ฐ๋ฐฉ ์œ„ํ—˜ ๋ฐ ์ธ์ฆ ๊ด€๋ฆฌ ํ”„๋กœ๊ทธ๋žจ) ๋ณด์•ˆ ์š”๊ฑด์„ ์ถฉ์กฑํ•˜๋ฉฐ FedRAMP ๊ณต๋™ ์Šน์ธ ์œ„์›ํšŒ (JAB)๋กœ ๋ถ€ํ„ฐ AWS GovCloud(๋ฏธ๊ตญ ์„œ๋ถ€) region ๋‚ด์—์„œ ํ–‰์‚ฌ ํ•  ์ˆ˜ ์žˆ๋Š” FedRAMP HIGH Baseline ์ˆ˜์ค€์˜ ์ž ์ •์  ์šด์˜ ๊ถŒํ•œ (P-ATO)๋ฅผ ์ทจ๋“ํ–ˆ์Œ

  • Amazon RDS๋Š” ์—ฌ๋Ÿฌ MySQL version์„ ์‹คํ–‰ํ•˜๋Š” DB instance๋ฅผ ์ง€์›ํ•จ

    • MySQL 8.0

    • MySQL 5.7

    • MySQL 5.6

    • MySQL 5.5

  • ์‚ฌ์šฉ์ž๋Š” ๋จผ์ € Amazon RDS ๊ด€๋ฆฌ ๋„๊ตฌ ๋˜๋Š” interface๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ Amazon RDS MySQL DB instance๋ฅผ ์ƒ์„ฑํ•จ

  • DB instance ํฌ๊ธฐ ์กฐ์ •, DB instance์— ๋Œ€ํ•œ ์—ฐ๊ฒฐ ์ธ์ฆ, backup ๋˜๋Š” snapshot ์ƒ์„ฑ ๋ฐ ๋ณต์›, ๋‹ค์ค‘ AZ ๋ณด์กฐ ์ƒ์„ฑ, ์ฝ๊ธฐ ์ „์šฉ ๋ณต์ œ๋ณธ ์ƒ์„ฑ ๋ฐ DB instance์˜ ์„ฑ๋Šฅ ๋ชจ๋‹ˆํ„ฐ๋ง์ด ๊ฐ€๋Šฅํ•จ

  • ํ‘œ์ค€ MySQL utility ๋ฐ application์„ ์‚ฌ์šฉํ•˜์—ฌ DB instance์—์„œ data๋ฅผ ์ €์žฅํ•˜๊ณ  data์— access ํ•  ์ˆ˜ ์žˆ์Œ

Summary

: AWS Database๋Š” database๋ฅผ ํ…Œ๋ผ๋ฐ”์ดํŠธ์—์„œ ํŽ˜ํƒ€๋ฐ”์ดํŠธ ๊ทœ๋ชจ๋กœ ์ €์žฅํ•˜๊ณ , ๋ฐ€๋ฆฌ์ดˆ ๋‹จ์œ„ ์ง€์—ฐ์‹œ๊ฐ„์œผ๋กœ data์— access ํ•˜๊ณ , ์ดˆ๋‹น ์ˆ˜๋ฐฑ๋งŒ ๊ฑด์˜ ์š”์ฒญ์„ ์ฒ˜๋ฆฌํ•˜๊ณ , ์ „ ์„ธ๊ณ„์ ์œผ๋กœ ์ˆ˜๋ฐฑ๋งŒ๋ช…์˜ ์‚ฌ์šฉ์ž๋ฅผ ์ง€์›ํ•  ์ˆ˜ ์žˆ๋„๋ก ํ™•์žฅํ•  ์ˆ˜ ์žˆ๋Š” ์„œ๋น„์Šค๋ฅผ ์ œ๊ณตํ•œ๋‹ค

Last updated

Was this helpful?