.rr.example.yaml

# Example RoadRunner Configuration with PostgreSQL Connection Pool Plugin

version: "3"

# RPC configuration for communication with PHP
rpc:
  listen: tcp://127.0.0.1:6001

# Server configuration
server:
  command: "php worker.php"
  relay: pipes

# HTTP server configuration (if using HTTP mode)
http:
  address: 0.0.0.0:8080
  pool:
    num_workers: 4
    max_jobs: 64

# PostgreSQL Connection Pool Plugin Configuration
pgpool:
  # Enable the plugin
  enabled: true
  
  # Proxy server configuration (Phase 2 - PostgreSQL wire protocol)
  # Uncomment when wire protocol implementation is complete
  # proxy:
  #   address: "tcp://127.0.0.1:5433"
  #   max_clients: 100
  #   client_timeout: 30s
  #   auth_mode: "trust"
  
  # Backend database configuration
  backends:
    # Primary database
    primary:
      # PostgreSQL connection string
      dsn: "postgres://postgres:password@localhost:5432/myapp?sslmode=prefer"
      
      # Alternative: structured configuration
      # host: localhost
      # port: 5432
      # database: myapp
      # user: postgres
      # password: password
      # sslmode: prefer
      
      # Connection pool settings
      pool:
        # Maximum number of connections to PostgreSQL
        max_connections: 25
        
        # Minimum idle connections to maintain
        min_connections: 5
        
        # Maximum connection lifetime
        max_lifetime: 1h
        
        # Maximum idle time before closing
        max_idle_time: 30m
        
        # How often to check connection health
        health_check_period: 30s
        
        # Connection acquisition timeout
        acquire_timeout: 5s
        
        # Queue size for waiting connection requests
        wait_queue_size: 100
      
      # Connection behavior settings
      behavior:
        # Pooling mode: "session", "transaction", "statement", "auto"
        mode: "transaction"
        
        # Reset connection state after each use
        reset_on_return: true
        
        # Lazy connection creation
        lazy_connect: true
        
        # Prepared statement cache size per connection
        statement_cache_size: 100
        
        # Query timeout (0 = no timeout)
        query_timeout: 30s
  
  # Additional database pools (optional)
  databases:
    # Analytics database example
    analytics:
      primary:
        dsn: "postgres://postgres:password@analytics-db:5432/analytics"
        pool:
          max_connections: 10
          min_connections: 2
        behavior:
          mode: "statement"
          query_timeout: 60s
    
    # Cache database example
    cache:
      primary:
        dsn: "postgres://postgres:password@cache-db:5432/cache"
        pool:
          max_connections: 5
          min_connections: 1
        behavior:
          mode: "statement"
          reset_on_return: false
  
  # Routing configuration (for read/write splitting - Phase 3)
  # routing:
  #   read_write_split: true
  #   read_patterns:
  #     - "^SELECT"
  #     - "^WITH .* SELECT"
  #   write_patterns:
  #     - "^INSERT"
  #     - "^UPDATE"
  #     - "^DELETE"
  #   load_balance: "least_connections"
  #   failover:
  #     enabled: true
  #     retry_interval: 10s
  #     max_failures: 3
  
  # Monitoring and metrics
  monitoring:
    enabled: true
    interval: 10s
    expose_rpc: true
    
    # Prometheus metrics
    prometheus:
      enabled: true
      namespace: "roadrunner"
      subsystem: "pgpool"
    
    # Metrics to collect
    collect:
      - pool_stats
      - query_duration
      - error_rates
      - throughput
      - connection_wait
  
  # Logging configuration
  logging:
    level: "info"
    
    # Slow query logging
    slow_query:
      enabled: true
      threshold: 100ms
    
    # Log all queries (debug mode only)
    log_queries: false
    
    # Include query parameters in logs
    log_params: false
  
  # Advanced features
  features:
    # Query result caching (Phase 3)
    # cache:
    #   enabled: false
    #   ttl: 5m
    #   max_size: 100MB
    
    # Circuit breaker for backend failures
    circuit_breaker:
      enabled: true
      threshold: 5
      timeout: 30s
    
    # Rate limiting per client (Phase 3)
    # rate_limit:
    #   enabled: false
    #   requests_per_second: 1000
    #   burst: 100

# Metrics endpoint
metrics:
  address: 127.0.0.1:2112

# Logging
logs:
  mode: development
  level: info
  encoding: console
  output: stdout
  error_output: stderr