๊ด€๋ฆฌ ๋ฉ”๋‰ด

๋ชฉ๋กprivate subnet ec2 ๋กœ์ปฌ ์ ‘์† (1)

๐‘†๐‘ข๐‘›๐‘ โ„Ž๐‘–๐‘›๐‘’ ๐‘Ž๐‘“๐‘ก๐‘’๐‘Ÿ ๐‘Ÿ๐‘Ž๐‘–๐‘›โœง

[AWS] Private Subnet ๋‚ด๋ถ€ EC2 ์— MySQL ๋งŒ๋“ค๊ณ  SSH ํ„ฐ๋„๋ง์„ ํ†ตํ•ด ๋กœ์ปฌ์—์„œ MySQL ์ ‘์†ํ•˜๊ธฐ

ํ”„๋กœ์ ํŠธ๋ฅผ ์ง„ํ–‰ํ•˜๋ฉด์„œ ๋„์ปค๋กœ ๋„์šด MySQL๋ฅผ EC2 MySQL๋กœ ๋งˆ์ด๊ทธ๋ ˆ์ด์…˜์„ ํ•˜๊ธฐ๋กœ ํ–ˆ๋‹ค. ์ฒ˜์Œ์—๋Š” MySQL WorkBench์—์„œ ssh ์ ‘์†์„ ์‚ฌ์šฉํ•˜๋Š” Standard TCP/IP over SSH ์œผ๋กœ ์—ฐ๊ฒฐ์„ ์„ฑ๊ณตํ•˜์˜€๋‹ค. ํ•˜์ง€๋งŒ ์Šคํ”„๋ง๋ถ€ํŠธ application.yml ํŒŒ์ผ์—์„œ ์›๊ฒฉ DB ์„ค์ •์— ์‹คํŒจํ–ˆ๋‹ค..ใ… ใ…  ๋‹น์—ฐํ•œ๊ฒŒ ์Šคํ”„๋ง๋ถ€ํŠธ(๋กœ์ปฌ)์—์„œ ssh์„ค์ •์ด ์—†์œผ๋ฉด ์—ฐ๊ฒฐ์ด ๋ถˆ๊ฐ€๋Šฅํ–ˆ๋‹ค... ์Šคํ”„๋ง๋ถ€ํŠธ์— ssh ์„ค์ •์„ ์‹œ๋„ํ•ด๋ดค์ง€๋งŒ ์ฒ˜์ฐธํžˆ ์‹คํŒจํ–ˆ๋‹คใ…Ž ๊ทธ๋ž˜์„œ ํ•„์ž๋Š” SSH ํ„ฐ๋„์„ ์ƒ์„ฑํ•˜์—ฌ Local Port Forwarding ์œผ๋กœ Private Subnet์•ˆ์˜ EC2 MySQL์— ์ ‘์†ํ•˜์˜€๊ณ  ๋ฐฉ๋ฒ•์„ ๊ณต์œ ํ•ด๋ณด๊ณ ์ž ํ•œ๋‹ค. ํ˜„์žฌ ์„œ๋ฒ„ ํ™˜๊ฒฝ ํ˜„์žฌ ํ”„๋กœ์ ํŠธ ์„œ๋ฒ„ ํ™˜๊ฒฝ์€ ๋‘๊ฐœ์˜ ๊ฐ€์šฉ์˜์—ญ(ap-northeast-2a, ap..