graph TB
    subgraph "Development Flow"
        DEV[Development
Feature Branches]
        PR[Pull Request
Review & Test]
        MERGE[Merge to
Version Branch]
    end
    
    subgraph "Build Triggers"
        PUSH[Git Push
Version Branch]
        TAG[Git Tag
Release Version]
        MANUAL[Manual
Workflow Dispatch]
        JENKINS[Jenkins Build
Internal System]
    end
    
    subgraph "Build Pipeline"
        DETECT[Version Detection
git describe]
        MATRIX[Build Matrix
Multi-Platform]
        DOCKER[Docker Builds
Containerized]
        PACKAGE[Package Creation
RPM/DEB]
    end
    
    subgraph "Testing & Validation"
        PKGTEST[Package Tests
Installation]
        INTTEST[Integration Tests
3rd Party]
        SMOKE[Smoke Tests
Basic Function]
        SIGN[Package Signing
SHA1 Hash]
    end
    
    subgraph "Distribution"
        GHREL[GitHub Releases
Public Downloads]
        REPO[Repository Storage
Internal System]
        DOCKER_HUB[Docker Hub
Container Images]
        NOTIFY[Notifications
Release Notes]
    end
    
    DEV --> PR
    PR --> MERGE
    MERGE --> PUSH
    
    PUSH --> DETECT
    TAG --> DETECT
    MANUAL --> DETECT
    JENKINS --> DETECT
    
    DETECT --> MATRIX
    MATRIX --> DOCKER
    DOCKER --> PACKAGE
    
    PACKAGE --> PKGTEST
    PKGTEST --> INTTEST
    INTTEST --> SMOKE
    SMOKE --> SIGN
    
    SIGN --> GHREL
    SIGN --> REPO
    SIGN --> DOCKER_HUB
    GHREL --> NOTIFY
    
    style DETECT fill:#f9f,stroke:#333,stroke-width:4px
    style PACKAGE fill:#bbf,stroke:#333,stroke-width:2px
    style GHREL fill:#bfb,stroke:#333,stroke-width:2px

# Version detection via git describe
GIT_VERSION=$(git describe --long --abbrev=7)
# Example: 2.7.0-404-g6000ede

# Components:
# 2.7.0    - Last tagged version
# 404      - Commits since tag
# g6000ede - Git commit hash (g prefix)

# Production release tags
git tag -a v2.7.0 -m "Release version 2.7.0"
git push origin v2.7.0

# Release candidate tags
git tag -a v2.7.0-rc1 -m "Release candidate 1 for 2.7.0"

# Development snapshot tags (automated)
v3.0-head  # Latest development build

name: package-build
on:
  workflow_dispatch:
  workflow_run:
    workflows: ["trigger"]
    types: [completed]

jobs:
  get-info:
    outputs:
      is_tag: ${{ steps.tags.outputs.is_tag }}
      is_github_branch: ${{ steps.branches.outputs.is_github_branch }}
      
  amd64-packages:
    strategy:
      matrix:
        dist: [centos9, fedora40, fedora41, debian12, ubuntu22, ubuntu24, 
               opensuse15, almalinux8, almalinux9]
        build: ["", "clang", "dbg"]

# Package build orchestrator (Internal)
package-build.bash
├── Version detection
├── Docker container setup
├── Multi-architecture builds
├── Package transfer
└── Repository management

# Build script (Internal)
build.bash
├── Dependency compilation
├── ProxySQL compilation
├── Test execution
├── Coverage collection
└── Artifact packaging

graph LR
    subgraph "AMD64 Builds"
        C9[CentOS 9]
        F40[Fedora 40]
        F41[Fedora 41]
        D12[Debian 12]
        U22[Ubuntu 22]
        U24[Ubuntu 24]
        OS15[OpenSUSE 15]
        AL8[AlmaLinux 8]
        AL9[AlmaLinux 9]
    end
    
    subgraph "ARM64 Builds"
        C9A[CentOS 9 ARM]
        D12A[Debian 12 ARM]
        U22A[Ubuntu 22 ARM]
        U24A[Ubuntu 24 ARM]
    end
    
    subgraph "Build Variants"
        STD[Standard Build
ClickHouse]
        CLG[Clang Build
Clang Compiler]
        DBG[Debug Build
Debug Symbols]
    end
    
    C9 --> STD
    C9 --> CLG
    C9 --> DBG
    
    C9A --> STD
    C9A --> DBG

# Build image example: proxysql/packaging:build-debian12-v3.0
FROM debian:12
RUN apt-get update && apt-get install -y \
    build-essential cmake git \
    libssl-dev libmysqlclient-dev \
    libpq-dev python3 python3-pip

sequenceDiagram
    participant GIT as Git Repository
    participant CI as GitHub Actions
    participant DOCKER as Docker Build
    participant BUILD as Build Process
    participant TEST as Package Test
    participant DIST as Distribution
    
    GIT->>CI: Push/Tag Event
    CI->>CI: Detect Version
    CI->>DOCKER: Start Container
    DOCKER->>BUILD: Execute Build
    
    BUILD->>BUILD: Compile Dependencies
    BUILD->>BUILD: Build ProxySQL
    BUILD->>BUILD: Create Package
    
    BUILD->>TEST: Install Package
    TEST->>TEST: Validate Function
    TEST->>TEST: Run Smoke Tests
    
    TEST->>DIST: Upload Package
    DIST->>DIST: Generate SHA1
    DIST->>DIST: Publish Release

# RPM spec generation
Version: ${CURVER}
Release: 1
BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root

# Package creation
rpmbuild -bb proxysql.spec
# Output: proxysql-2.7.0-1.x86_64.rpm

# Debian control file
Package: proxysql
Version: ${CURVER}-${GIT_VERSION}
Architecture: amd64

# Package creation
dpkg-deb --build proxysql/
# Output: proxysql_2.7.0-1_amd64.deb

# Skip unchanged builds (Internal)
if [[ "$BUILD_TYPE" == "noop" ]]; then
    echo "No changes detected, skipping build"
    exit 0
fi

MAKEFLAGS = -j$(shell nproc)
PARALLEL_JOBS = $(shell nproc)

# Package test execution (Internal)
package-tester.bash
├── Docker environment setup
├── Package installation test
├── Service startup validation
├── Basic functionality check
├── Configuration test
└── Uninstallation verification

graph TB
    subgraph "Package Tests"
        INST[Installation
Package Manager]
        START[Service Start
systemctl/init.d]
        CONN[Connection
MySQL Protocol]
        ADMIN[Admin Interface
Port 6032]
        UNINST[Uninstall
Clean Removal]
    end
    
    subgraph "Per Distribution"
        RPM[RPM-based
CentOS, Fedora]
        DEB[DEB-based
Debian, Ubuntu]
        SUSE[OpenSUSE
zypper]
    end
    
    INST --> RPM
    INST --> DEB
    INST --> SUSE
    
    START --> RPM
    START --> DEB
    START --> SUSE

proxysql-{VERSION}-1.{DISTRO}.{ARCH}.rpm
proxysql-2.7.0-1.centos9.x86_64.rpm
proxysql-2.7.0-1.centos9.aarch64.rpm
proxysql-debuginfo-2.7.0-1.centos9.x86_64.rpm

proxysql_{VERSION}-{RELEASE}_{ARCH}.deb
proxysql_2.7.0-ubuntu22_amd64.deb
proxysql_2.7.0-ubuntu22_arm64.deb
proxysql-dbg_2.7.0-ubuntu22_amd64.deb

# Extract binary and generate hash
rpm2cpio package.rpm | cpio -idmv
sha1sum usr/bin/proxysql > package.rpm.id-hash

# For DEB packages
ar x package.deb
tar -xf data.tar.gz
sha1sum usr/bin/proxysql > package.deb.id-hash

# Development snapshots
Release: v3.0-head
Assets:
  - proxysql-3.0.0-dev-centos9.x86_64.rpm
  - proxysql_3.0.0-dev-ubuntu22_amd64.deb
  - SHA256SUMS

# Production releases
Release: v2.7.0
Assets:
  - Source code (zip)
  - Source code (tar.gz)
  - All distribution packages
  - Release notes

/data/repos/ProxySQL-head/
├── binaries-{VERSION}/
│   ├── centos9/
│   ├── debian12/
│   ├── ubuntu22/
│   └── ...
└── archive/
    └── old-versions/

# Production Dockerfile
FROM alpine:latest
COPY proxysql /usr/bin/
EXPOSE 6033 6032 6080
ENTRYPOINT ["proxysql", "-f", "-D", "/var/lib/proxysql"]

# Build and tag images
docker build -t proxysql/proxysql:latest .
docker tag proxysql/proxysql:latest proxysql/proxysql:2.7.0
docker tag proxysql/proxysql:latest proxysql/proxysql:2.7

# Multi-architecture manifest
docker manifest create proxysql/proxysql:2.7.0 \
  proxysql/proxysql:2.7.0-amd64 \
  proxysql/proxysql:2.7.0-arm64

# Push to Docker Hub
docker push proxysql/proxysql:2.7.0
docker manifest push proxysql/proxysql:2.7.0

# Automatic release on tag
on:
  push:
    tags:
      - 'v*.*.*'
    branches:
      - 'v[0-9].[0-9x]+.?[0-9xy]?[0-9]?'

# Manual release trigger
on:
  workflow_dispatch:
    inputs:
      version:
        description: 'Version to release'
        required: true
      release_type:
        description: 'Release type'
        type: choice
        options:
          - production
          - candidate
          - snapshot

graph LR
    subgraph "Pre-Release"
        FREEZE[Code Freeze]
        TEST[Final Testing]
        APPROVE[Release Approval]
    end
    
    subgraph "Release"
        TAG[Create Tag]
        BUILD[Build Packages]
        PUBLISH[Publish Assets]
    end
    
    subgraph "Post-Release"
        ANNOUNCE[Announcement]
        DOCS[Update Docs]
        MONITOR[Monitor Issues]
    end
    
    FREEZE --> TEST
    TEST --> APPROVE
    APPROVE --> TAG
    TAG --> BUILD
    BUILD --> PUBLISH
    PUBLISH --> ANNOUNCE
    ANNOUNCE --> DOCS
    DOCS --> MONITOR

# Generate changelog from commits
git log v2.6.0..v2.7.0 --pretty=format:"* %s (%an)" \
  --grep="^feat\|^fix\|^perf" > CHANGELOG.md

# Categories:
# feat: New features
# fix: Bug fixes
# perf: Performance improvements
# docs: Documentation updates
# test: Test additions

# ProxySQL v2.7.0 Release Notes

## Highlights
- Major feature additions
- Performance improvements
- Security enhancements

## New Features
- Feature 1: Description
- Feature 2: Description

## Bug Fixes
- Fix 1: Issue #XXX - Description
- Fix 2: Issue #YYY - Description

## Breaking Changes
- Change 1: Migration required

## Deprecations
- Deprecated feature 1

## Contributors
- List of contributors

## Downloads
- [CentOS/RHEL packages](link)
- [Debian/Ubuntu packages](link)
- [Docker images](link)

# YUM repository configuration
[proxysql]
name=ProxySQL Repository
baseurl=https://repo.proxysql.com/centos/$releasever/
gpgcheck=1
gpgkey=https://repo.proxysql.com/RPM-GPG-KEY-proxysql

# APT repository configuration
deb https://repo.proxysql.com/debian/ $(lsb_release -cs) main

graph TB
    subgraph "Release Health Indicators"
        DOWNLOAD[Download Metrics
GitHub/Docker]
        ISSUES[Issue Reports
Bug Tracking]
        CRASH[Crash Reports
Core Dumps]
        PERF[Performance
Benchmarks]
    end
    
    subgraph "Actions"
        HOTFIX[Hotfix Release]
        PATCH[Patch Release]
        ROLLBACK[Version Rollback]
    end
    
    ISSUES --> HOTFIX
    CRASH --> HOTFIX
    PERF --> PATCH
    
    style DOWNLOAD fill:#bfb
    style ISSUES fill:#ffb
    style CRASH fill:#fbb

# GPG signing for RPM
rpmsign --addsign proxysql-2.7.0-1.x86_64.rpm

# GPG signing for DEB
dpkg-sig --sign builder proxysql_2.7.0-1_amd64.deb

# Checksum generation
sha256sum proxysql-* > SHA256SUMS
gpg --armor --detach-sign SHA256SUMS

# Package rollback (RPM)
yum downgrade proxysql-2.6.0

# Package rollback (DEB)
apt-get install proxysql=2.6.0

# Docker rollback
docker pull proxysql/proxysql:2.6.0
docker stop proxysql && docker rm proxysql
docker run -d --name proxysql proxysql/proxysql:2.6.0