[mysqld]
# ── Binary logging (Point-in-Time Recovery) ──────────────────
log-bin                = mysql-bin
binlog_format          = ROW
binlog_row_image       = FULL
expire_logs_days       = 7
max_binlog_size        = 100M
sync_binlog            = 1          # flush to disk on every commit (safe)

# ── Server identity (required for replication) ───────────────
server-id              = 1

# ── InnoDB durability ─────────────────────────────────────────
innodb_flush_log_at_trx_commit = 1  # full ACID — never lose a committed txn

# ── Performance ───────────────────────────────────────────────
innodb_buffer_pool_size = 512M      # adjust to ~50-70% of available RAM