v2.0
- About PTK
- Quick Start
- Guidance
- Preparing Configuration File
- Checking the System
- Deploy Database Cluster
- Manage Clusters
- Show Cluster List
- Show Cluster Status
- Start Database
- Stop Database
- Restart Database
- Rebuild Database
- Switchover
- Failover
- Show Plugin Information
- Install Plugins
- Upgrade Database
- Scale-out Cluster
- Scale-in Cluster
- Show Database HBA
- Set Database HBA
- Show Database Parameters
- Set Database Parameters
- Show Cluster Topology Configuration
- Show Cluster Meta Information
- Update Cluster Comment
- Update Database IP
- Role Management
- Install CM
- Uninstall CM
- Manage Cluster VIP
- Install MogHA Service
- Uninstall MogHA Service
- Rename Cluster
- Create Empty Cluster
- Throw Out A Node
- Takeover A Node
- Manage Cluster
- Uninstall Database Cluster
- Collect OS Information
- Download MogDB Installer
- Encrypt Sensitive Information
- Upgrade PTK
- PTKC
- Compatible With Higher Versions of MogDB
- Reference
- Samples of Configuration Files
- Commands
- ptk
- ptk completion
- ptk view-static-config
- ptk init-cluster
- ptk collect
- ptk rec-guc
- ptk cache
- ptk gen-ptkc
- ptk manage
- ptk demo
- ptk meta
- ptk version
- ptk self
- ptk gen-om-xml
- ptk env
- ptk gen-static-config
- ptk cluster
- ptk cluster createdb
- ptk cluster uninstall-compat-tools
- ptk cluster install-compat-tools
- ptk cluster install-mogila
- ptk cluster rename
- ptk cluster throwout
- ptk cluster takeover
- ptk cluster uninstall-cm
- ptk cluster install-cm
- ptk cluster gen-cert-files
- ptk cluster load-cm-vip
- ptk cluster del-kerberos-auth
- ptk cluster add-kerberos-auth
- ptk cluster uninstall-kerberos-server
- ptk cluster install-kerberos-server
- ptk cluster is-in-upgrade
- ptk cluster upgrade-rollback
- ptk cluster upgrade-commit
- ptk cluster upgrade
- ptk cluster demote
- ptk cluster promote
- ptk cluster refresh
- ptk cluster shell
- ptk cluster modify-comment
- ptk cluster show-config
- ptk cluster set-guc
- ptk cluster show-guc
- ptk cluster set-hba
- ptk cluster show-hba
- ptk cluster scale-out
- ptk cluster scale-in
- ptk cluster uninstall-mogha
- ptk cluster install-mogha
- ptk cluster list-plugins
- ptk cluster install-plugin
- ptk cluster inspect
- ptk cluster failover
- ptk cluster switchover
- ptk cluster build
- ptk cluster status
- ptk cluster restart
- ptk cluster stop
- ptk cluster start
- ptk uninstall
- ptk ls
- ptk install
- ptk exec
- ptk template
- ptk encrypt
- ptk checkos
- ptk download
- ptk candidate
- Troubleshooting
- FAQ
- Release Notes
- Community
- Appendix: YAML Syntax
Primary and Standby Cluster
One Primary and One Standby
global:
# Cluster name
cluster_name: c1
# OS user name
user: omm
# System user password
user_password: "" # ptk encrypt password
# Database password
db_password: "" # ptk encrypt password
# Database port
db_port: 26000
# Database installation base directory
base_dir: /data/mogdb
db_servers:
- host: <IP1>
# Database roles, supported: primary, standby, cascade_standby
role: primary
# SSH connection configuration
ssh_option:
port: 22
user: root
password: "" # ptk encrypt password
key_file: ""
passphrase: ""
- host: <IP2>
role: standby
ssh_option:
port: 22
user: root
password: "" # ptk encrypt password
key_file: ""
passphrase: ""
One Primary Two Standby and One Cascade
global:
# Cluster name
cluster_name: shockley
# OS user name
user: vimiix
# System user password
user_password: "" # ptk encrypt password
# Database password
db_password: "" # ptk encrypt password
# Database port
db_port: 26000
# Database installation base directory
base_dir: /data/mogdb
# SSH login information, here we demonstrate that all database servers have the same login information.
# So you only need to configure this information in global section.
ssh_option:
port: 22
user: root
password: "" # ptk encrypt password
key_file: ""
passphrase: ""
db_servers:
- host: <IP1>
role: primary
- host: <IP2>
role: standby
- host: <IP3>
role: standby
- host: <IP4>
role: cascade_standby
# Upstream standby node IP of the current cascade standby node
upstream_host: <IP3>