๊ถŒํ•œ 2

[H2] h2 ์„ค์น˜ ๋ฐ ์‚ฌ์šฉํ•˜๊ธฐ

h2๋ฅผ ์ž์ฃผ ์‚ฌ์šฉํ•˜์ง€ ์•Š์•„ ๋‹ค์‹œ ์„ค์น˜ํ•˜๊ณ  ์‚ฌ์šฉํ•  ๋•Œ๋งˆ๋‹ค ๊ฒ€์ƒ‰์„ ํ•˜๊ฒŒ ๋˜์–ด ์ž‘์„ฑํ•ด ๋ณด๋ ค ํ•ฉ๋‹ˆ๋‹ค. ๊ฐ„๋‹จํ•œ ์„ค์น˜ ๋ฐฉ๋ฒ•๊ณผ ์‚ฌ์šฉ๋ฒ•์„ ์ž‘์„ฑํ•ด ๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค. H2 DB? oracle, mysql๊ณผ ๊ฐ™์€ relation DB์ž…๋‹ˆ๋‹ค. ํ•˜์ง€๋งŒ ๋‹ค๋ฅธ DB๋“ค๊ณผ ๋‹ฌ๋ฆฌ ๊ฐ€๋ณ๊ณ  ์„ค์น˜๊ฐ€ ์‰ฝ๊ณ , ๊ด€๋ฆฌ๊ฐ€ ํŽธํ•˜๊ธฐ ๋•Œ๋ฌธ์— ๊ฐ€๋ฒผ์šด ์‚ฌ์ด๋“œ ํ”„๋กœ์ ํŠธ๋‚˜ ํ…Œ์ŠคํŠธ ์šฉ์œผ๋กœ ๋งŽ์ด ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค. ํŠน์ง• ๋น ๋ฅด๊ณ  ์˜คํ”ˆ์†Œ์Šค์ธ JDBC API In Memory DB(์ธ ๋ฉ”๋ชจ๋ฆฌ DB)* Embedded mode(๋‚ด์žฅ๋ชจ๋“œ) & Server mode(์„œ๋ฒ„๋ชจ๋“œ) ์ง€์› ๋ธŒ๋ผ์šฐ์ € ๊ธฐ๋ฐ˜ ์ฝ˜์†” ํ”„๋กœ๊ทธ๋žจ 2MB์ •๋„์˜ ์ ์€ ์šฉ๋Ÿ‰์œผ๋กœ ์„ค์น˜ ๊ฐ€๋Šฅ ANSI ํ‘œ์ค€ SQL๋กœ ์—ฌ๋Ÿฌ ํ˜ธํ™˜์„ฑ ๋ชจ๋“œ ์ง€์› Embedded Mode vs Server Mode Embedded mode(๋‚ด์žฅ๋ชจ๋“œ) : App..

Database 2022.02.12

[SSH]authorized_keys๊ฐ€ ์กด์žฌํ•˜๋Š”๋ฐ๋„ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ๋ฌผ์–ด๋ณผ ๊ฒฝ์šฐ

authorized_keys๊ฐ€ ์กด์žฌํ•˜๋Š”๋ฐ๋„ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ๋ฌผ์–ด๋ณผ ๊ฒฝ์šฐ .sshํŒŒ์ผ ์ƒ์„ฑ, scp๋กœ rsa_id.pub -> authorized_keys๋กœ ๋ณต์‚ฌ /home/eisen/.ssh/authorized_keys์— ํŒŒ์ผ์ด ์กด์žฌํ•˜๋Š”๋ฐ๋„ ๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ์„ ํ•˜๋ผ๊ณ  ์š”๊ตฌํ•  ์‹œ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ•์ž…๋‹ˆ๋‹ค. ssh -v eisen@localhost ๋กœ ๋กœ๊ทธ๋ฅผ ํ™•์ธ ํ–ˆ์„ ์‹œ โฏ ssh -v jmocha@172.30.130.176 OpenSSH_8.5p1, OpenSSL 1.1.1k 25 Mar 2021 debug1: Reading configuration data /c/Users/Eisen/.ssh/config debug1: Reading configuration data /etc/ssh/ssh_config debug1: Co..

CS 2021.09.10
728x90
๋ฐ˜์‘ํ˜•