1. 마스터로 지정할, centos7 인스턴스 생성.
2. DB 설치, 초기설정
setenforce 0
systemctl stop firewalld
yum install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server
systemctl restart mysqld
3. 마스터 설정
[mysqld]
server-id = 1
log-bin = mysql-bin
systemctl restart mysqld
4. Master 상태 확인
create database minji;
create table minji.student (name varchar(10), age int);
insert into minji.student values ('minji','25');
확인 :
select * from minji.student;
+-------+------+
| name | age |
+-------+------+
| minji | 25 |
+-------+------+
show master status;
5. Replication할 때 사용할 계정 생성
GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' IDENTIFIED BY 'qwer1234';
select * from mysql.user where user='slave'\G
6. AWS의 RDS에 생성
mysql -h 앤드포인트 -u minji -p
7. AWS의 RDS Slave 설정
CALL mysql.rds_set_external_master (
host_name
, host_port
, replication_user_name
, replication_user_password
, mysql_binary_log_file_name
, mysql_binary_log_file_location
, ssl_encryption
);
call mysql.rds_set_external_master(
-> '13.209.75.7', #마스터 IP
-> 3306,
-> 'slave',
-> 'qwer1234',
-> 'mysql-bin.000001',
-> 766, #show master status로 확인한 것.
-> 0);
![[AWS] RDS 이중화(Multi-AZ) 설정](/posts/aws-rds-multi-az/images/image_1.jpg)