카테고리 없음

DB 서버 이중화

min_min_ 2022. 8. 23. 15:26

 

 

 

sudo yum install wget

wget https://downloads.mariadb.com/MariaDB/mariadb_repo_setup chmod +x mariadb_repo_setup
chmod +x mariadb_repo_setup
sudo ./mariadb_repo_setup

yum install epel-release

yum install pv
sudo yum install MariaDB-server MariaDB-backup

(ftp)

ftp ip port

(참고)

https://velog.io/@jude0124/MYSQL-DB-%EC%9D%B4%EC%A4%91%ED%99%94

 

(sync ,async) https://otsteam.tistory.com/415

https://it-sunny-333.tistory.com/148

 

방화벽(https://ynzu-dev.tistory.com/entry/Linux-%EB%B0%A9%ED%99%94%EB%B2%BD-%EC%84%A4%EC%A0%95%ED%95%98%EA%B8%B0-%ED%8A%B9%EC%A0%95-%ED%8F%AC%ED%8A%B8-%EB%B0%A9%ED%99%94%EB%B2%BD-%EC%98%A4%ED%94%88)

 

https://mariadb.com/docs/deploy/community-replica/#install-via-yum-centos-rhel

 

Open Source Database (RDBMS) for the Enterprise | MariaDB

MariaDB is the leading enterprise open source database with features previously only available in costly proprietary databases. Enterprise grade, wallet friendly.

mariadb.com

 

 

Open Source Database (RDBMS) for the Enterprise | MariaDB

MariaDB is the leading enterprise open source database with features previously only available in costly proprietary databases. Enterprise grade, wallet friendly.

mariadb.com

 

 

https://nakanara.tistory.com/200

 

[MariaDB] 이중화 설정

MariaDB 기능(Replication)을 이용하여 양방향 설정하여 Active-Standby로 사용할 수 있습니다. 해당 기능은 트랜잭션 단위로 동기화되므로, DB를 양쪽 다 Active 하여 사용할 경우 동기화에 문제가 될 수 있

nakanara.tistory.com

 

https://inside-out.xyz/technology/how-to-configure-mariadb-semi-synchronous-replication.html