안녕하세요 오늘은 베스핀글로벌 D&A실 왕승준님이 작성해 주신 [MySQL] MySQL Shell (Dump/Load Utility)에 대해 알아보겠습니다 궁금하신 부분이 있으시면 댓글을 달아주세요 🙂
ySQL Shell (Dump/Load Utility) 사용하여 마이그레이션 한 내용 공유합니다.
상세 기능 및 옵션, 사용법은 첨부파일을 참고 부탁드립니다.
○ 작업 목적 : Maria10.4.11 -> Aurora Mysql 8.0.23 migration
○ 작업 내용 : MySQL Shell Utility 중 dump utility, load utility를 사용하여 데이터 마이그레이션 진행
○ 작업 결과 : 병렬 세션 수행으로 mysqldump에 비해 수행 시간 크게 감소함
○ 작업환경 : Windows shell client / Source (On-prem Maria), Target (Aurora severless Mysql)
○ mysqldump & shelldump 시간 비교
![](https://i0.wp.com/bespin-wordpress-bucket.s3.ap-northeast-2.amazonaws.com/wp-content/uploads/2023/07/1-164.png?resize=613%2C463&ssl=1)
○ 작업 상세
1. MysqlShell Utility 설치
– download URL : https://dev.mysql.com/downloads/shell/
– 환경 별 설치방법 :https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-install.html
2. Running the Utilities
![](https://i0.wp.com/bespin-wordpress-bucket.s3.ap-northeast-2.amazonaws.com/wp-content/uploads/2023/07/1-165.png?resize=606%2C202&ssl=1)
![](https://i0.wp.com/bespin-wordpress-bucket.s3.ap-northeast-2.amazonaws.com/wp-content/uploads/2023/07/1-166.png?resize=606%2C782&ssl=1)
![](https://i0.wp.com/bespin-wordpress-bucket.s3.ap-northeast-2.amazonaws.com/wp-content/uploads/2023/07/1-167.png?resize=609%2C673&ssl=1)
![](https://i0.wp.com/bespin-wordpress-bucket.s3.ap-northeast-2.amazonaws.com/wp-content/uploads/2023/07/1-168.png?resize=607%2C385&ssl=1)
감사합니다 🙂
![](https://i0.wp.com/bespin-wordpress-bucket.s3.ap-northeast-2.amazonaws.com/wp-content/uploads/2023/07/%EB%A7%88%EB%AC%B4%EB%A6%AC-14.png?resize=504%2C109&ssl=1)
문의: info@bespinglobal.com | 대표번호: 02-1668-1280