DB 세팅

---

[Master \& Slave DB]
yum install -y mariadb mariadb-server
systemctl enable --now mariadb

---

[Master DB]

vim /etc/my.cnf

[mysqld]
log-bin = mysql-bin
server-id = 1

systemctl restart mariadb
mysql -u root -p

MariaDB [(none)]>

grant all privileges on *.* to 'slave'@'%' identified by '0000';
flush privileges;
show master status;
select binlog_gtid_pos(MASTER_LOG_FILE, MASTER_LOG_POS);

# File명과 Position 번호 필요

---

[Slave DB]

vim /etc/my.cnf

[mysqld]
log-bin = mysql-bin
server-id = 2

systemctl restart mariadb
mysql -u root -p

MariaDB [(none)]>

stop slave;

change master to
  master_host='masterDB_IP', # master서버 ip 주소
  master_user='slave', #master mysql 계정
  master_password='0000', # master mysql 계정 비밀번호
  master_use_gtid=slave_pos;

start slave;
show slave status\G;

# Slave_IO_Running, Slave_SQL_Running 둘다 Yes 들어오면 연결 성공

---

[Master DB] mysql -u root -p

MariaDB [(none)]>

create database pj;
use pj;
create table user(
    id int(10) auto_increment primary key,
    name varchar(20) not null,
    password varchar(20) not null);
insert into user(name,password) values('AAA','AAA');

---

[Slave DB]
mysql -u root -p

MariaDB[(none)]>

use pj; select * from user;

# slave에 비동기 저장된 것을 확인 할 수 있다.