Primary Database
Host:
db-primary-01.internal.net
Port:
5432
Database:
production_db
Status:
ONLINE
Connection Pool:
45/100
Version:
MariaDB 10.1
Replica Database
Host:
db-replica-02.internal.net
Port:
5432
Replication Lag:
0.23s
Status:
SYNCED
Connection Pool:
28/80
Sync Mode:
Asynchronous
Tunnel Configuration
Tunnel Type:
SSH Encrypted
Gateway:
t2.mysql.pterohost.ru (not public)
Local Port:
15432
Remote Port:
5432
Status:
ESTABLISHED
Encryption:
AES-256-GCM
Connection Details
Protocol:
TCP/IP
SSL Mode:
require
Timeout:
30s
Keepalive:
ENABLED
Max Connections:
200
Charset:
UTF8
Cache Layer
Redis Host:
redis-01.cache.internal
Port:
6379
Status:
CONNECTED
Memory Usage:
2.4GB / 8GB
Hit Rate:
94.7%
Keys:
1,247,893
Load Balancer
Type:
HAProxy
Algorithm:
Round Robin
Active Backends:
4/4
Health Check:
PASSING
Requests/sec:
1,847
Avg Response:
23ms
● Connection Log
[2025-10-08 14:23:47]
[SUCCESS] Primary database connection established
[2025-10-08 14:23:47]
[INFO] SSL handshake completed (TLS v1.3)
[2025-10-08 14:23:48]
[SUCCESS] SSH tunnel initialized on port 15432
[2025-10-08 14:23:48]
[INFO] Tunnel gateway: t2.mysql.pterohost.ru (not public) (authenticated)
[2025-10-08 14:23:49]
[SUCCESS] Replica database synchronized
[2025-10-08 14:23:49]
[INFO] Connection pool initialized (100 connections)
[2025-10-08 14:23:50]
[SUCCESS] Redis cache layer connected
[2025-10-08 14:23:50]
[INFO] Load balancer health check: OK
[2025-10-08 14:23:51]
[WARN] High query volume detected (3421 q/s)
[2025-10-08 14:23:52]
[INFO] Auto-scaling triggered: +2 read replicas
[2025-10-08 14:23:53]
[SUCCESS] Failover test completed successfully
[2025-10-08 14:23:54]
[INFO] Backup snapshot created: backup_20251008_142354.sql
[2025-10-08 14:23:55]
[SUCCESS] All systems operational
[2025-10-08 14:23:56]
[INFO] Monitoring heartbeat: 200 OK