v1.3 Redis Support & PGCAT Overhaul

• [FEATURE] Redis Deployment

  • standalone mode
  • cluster mode
  • sentinel mode
  • redis_exporter & prometheus record & alert rules

• [FEATURE] Redis Monitor

  • Redis Overview Dashboard
  • Redis Cluster Dashboard
  • Redis Instance Dashboard

• [FEATURE] monitor: PGCAT Overhaul

  • New Dashboard: PGCAT Instance
  • New Dashboard: PGCAT Database Dashboard
  • Remake Dashboard: PGCAT Table Dashboard
  • Now Grafana datasource is automatically registered during monly deployment (PGCAT is enabled)

• [FEATURE] monitor: PGSQL Enhancement

  • New Panels: PGSQL Cluster, add 10 key metrics panel (toggled by default)
  • New Panels: PGSQL Instance, add 10 key metrics panel (toggled by default)
  • Simplify & Redesign: PGSQL Service
  • Add cross-references between PGCAT & PGSL dashboards

• [ENHANCEMENT] software upgrade

  • add PostgreSQL 13 back to default package list
  • upgrade to PostgreSQL 14.1 by default
  • add greenplum rpm and dependencies
  • add redis rpm & source packages
  • add perf as default packages

• [BUG FIX] shell script file permission fixed: #69

• [BUG FIX] fix pglog shortcuts (pglog12, pglog13, pglog14) to adopt different csvlog versions. add support for PG14 new error codes.

• [CHANGE] change default values for max_locks_per_transactions

• [CHANGE] increase default swapness from 0 to 10 for tuned config templates.

• [CHANGE] default monitor targets file are now @ /etc/prometheus/targets instead of /etc/pigsty/targets

How to Upgrade?

This upgrade is all about prometheus & grafana. Following play will do the trick:

cd pigsty && git pull # upgrade pigsty from v1.2 to v1.3
./infra.yml -t grafana_provision,prometheus_config,prometheus_reload