Kubernetes/DBMS5 MariaDB - replication 1. 개요 - MariaDB replication을 구성한다. ✓ Primary DB는 읽기/쓰기용으로, Secondary DB는 읽기용으로 사용해야 한다. ✓ Secondary DB는 0개부터 n개까지 구성할 수 있다. - MariaDB 기본 설치는 'MariaDB'를 참조한다. 2. Environments - helm chart bitnami/mariadb 9.7.0 - MariaDB 10.15.12 - Helm 3.3.1 - Kubernetes 1.16.15 3. MariaDB replication 구성 - helm chart용 parametes yaml 파일 생성 및 replication 구성 ✓ architecture, rootPassword, database, replicationPasswor.. 2021. 10. 29. MariaDB 1. 개요 - MariaDB MariaDB is a fast, reliable, scalable, and easy to use open-source relational database system. MariaDB Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. https://mariadb.com/ - MariaDB helm chart This chart bootstraps a MariaDB replication cluster deployment on a Kubernetes cluster using the Helm package ma.. 2021. 10. 4. Crunchy PostgreSQL Managements 2021.04.11 1. PostgreSQL 파라미터 값 수정 a. 수정 할 configmap 찾기 $ k get configmaps -n pgo | egrep 'NAME|-pgha-config' NAME DATA AGE gmd-prd-pgha-config 4 15d $ b. 파라미터 수정하기 $ k edit configmaps gmd-prd-pgha-config -n pgo apiVersion: v1 data: gmd-prd-dcs-config: | postgresql: parameters: archive_command: source /opt/cpm/bin/pgbackrest/pgbackrest-set-env.sh && pgbackrest archive-push "%p" archive_mode: tru.. 2021. 9. 23. Crunchy PostgreSQL Operator #2 2021.04.22, 2020.09.10 Crunchy PostgreSQL Operator #1 1. Crunchy PostgreSQL Operator 소개 2. PostgreSQL Operator Configuration 3. Create a PostgreSQL Cluster (Multi-Tenancy) 4. pgAdmin4 Crunchy PostgreSQL Operator #2 5. High-Availability 6. Disaster Recovery: Backups & Restores 7. Monitoring 8. pgBouncer 5. High-Availability - High-Availability: Scaling Up & Down https://access.crunchydata.com/doc.. 2021. 9. 23. Crunchy PostgreSQL Operator #1 2021.04.22, 2020.09.10 Crunchy PostgreSQL Operator #1 1. Crunchy PostgreSQL Operator 소개 2. PostgreSQL Operator Configuration 3. Create a PostgreSQL Cluster (Multi-Tenancy) 4. pgAdmin4 Crunchy PostgreSQL Operator #2 5. High-Availability 6. Disaster Recovery: Backups & Restores 7. Monitoring 8. pgBouncer 1. Crunchy PostgreSQL Operator 소개 - Crunchy PostgreSQL Operator 4.4.1 https://access.crunchyda.. 2021. 9. 23. 이전 1 다음
