sudo yum install http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
sudo yum install mysql-community-server
sudo systemctl enable mysqld
sudo systemctl start mysqld
sudo grep 'temporary password' /var/log/mysqld.log
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Bigdata12!@';
create user 'test'@'%' identified by 'Bigdata12!@';
grant all privileges on *.* to 'test'@'%';
FLUSH PRIVILEGES;
create database testdb;
use testdb;
CREATE TABLE member_table (
NAME VARCHAR(20),
AGE INT,
PRIMARY KEY(AGE)
) ENGINE=MYISAM CHARSET=utf8;
import pymysql
import time
jh_db = pymysql.connect(
user="test",
passwd="Bigdata12!@",
host="127.0.0.1",
db="testdb",
port=3306,
charset='utf8'
)
cursor = jh_db.cursor(pymysql.cursors.DictCursor)
def insertsql():
sql_query = """INSERT INTO member_table(NAME, AGE) VALUES (%s, %s)"""
i = 0
while i < 100:
i = i + 1
cursor.execute(sql_query,('jh'+str(i), i))
jh_db.commit()
time.sleep(1)
jh_db.close()
if __name__ == "__main__":
insertsql()
sudo yum install python3-pip
pip install pymysql
python3 sc.py
엔드포인트 source 생성
엔드포인트 destination 생성
데이터베이스 마이그레이션 태스크 생성
테스크를 활성화하여 성공하면 로드 완료라고 뜬다.
https://dev-kwon.tistory.com/78
https://1mini2.tistory.com/86
https://velog.io/@joshua_s/AWS-DMS%EB%A5%BC-%EC%9D%B4%EC%9A%A9%ED%95%9C-%EB%A7%88%EC%9D%B4%EA%B7%B8%EB%A0%88%EC%9D%B4%EC%85%98-%EC%84%9C%EB%B9%84%EC%8A%A4