Maintainable Toolbox: Simple & Actionable
Blazing like wildfire, illuminating all around
true to the core while constantly innovating, burning bright without end!
Infra as Code: Define everything in Code
Declarative API, making database deployment and Ops as flexible as coding
Designed for large-scale cluster management, Infra as Code to Infra as Data
- Define databases and entire infra through config files, facilitating GitOps
- Designed for batch operations, embracing CLI ops, abandoning ClickOps
- Optional built-in PostgreSQL CMDB solution for programmatic intergration
curl -fsSL https://repo.pigsty.io/get | bash # Install
cd ~/pigsty # Enter directory (default in home dir)
./bootstrap # Prepare dependencies (bootstrap, install Ansible)
./configure # Generate config (config file: pigsty.yml)
./install.yml # Execute deployment (based on config inventory)Simple & Easy: Up and running in minutes
One-command to install them all, deployment in minutes, everything is ready
Pre-configured templates, automatic tuning based on hardware and env
- Config templates based on node count and various scenarios
- Can run on a single-core VM or fully utilize high-end physical machines
- Four instance parameter tuning modes: OLTP / OLAP / CRIT / TINY
| Code | PG17 | PG16 | PG15 | PG14 | PG13 | x86_64 | Arm64 |
|---|---|---|---|---|---|---|---|
| EL9 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| D12 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| U22 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| EL8 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| U24 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Bare Linux: No Containers or Kubernetes
Runs on bare Linux, avoiding the additional complexity of Docker and Kubernetes
Do the right & hard thing, adapt to each Linux distro individually one by one
- No containers needed, no K8S required for cloud-native experience
- Supports mainstream Linux distros: EL 8/9, Debian 12, Ubuntu 22/24
- Supports x86_64 / ARM64 architectures
For specific OS versions, download offline packages to /tmp/pkg.tgz,bootstrap will use it automatically
| RockyLinux 9.4 / x86_64 | pigsty-pkg-v3.3.0.el9.x86_64.tgz |
|---|---|
| Ubuntu 22.04.5 / x86_64 | pigsty-pkg-v3.3.0.u22.x86_64.tgz |
| Debian 12.7 / x86_64 | pigsty-pkg-v3.3.0.d12.x86_64.tgz |
| Debian 12.7 / aarch64 | pigsty-pkg-v3.3.0.d12.aarch64.tgz |
Offline Install: Stable, Hassle-free Delivery
Offline install packages for bootstrap in env without the Internet access
Snapshots from local repo, containing all required software and dependencies
- Eliminates lengthy downloads, avoids issues caused by upstream repo breaks
- Ensures a stable installation and maintains version consistency in deployment
- Customized offline packages for more distros combo in pro subscription
Admin SOP: Best Practices Included
Top-tier DBA experience distilled into dev conventions and ops SOPs
Avoid common pitfalls and build solid system foundations from the beginning
No Downtime: Online Migration & Resizing
0-downtime migration with blue-green deployment based on logical replication
0-maintenance windows with blink switchover between primary and standby
- Comprehensive playbooks for semi-automated migration
- Minize maintenance windows with fast active switchover
- Fine-grained traffic control with HAPROXY
Rich Parameters: Plenty of Tunable Knobs
Nearly 300+ configurable parameters, with defaults suitable for most scenarios
Adjust as needed to meet even the most demanding customization requirements
- YAML config format, easy to read, edit, and modify, ansible compatible
- Override at multiple levels: default, global, cluster, instance, or cli arg
- Rich documentation & examples, self-explanatory naming
Provisioning: One-command IaaS Provisioning
Sandbox environment: running a complete 4-node simulation on a single laptop
Integrated Vagrant/Terraform templates to provision required resources quickly
- Consistent deployment across production, UAT, staging, testing, and dev env
- Complete feature in a 1c vm, ideal as a dev's Devbox env running on a laptop
- Multiple Terraform/Vagrant templates available for IaaS Provisioning at scale
PIGSTY