5 Best Remote DBA Services in India (2026)

Probes TCP connection latencies and socket states across primary and replica database instances to identify network partitions and socket backlog saturation.

# 1. Audit TCP connection latency and socket responsiveness across DB nodes
for host in db-mysql-01 db-postgres-01 db-clickhouse-01; do
  echo "--- Probing ${host} ---"
  nc -zv -w 2 "${host}" 3306 2>&1 || nc -zv -w 2 "${host}" 5432 2>&1 || nc -zv -w 2 "${host}" 9000 2>&1
done

# 2. Check active network connection states and socket backlog
ss -s
ss -tan 'sport = :3306 or sport = :5432 or sport = :9000' | awk '{print $1}' | sort | uniq -c

Queries filesystem disk utilization, inode limits, and disk I/O queue wait times to catch storage saturation before outages occur.

# 1. Inspect storage volume consumption and inode limits
df -hT /var/lib/mysql /var/lib/postgresql /var/lib/clickhouse
df -i /var/lib/mysql /var/lib/postgresql /var/lib/clickhouse

# 2. Audit disk queue depth, service times, and IOPS saturation (%util)
iostat -xz 1 3 | awk 'NR>2 {print $1, $8, $9, $10, $14}'