Database Administration
Monitor databases, manage backups, and track migrations.
Total Size
12.4 GB
+340 MB this week
Active Connections
89
of 280 max
Queries/sec
6,192
Avg across all DBs
Replication Lag
0.3ms
Within threshold
Databases
MySQL 8.0
navigateuz_main
Primary relational database — users, buildings, rooms, schedules
Size
8.2 GB
Connections
45/100
Uptime
43 days
Neo4j 5.x
navigateuz_graph
Graph database — campus navigation, routes, spatial queries
Size
1.8 GB
Connections
12/50
Uptime
43 days
InfluxDB 2.x
navigateuz_metrics
Time-series database — occupancy data, IoT sensor metrics
Size
1.9 GB
Connections
8/30
Uptime
43 days
Redis 7.x
navigateuz_cache
In-memory cache — sessions, rate limiting, real-time data
Size
512 MB
Connections
24/100
Uptime
43 days
Backup Schedule
| Database | Schedule | Last Run | Status |
|---|---|---|---|
| MySQL | Daily 02:00 | Mar 24, 02:00 | success |
| Neo4j | Daily 02:30 | Mar 24, 02:30 | success |
| InfluxDB | Daily 03:00 | Mar 24, 03:00 | success |
| Redis | Every 6h | Mar 24, 06:00 | success |
| Full Backup | Weekly Sun 01:00 | Mar 22, 01:00 | success |
Migration Status
20260324_001
Add indoor navigation tables
applied
Mar 24, 2026
20260322_001
Add occupancy predictions index
applied
Mar 22, 2026
20260320_002
Create schedule conflicts view
applied
Mar 20, 2026
20260320_001
Add user preferences column
applied
Mar 20, 2026
20260318_001
Create audit log table
applied
Mar 18, 2026
20260325_001
Add floor plan metadata
pending
Pending