<div id="readability-page-1" class="page"><div id="ArticleView"> <h3><span>&lt;1&gt; RDS활용 방법</span></h3><h3><span>&lt;2&gt; 오로라 DB</span></h3><h3><span>&lt;3&gt; RDS  생성</span></h3><h3><span>&lt;4&gt; DB 연결</span></h3><h3><span>&lt;1&gt; RDS활용 방법</span></h3><p><span>EC2와 연동</span></p><p><span>EKS, ECS와 연동</span></p><p><span>Lambda와 연동</span></p><p><span>DMS 와 연계해 데이터 마이그레이션 동기화</span></p><p><span>Analytics , BI 연동</span></p><h3><span>&lt;2&gt; 오로라 DB</span></h3><p><span>1</span></p><p><span>오로라</span></p><p><span>ACU +스토리지 비용</span></p><p><span>2</span></p><p><span>Min/Mac ACU를 워크로드에 맞게 사용</span></p><p><span>RDS 프록시 권장</span></p><p><span>모니터링 </span></p><h3><span>&lt;3&gt; RDS  생성</span></h3><p><span>1</span></p><p><span>서브넷 그룹 먼저 생성</span></p><p><span>2</span></p><p><span>AZ가 2개 필요함 = 서브넷 1개더 만듬</span></p><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/rb-BJnER_9eyMnawLUNgrF_iZ3Y.png&quot;,&quot;width&quot;:&quot;1550&quot;,&quot;height&quot;:&quot;698&quot;,&quot;originalName&quot;:&quot;400 az.png&quot;}]}"><p><img alt="400 az.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/rb-BJnER_9eyMnawLUNgrF_iZ3Y.png"> <span></span></p></div><p><span>3</span></p><p><span>서브넷 그룹 생성 완료</span></p><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/eD2ullKa9IMu38wFEfrg6AMQlJo.png&quot;,&quot;width&quot;:&quot;1866&quot;,&quot;height&quot;:&quot;879&quot;,&quot;originalName&quot;:&quot;410 sg.png&quot;}]}"><p><img alt="410 sg.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/eD2ullKa9IMu38wFEfrg6AMQlJo.png"> <span></span></p></div><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/NxzyKH-s6ikcrAWU46enoBAEYlo.png&quot;,&quot;width&quot;:&quot;1850&quot;,&quot;height&quot;:&quot;763&quot;,&quot;originalName&quot;:&quot;420 rds.png&quot;}]}"><p><img alt="420 rds.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/NxzyKH-s6ikcrAWU46enoBAEYlo.png"> <span></span></p></div><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/TmSIobov_-cmCWIFgBAirrW8jYA.png&quot;,&quot;width&quot;:&quot;1833&quot;,&quot;height&quot;:&quot;840&quot;,&quot;originalName&quot;:&quot;430 자체.png&quot;}]}"><p><img alt="430 자체.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/TmSIobov_-cmCWIFgBAirrW8jYA.png"> <span></span></p></div><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/ZujTu-xzUR568a9oq8pOEwyParI.png&quot;,&quot;width&quot;:&quot;1849&quot;,&quot;height&quot;:&quot;745&quot;,&quot;originalName&quot;:&quot;430 자체2.png&quot;}]}"><p><img alt="430 자체2.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/ZujTu-xzUR568a9oq8pOEwyParI.png"> <span></span></p></div><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/RFbFYdX6YRbhbyIwn1oQ90SiCNo.png&quot;,&quot;width&quot;:&quot;1560&quot;,&quot;height&quot;:&quot;712&quot;,&quot;originalName&quot;:&quot;440 버스트.png&quot;}]}"><p><img alt="440 버스트.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/RFbFYdX6YRbhbyIwn1oQ90SiCNo.png"> <span></span></p></div><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/80EeWUAFL5g5tMmi2ueDej4-ZEw.png&quot;,&quot;width&quot;:&quot;1452&quot;,&quot;height&quot;:&quot;768&quot;,&quot;originalName&quot;:&quot;450 db.png&quot;}]}"><p><img alt="450 db.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/80EeWUAFL5g5tMmi2ueDej4-ZEw.png"> <span></span></p></div><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/HUSmIHr4NZKhGPF4cMzRXoPxc3Y.png&quot;,&quot;width&quot;:&quot;989&quot;,&quot;height&quot;:&quot;728&quot;,&quot;originalName&quot;:&quot;460 db.png&quot;}]}"><p><img alt="460 db.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/HUSmIHr4NZKhGPF4cMzRXoPxc3Y.png"> <span></span></p></div><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/wmTxInQgMBXLFpT4-nRYrVXE4Cg.png&quot;,&quot;width&quot;:&quot;1067&quot;,&quot;height&quot;:&quot;706&quot;,&quot;originalName&quot;:&quot;470 db.png&quot;}]}"><p><img alt="470 db.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/wmTxInQgMBXLFpT4-nRYrVXE4Cg.png"> <span></span></p></div><h3><span>&lt;4&gt; DB 연결</span></h3><p><span>sudo dnf install -y mariadb1011-client-utils</span></p><p><span>mysql -h database-1.c1uogyicuihe.ap-northeast-2.rds.amazonaws.com -u admin -p</span></p><div data-app="{&quot;type&quot;:&quot;gridGallery&quot;,&quot;caption&quot;:&quot;&quot;,&quot;displayOption&quot;:&quot;ContentFit&quot;,&quot;images&quot;:[{&quot;url&quot;:&quot;http://t1.daumcdn.net/brunch/service/user/uSr/image/npkEP083io_2pbpLCTkHc4xEE9I.png&quot;,&quot;width&quot;:&quot;1397&quot;,&quot;height&quot;:&quot;731&quot;,&quot;originalName&quot;:&quot;490 sg.png&quot;}]}"><p><img alt="490 sg.png" src="https://img1.daumcdn.net/thumb/R1280x0.fpng/?fname=http://t1.daumcdn.net/brunch/service/user/uSr/image/npkEP083io_2pbpLCTkHc4xEE9I.png"> <span></span></p></div><p><span>[ec2-user@ip-172-31-36-4 ~]$ mysql -h database-1.c1uogyicuihe.ap-northeast-2.rds.amazonaws.com -u admin -p</span></p><p><span>Enter password:</span></p><p><span>Welcome to the MariaDB monitor.  Commands end with ; or \g.</span></p><p><span>Your MySQL connection id is 29</span></p><p><span>Server version: 8.0.42 Source distribution</span></p><p><span>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.</span></p><p><span>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</span></p><p><span><b><u>MySQL [(none)]&gt;</u></b></span></p><p><span><b>MySQL [(none)]&gt;</b></span></p><p><span>다음</span></p><p><a href="https://brunch.co.kr/@topasvga/5036" target="_blank"><span>https://brunch.co.kr/@topasvga/5036</span></a></p> </div></div>

Master Seo

<1> RDS활용 방법 <2> 오로라 DB <3> RDS  생성 <4> DB 연결   <1> RDS활용 방법  EC2와 연동 EKS, ECS와 연동 Lambda와 연동 DMS 와 연계해 데이터 마이그레이션 동기화 Analytics , BI 연동   <2> 오로라 DB  1 오로라 ACU +스토리지 비용  2 Min/Mac ACU를 워크로드에 맞게 사용 RD

4. AWS 데이터 베이스

댓글