MariaDB¶

VPS2 — Primary Database Server¶

Property	Value
Bind Address	0.0.0.0:3306 (accepts remote connections)
User	`redrum`

Databases¶

Database	Used By
vehicles_db	Parts scraper (scraper_v5.py) — main scraping data
yardpro	YardPro .NET app
CoC.Game / CoC.Login	Game server
Granger	Granger project
roundcube	Roundcube webmail
account_server	Account service
cq	CQ game
discord_bot	Discord bot

Remote Access¶

VPS2 MariaDB accepts remote connections. The scraper running locally connects through direct TCP.

Backup¶

# All databases
mysqldump -u redrum -p --all-databases --single-transaction > backup_$(date +%Y%m%d).sql

# Specific database
mysqldump -u redrum -p vehicles_db --single-transaction > backup_vehicles_$(date +%Y%m%d).sql

VPS1 — Local Only¶

Property	Value
Bind Address	127.0.0.1:3306 (local only)

Databases: account_server, cq, discord_bot

Common Commands¶

# Connect
mysql -u redrum -p

# Show databases
SHOW DATABASES;

# Check running queries
SHOW PROCESSLIST;

# Table sizes
SELECT table_name, ROUND(data_length/1024/1024, 2) AS size_mb
FROM information_schema.tables WHERE table_schema = 'vehicles_db';