Category: Historical Docs

You can use postgres as the remote storage database used by the Prometheus backend. While this is not the recommended behavior, it is a good opportunity to understand how the Pigsty deployment system is used. Preparing the Postgres database vi …

Pigsty v1.5.1 does not ship the former infra-pgweb.yml playbook or the pgweb_enabled / pgweb_username inventory parameters. PGWeb is provided as a Docker application at app/pgweb. Run PGWeb Docker is enabled on the meta node in the bundled v1.5.1 …

Pigsty is also a universal application runtime that could be used for deploying & monitoring other databases and applications, such as Redis. It takes two steps to deploy a Redis cluster: Declare it Execute playbook Define Redis Redis Config Entries …

Parameters The template database template1 in a cluster can be customized using the PG template configuration item. This ensures that any database newly created in this database cluster comes with the same default configuration: schema, extensions, …

There are 3 steps to deploy pigsty: prepare, configure, playbook Prepare Node Provisioning Meta Node Provisioning Admin User Provisioning Software Provisioning Configure Config Entry Config File Infrastructure Config Database Cluster Config Identity …

User Interface After completing the installation, the GUI provided by Pigsty can be accessed through a browser. http://g.pigsty -> http://10.10.10.10:80 (nginx) -> http://10.10.10.10:3000 (grafana) Visit http://<node_ip>:3000 to browse Pigsty home …

Why use Pigsty? Our philosophy is: use the good database, use the good database so that there is no hard-to-use database in the world! The database is the core component of an information system, a relational database is the absolute mainstay of the …

2022-06-18 1.5.1 for PostgreSQL 14.4 Upgrade haproxy to 2.6.0 repotrack i686 issus on el7 New apps: wiki.js ferretDB 2022-05-21 Grafana Logo Customize Nginx Log Rework 2022-05-20 Prometheus Overview polish Grafana Overview polish DCS Overview polish …

History Time Description Release 2019-05-15 POC fa2ade31 (v0.0.1) 2020-04-30 First Commit dd64677 (v0.0.2) 2020-06-20 Validation on Testing Environment v0.1.0 2020-06-22 Interface enhancement v0.0.3 2020-07-10 PGSQL Monitoring v6 GA v0.2.0 2020-07-27 …

There’s an active Pigsty community. Search WeChat pigsty-cc and join the user group. Most answers cloud be found in FAQ. If there’s no answer to your questions, you can ask in the community. It’s most welcome to create Issues or Pull Requests if you …

Hardware Faults ID Name Symptom Process H01 Primary node down pg_up = 0 for 1-3 minutes No immediate intervention required. Additional examples after the fact Removal from Access Domain Execute Case 8: Cluster Role Adjustment H02 Replica node down …

You can strengthen your confidence in the cluster’s HA capability through a HA scenario experiment. Below is a list of 24 typical HA failure scenarios, divided into three categories: Primary failure, Replica failure, and DCS failure, with eight …

Pigsty FHS #------------------------------------------------------------------------------ # pigsty # ^-----@app # extra demo application resources # ^-----@bin # bin scripts # ^-----@docs # document (can be docsified) # ^-----@files # ansible file …

Most cluster management operations require using the admin user on the meta node and the execution of the corresponding Ansible Playbook in the Pigsty root dir. Unless otherwise specified, the following examples demonstrate a three-node cluster …

An auxiliary playbook, pgsql-migration.yml, provides a battery-included migration method based on logical replication. By filling in the information about the source and host clusters, the playbook will automatically create the scripts needed for the …

Instead of a static config file, you can use postgres as an inventory for Pigsty. Using CMDB as a dynamic Inventory for Ansible has several advantages: metadata is presented as data tables in a highly structured way, and database constraints ensure …

Pigsty downloads all dependent packages from the Internet and creates local Yum repo during initialization. The total size of all the dependent software is about 1GB or so. Although Pigsty has tried to use mirror repos as much as possible to speed up …

Backup & Recovery matters. Failures can be divided into two categories: hardware/resource failures and software/human errors. Replication aims for the former, while delayed replica & cold backups aim for the latter. Pigsty has complete support for …

TL;DR ./infra-jupyter.yml # install jupyter on meta node on port 8888 with user jupyter and password pigsty ./infra-jupyter.yml -e jupyter_port=8887 # use another port 8887 by default ./infra-jupyter.yml -e jupyter_username=osuser_jupyter …

You can use postgres as the database used by the Grafana backend. In this tutorial, you will learn about the following. How to create a new cluster How to create a new biz user in an existing database cluster How to create a new biz database in an …

Pigsty v1.5.1 comes with Docker and Docker Compose deployment support, where Docker Daemon will be enabled by default on the meta node. You can use Docker to deploy and launch software applications quickly. You can directly access the …

Pigsty can be used to deploy and monitor PostgreSQL and make and distribute data Applications. Pigsty provides three sample applications. pglog, which analyzes PostgreSQL CSV log samples. covid, which visualizes WHO COVID-19 data and accesses country …

Pigsty uses Prometheus as the primary alerting system. Prometheus + AlertManager (primary) Grafana (backup), not enabled by default Alert Alerts are critical for daily fault response and improving system availability. Missing alarms will lead to …

Metric is the core concept of Pigsty’s monitor system. Format Metrics are formally cumulative, atomic logical units of measure that can be updated and statistically aggregated over periods. Metrics typically exist as time series with dimension …

This article describes the mechanism used by the Pigsty monitor system Prometheus to discover monitor objects. The basis of service discovery is identity. For more identity information, please refer to the section entity. It would help if you also …

Pigsty provides a professional and easy-to-use PostgreSQL monitor system that distills the industry’s monitoring best practices. The Pigsty monitoring dashboard consists of several relatively independent boards. Application Description Home Home …

The Patroni template is used to customize the specification config of the PostgreSQL cluster, while the Postgres template is used to customize the content of the PostgreSQL cluster. Pigsty provides nearly 100 parameters on PGSQL describing the …

Config Redis cluster and manipulate REDIS playbook behavior. Refer to Redis Deployment for details. REDIS_IDENTITY: REDIS Identity Params REDIS_NODE: REDIS Software, Dir & Exporter REDIS_PROVISION: REDIS Server Provisioning ID Name Section Type …

Use the PGSQL Playbook, and deploy the PGSQL cluster to adjust the cluster state to the state described in the PGSQL config. Pigsty has 100+ config parameters for describing a PostgreSQL cluster. However, users usually only need to care about a few …

Pigsty provides host provisioning and monitoring functions. The nodes.yml playbook can be executed to configure the node to the corresponding state and incorporate it into the Pigsty monitor system. NODE_IDENTITY : Node identity parameters NODE_DNS: …

Use the INFRA Playbook, and deploy the PGSQL cluster to adjust the cluster state to the state described in PGSQL Config. Use the INFRA series playbooks to configure the Pigsty infra. Infra config deals with such issues: localYum repos, machine node …

Pigsty uses declarative configuration. Pigsty defines infra and database clusters through Inventory, and each Pigsty deploy has a corresponding config. Pigsty’s config uses the “Infra as Data” philosophy: Users describe requirements through the …

REDIS series Playbook: Define and pull Redis databases in traditional standalone, native, and sentinel clusters. Playbook Function Link redis Deploying a Redis database in Native/Standalone/Sentinel cluster src redis-remove Redis cluster/node …

Pull up a defined cluster of HA PostgreSQL cluster using the PGSQL series playbook. Overview Playbook Function Link pgsql Deploy a PostgreSQL cluster, or cluster expand src pgsql-remove Destroy PostgreSQL cluster, or cluster downsize src …

Use the NODES playbook to bring more nodes to Pigsty, adjusting nodes to the state described in the config. Once pigsty is installed on the meta node with infra.yml, You can add more nodes to Pigsty with nodes.yml or remove them from Pigsty with …

Install pigsty & Add new optional to meta node with INFRA series playbooks. Playbook Function Link infra Install pigsty on meta nodes src infra-demo Special version of infra, pull up the 4-node sandbox in one-pass src infra-remove Uninstall pigsty …

Learn about the pre-built playbooks provided by Pigsty, the features, how to use them, and the considerations. Pigsty implements core control functions at the bottom through the Ansible Playbook, and Pigsty provides pre-built playbooks in four main …

Pigsty can be used to deploy and monitor MatrixDB (equal to Greenplum 7+ Time-Series database). Currently, MatrixDB uses PostgreSQL 12 kernel, while native Greenplum uses 9.6 kernels, so MatrixDB is used instead of Greenplum implementation, and …

Pigsty is a PostgreSQL distribution and a general-purpose application runtime. It can manage, deploy, and monitor other applications and databases, such as Redis. Similar to PostgreSQL, deploying Redis requires the same two steps. Declare/Define the …

This article describes several ways to deploy a PostgreSQL cluster using Pigsty: PGSQL-related playbook and config. Please refer to the related doc. Identity Parameters: Introduces the identity parameters required to define a standard PostgreSQL HA …

How to use Pigsty to monitor existing PostgreSQL instances? For existing Pigsty instances that Pigsty does not create, some additional configuration is required if they are monitored using Pigsty’s monitoring system. TL; DR Create the monitoring …

Pigsty supports both local sandbox and cloud sandbox for quickly preparing a standard 1/4 node demo environment locally or in the cloud. Pigsty provides a sandbox environment. Ultimately creating and running through the sandbox installation and …

How to prepare the resources required for Pigsty deployment. Node Provisioning Meta Provisioning Admin Provisioning Software Provisioning Pigsty source code Pigsty offline package Vagrant (sandbox) Virtualbox (sandbox) Node Provisioning Before …

It takes three steps to deploy Pigsty： Prepare, Configure, Playbook. Preparation Before installing Pigsty, you need to prepare the required resources: physical/VM nodes, admin users, and download Pigsty software. Node provisioning Meta node …

PostgreSQL provides a standard access control mechanism: Authentication and Privileges, both of which are based on the Role system. Role Pigsty’s default role system contains four default roles and four default users： name attr roles desc …

PostgreSQL provides a standard access control mechanism: Authentication and Privileges, both of which are based on the Role system. Role Pigsty’s default role system contains four default roles and four default users： name attr roles desc …

Defining PostgreSQL service and achieving stable, reliable, and HA access through LB and connection pooling. The concepts of Service and Access are proposed for HA PostgreSQL clusters. Personal User After completing the singleton deployment, port …

This article introduces the core concepts required for Redis cluster management. Deploy: Redis ｜Config: Redis | Playbook: Redis ER Model The Redis entity concept model is almost identical to PostgreSQL and includes the Cluster and Instance. Note …

This article introduces the core concepts required for PostgreSQL cluster management. PGSQL Cluster / ER Model / Identity Parameter Cluster / Instance / Node / Service PostgreSQL HA Deploy: PGSQL ｜Config: PGSQL | Playbook: PGSQL ｜ Custom: PGSQL …

Pigsty use nodes for deployment, nodes cloud be physical machines, VMs, or even Pods. Pigsty has two types of nodes: meta node and (normal) node. Meta nodes are used to initiate control, and (normal) nodes are managed under control. Meta node: Run …

Pigsty provides a complete, battery-included PaaS infra. Pigsty, as a battery-included PaaS solution, will integrate the basic infra into the provisioning solution. Overview Pigsty deploys a complete set of infra on meta nodes (the currently …

Pigsty consists of several modules that can be combined according to different scenarios. Module Pigsty currently offers four modules. INFRA is Pigsty’s infrastructure module, including monitoring/alerting/visualization/logging/DNS/NTP components. …

Index Module Concept Deploy Config Playbook INFRA Concept: INFRA Deploy: INFRA Config: INFRA Playbook: INFRA NODES Concept: NODES Deploy: NODES Config: NODES Playbook: NODES PGSQL Concept: PGSQL Deploy: PGSQL Config: PGSQL Playbook: PGSQL REDIS …

Here are some frequently asked questions. If you have some unlisted questions, Contact Us, or submit an Issue. Preparation Download Configuration Installation Sandbox Monitoring INFRA NODES PGSQL Preparation It would help if you ensured that the …

The battery-include, auto-piloting, handy & thrifty distribution for open-source databases. Battery-Include Open-Source Postgres Distribution Auto-Piloting monitoring and management SRE Solution Easy-to-use Database-as-Code Developer Toolbox Safe & …

It takes 3 steps to install Pigsty: Prepare, Configure, Execute Playbook There are two typical modes: Singleton & Cluster Management Singleton Meta: Install pigsty on one single meta node. (for PostgreSQL dev/test, RDS monitoring, etc…) Cluster …

Different users have different concerns. If you encounter problems, you are welcome to check the FAQ, submit an Issue, or ask the Community for help. Beginners Beginners can visit the Pigsty demo site: http://demo.pigsty.cc for a quick glance. There …

Pigsty v1.5.1 Documentation Battery-Included Open-Source PostgreSQL Distribution Latest Version: v1.5.1 | Github Repo | Demo Documentation: EN Docs | 中文文档 | Github Pages What is Pigsty? Pigsty is battery-included open-source database distribution, …