# Maintainable Toolbox

> Simple and Actionable
---

> Blazing like wildfire, illuminating all around, burning bright without end!


**Infra as Code**


        Define everything in Code



**Simple & Easy**


        Up and Running in Minutes



**Bare Linux**


        No Containers or Kubernetes



**Offline Install**


        Stable, Hassle-free Delivery



**Admin SOP**


        Best Practices Included



**No Downtime**


        Online Migration & Resizing



**Rich Parameters**


        Plenty of Tunable Knobs



**Provisioning**


        One-command IaaS Provisioning





--------

## Infra as Code: Define everything in Code {#infra-as-code}

> Declarative API for database deployment and operations\
> Designed for large-scale cluster management

- Define databases through config files
- Designed for batch operations
- Optional PostgreSQL CMDB solution for programmatic integration

--------

## Simple & Easy: Up and Running in Minutes {#simple-easy}

> One-command installation\
> Pre-configured templates with automatic hardware tuning

- Config templates for various node counts and scenarios
- Runs on single-core VMs to high-end physical machines
- Four instance parameter tuning modes: OLTP / OLAP / CRIT / TINY

--------

## Bare Linux: No Containers or Kubernetes {#bare-linux}

> Runs directly on Linux without containers\
> Supports mainstream Linux distros: EL 8/9, Debian 12, Ubuntu 22/24

- No K8S required for cloud-native experience
- Supports x86_64 and ARM64 architectures

--------

## Offline Install: Stable, Hassle-free Delivery {#offline-install}

> Offline installation packages for environments without internet\
> Snapshots from local repositories

- Eliminates lengthy downloads
- Ensures stable installation and version consistency
- Customized offline packages available in pro subscription

--------

## Admin SOP: Best Practices Included {#admin-sop}

> Distills top-tier DBA experience into conventions\
> Helps avoid common system pitfalls

- Dev conventions for PostgreSQL features
- Ops Standard Operating Procedures (SOPs)
- Security hardening best practices

--------

## No Downtime: Online Migration & Resizing {#no-downtime}

> Zero-downtime migration with blue-green deployment\
> Zero-maintenance window switchovers

- Comprehensive semi-automated migration playbooks
- Minimize maintenance windows
- Fine-grained traffic control with HAPROXY

--------

## Rich Parameters: Plenty of Tunable Knobs {#rich-parameters}

> Nearly 300+ configurable parameters with defaults suitable for most scenarios\
> Can adjust to meet demanding customization requirements

- YAML config format, easy to read, edit, and modify, Ansible compatible
- Override possible at multiple levels: default, global, cluster, instance, or CLI arg
- Rich documentation & examples with self-explanatory naming

--------

## Provisioning: One-command IaaS Provisioning {#provisioning}

> Enables running a complete 4-node simulation on a single laptop\
> Integrated Vagrant/Terraform templates for quick resource provisioning

- Consistent deployment across production, UAT, staging, testing, and dev environments
- Complete feature set in a 1-core VM, ideal as a developer's Devbox environment
- Multiple Terraform/Vagrant templates available for large-scale IaaS provisioning