๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

728x90

MariaDB

9/8 ๋ชฉ 1. pymysql import pymysql class Py2DB: pass # ์—ฌ๊ธฐ๋„ ์‹คํ–‰์€ ๋˜์ง€๋งŒ ์‚ฌ์šฉ์€ ์ง€์–‘. ํด๋ž˜์Šค ํ˜ธ์ถœ ์‹œ ์ถœ๋ ฅ๋˜๋Š” ๊ฒƒ์„ ์›ํ•˜์ง€ ์•Š๋Š”๋‹ค๋ฉด ์ฃผ์„์ฒ˜๋ฆฌ ํ˜น์€ ์‚ญ์ œ # print('Hello! 1') # ์ด ํŒŒ์ผ์„ ์‹คํ–‰ํ•  ๊ฒฝ์šฐ ์‹คํ–‰ํ•  ์ฝ”๋“œpy if __name__ == '__main__': print('DB ํ…Œ์ŠคํŠธ') # DB config ํŒŒ์ผ ์ฝ์–ด๋ณด๊ธฐ db_config = {} with open('./db_config', 'r') as f: for l in f.readlines(): key, value = l.rstrip().split('=') if key == 'port': db_config[key] = int(value) else: db_config[key] = value # p.. ๋”๋ณด๊ธฐ
9/6 ํ™”_DBeaver 1. dpkg dpkg -r: ๋ฐ๋น„์•ˆ ํŒจํ‚ค์ง€ ๋งค๋‹ˆ์ €๋กœ ๋ฐ๋ชฌ ํ”„๋กœ๊ทธ๋žจ/ํŒจํ‚ค์ง€ ์‚ญ์ œ 2. systemctl ๋ฐ๋ชฌ ํ”„๋กœ๊ทธ๋žจ๋“ค ๊ด€๋ฆฌ 3. .deb ํ•ด๋‹น ํ™•์žฅ์ž ์„ค์น˜ ์‹œ์—๋Š” sudo dpkg -i ํŒŒ์ผ๋ช… 4. vim ํŽธ์ง‘๊ธฐ ์ „์ฒด ์„ ํƒ: shift + v + g ๋ˆ„๋ฅธ ๋’ค d๋กœ ์‚ญ์ œ 5. ls -ltr ํŒŒ์ผ/ํด๋”, ์ƒ์„ฑ๋œ ์‹œ๊ฐ„ ๋ฐ ๊ถŒํ•œ ์กฐํšŒ 6. Hadoop / Spark Hadoop: map ํ•จ์ˆ˜ ๋ชจ๋‘ ์ข…๋ฃŒ๋˜์–ด์•ผ reduce ํ•จ์ˆ˜๊ฐ€ ์‹คํ–‰๋˜๊ธฐ ๋•Œ๋ฌธ์— ๋ฐ์ดํ„ฐ ์‹ค์‹œ๊ฐ„ ์ฒ˜๋ฆฌ ์–ด๋ ค์›€. ๋น…๋ฐ์ดํ„ฐ ๊ธฐ๋ฐ˜์˜ ๋ฐฐ์น˜์„ฑ ํ†ต๊ณ„์ž‘์—…์— ์ฃผ๋กœ ์‚ฌ์šฉํ•จ Spark: mapreduce๋กœ map ํ•จ์ˆ˜ ์ข…๋ฃŒ ์ „์ด๋ผ๋„ ๋ฐ์ดํ„ฐ ์ŠคํŠธ๋ฆฌ๋ฐ ๊ฐ€๋Šฅ. ๋ฐ์ดํ„ฐ๋ฅผ HDD๊ฐ€ ์•„๋‹Œ ๋ถ„์‚ฐ ๋ฉ”๋ชจ๋ฆฌ์— ์ €์žฅํ•จ 7. DBeaver VS Code -> EC2 -> RDS ๊ฐ€์‹œ์„ฑ ๋–จ.. ๋”๋ณด๊ธฐ

728x90