| [](http://wiki.igoni.kr/uploads/images/gallery/2026-03/27769726-a24b-4786-83c1-a829a5a7b866.png) |
| perplexity에서 생성한 AI이미지 |
1. 마스터 서버 replication 플러그인 설치 ```SQL
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
```
2. 플러그인 활성화 ```SQL
mysql> set global rpl_semi_sync_master_enabled=1;
Query OK, 0 rows affected (0.00 sec)
mysql> set global rpl_semi_sync_master_timeout =1000;
Query OK, 0 rows affected (0.00 sec)
```
3. 설치 및 활성화 확인
```SQL
mysql> show variables like 'rpl_semi_sync%';
+————————————+——-+
| Variable_name | Value |
+————————————+——-+
| rpl_semi_sync_master_enabled | ON |
| rpl_semi_sync_master_timeout | 1000 |
| rpl_semi_sync_master_trace_level | 32 |
| rpl_semi_sync_master_wait_no_slave | ON |
+————————————+——-+
```
4. Slave 접속할 수 있게 권한 설정
```SQL
mysql> grant replication slave on *.* to 'test'@'192.168.10.10' identified by 'test1234';
```
5. 리플리케이션 상태 확인 ```SQL
mysql> show master status;
+————————-+———-+————–+——————+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+————————-+———-+————–+——————+
| mysql-master-bin.000001 | 107 | test1234 | |
+————————-+———-+————–+——————+
```
1. 플러그인 설치 ```SQL
mysql> INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
```
2. 플러그인 활성화 ```SQL
mysql> set global rpl_semi_sync_slave_enabled=1;
```
3. 활성화 확인
```SQL
mysql> show variables like ‘rpl_semi_sync%’;
+———————————+——-+
| Variable_name | Value |
+———————————+——-+
| rpl_semi_sync_slave_enabled | ON |
| rpl_semi_sync_slave_trace_level | 32 |
+———————————+——-+
2 rows in set (0.01 sec)
```
4. Master서버와 연결 ```SQL
mysql> change master to master_host='192.168.10.20', master_user='test', master_password='test1234', master_log_file='mysql-master-bin.000001', master_log_pos=107;
```