Configuration

BUNNY_CATALOG_HOST=catalog-db.example.com
BUNNY_CATALOG_PORT=5432
BUNNY_CATALOG_USER=bunny_admin
BUNNY_CATALOG_PASSWORD=secure-catalog-password
BUNNY_CATALOG_DATABASE=bunnydb_catalog

TEMPORAL_HOST_PORT=temporal.example.com:7233
TEMPORAL_NAMESPACE=production

BUNNY_WORKER_TASK_QUEUE=production-worker-queue

BUNNY_JWT_SECRET=your-very-long-random-secret-key-here-min-32-chars
BUNNY_ADMIN_USER=superadmin
BUNNY_ADMIN_PASSWORD=strong-password-here

{
  "snapshot_num_rows_per_partition": 1000000,
  "snapshot_max_parallel_workers": 8,
  "snapshot_num_tables_in_parallel": 2,
  "do_initial_snapshot": true
}

{
  "cdc_sync_interval_seconds": 30,
  "cdc_batch_size": 5000
}

{
  "publication_name": "bunny_pub_prod_analytics",
  "replication_slot_name": "bunny_slot_prod_analytics"
}

# Enable logical replication
wal_level = logical
 
# Replication slots (one per mirror)
max_replication_slots = 10
 
# WAL senders (one per active replication slot)
max_wal_senders = 10
 
# Optional: Increase WAL size for high-traffic databases
wal_keep_size = 1GB

sudo systemctl restart postgresql

-- Check wal_level
SHOW wal_level;
-- Should return: logical
 
-- Check replication slots capacity
SHOW max_replication_slots;
SHOW max_wal_senders;
 
-- View active replication slots
SELECT * FROM pg_replication_slots;

-- Create replication user
CREATE USER bunny_replication WITH REPLICATION PASSWORD 'secure-password';
 
-- Grant permissions on database
GRANT CONNECT ON DATABASE production TO bunny_replication;
 
-- Grant schema permissions
GRANT USAGE ON SCHEMA public TO bunny_replication;
 
-- Grant table permissions (for all tables to replicate)
GRANT SELECT ON ALL TABLES IN SCHEMA public TO bunny_replication;
 
-- Grant permissions for future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT SELECT ON TABLES TO bunny_replication;

# Allow replication from BunnyDB worker
host    replication     bunny_replication    10.0.0.0/8    md5
host    production      bunny_replication    10.0.0.0/8    md5

sudo systemctl reload postgresql

-- Create destination user
CREATE USER bunny_destination WITH PASSWORD 'secure-password';
 
-- Grant database permissions
GRANT CONNECT ON DATABASE analytics TO bunny_destination;
 
-- Grant schema permissions
GRANT CREATE, USAGE ON SCHEMA public TO bunny_destination;
 
-- Grant table permissions
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO bunny_destination;
 
-- Grant permissions for future tables (BunnyDB creates tables during snapshot)
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO bunny_destination;

{
  "name": "production-db",
  "host": "prod-db.example.com",
  "port": 5432,
  "user": "bunny_replication",
  "password": "secure-password",
  "database": "production",
  "ssl_mode": "verify-full"
}

version: '3.8'
 
services:
  catalog:
    image: postgres:14
    environment:
      POSTGRES_USER: bunny_catalog
      POSTGRES_PASSWORD: secure-catalog-password
      POSTGRES_DB: bunnydb
    volumes:
      - catalog-data:/var/lib/postgresql/data
    networks:
      - bunnydb
 
  temporal:
    image: temporalio/auto-setup:latest
    environment:
      - DB=postgresql
      - DB_PORT=5432
      - POSTGRES_USER=temporal
      - POSTGRES_PWD=temporal-password
      - POSTGRES_SEEDS=temporal-db
    depends_on:
      - temporal-db
    networks:
      - bunnydb
 
  temporal-db:
    image: postgres:14
    environment:
      POSTGRES_USER: temporal
      POSTGRES_PASSWORD: temporal-password
    volumes:
      - temporal-data:/var/lib/postgresql/data
    networks:
      - bunnydb
 
  bunny-api:
    image: bunnydb/api:latest
    ports:
      - "8112:8112"
    environment:
      BUNNY_CATALOG_HOST: catalog
      BUNNY_CATALOG_PORT: 5432
      BUNNY_CATALOG_USER: bunny_catalog
      BUNNY_CATALOG_PASSWORD: secure-catalog-password
      BUNNY_CATALOG_DATABASE: bunnydb
      TEMPORAL_HOST_PORT: temporal:7233
      TEMPORAL_NAMESPACE: default
      BUNNY_WORKER_TASK_QUEUE: bunny-worker
      BUNNY_JWT_SECRET: your-very-long-random-secret-key-here-min-32-chars
      BUNNY_ADMIN_USER: admin
      BUNNY_ADMIN_PASSWORD: strong-admin-password
    depends_on:
      - catalog
      - temporal
    networks:
      - bunnydb
 
  bunny-worker:
    image: bunnydb/worker:latest
    environment:
      BUNNY_CATALOG_HOST: catalog
      BUNNY_CATALOG_PORT: 5432
      BUNNY_CATALOG_USER: bunny_catalog
      BUNNY_CATALOG_PASSWORD: secure-catalog-password
      BUNNY_CATALOG_DATABASE: bunnydb
      TEMPORAL_HOST_PORT: temporal:7233
      TEMPORAL_NAMESPACE: default
      BUNNY_WORKER_TASK_QUEUE: bunny-worker
    depends_on:
      - catalog
      - temporal
    networks:
      - bunnydb
    deploy:
      replicas: 2  # Run multiple workers for high availability
 
volumes:
  catalog-data:
  temporal-data:
 
networks:
  bunnydb:
    driver: bridge