🗄️ DB Manager / 数据库管理

Install, manage, backup, and optimize popular databases. MySQL, PostgreSQL, MongoDB, Redis. 安装、管理、备份、优化主流数据库：MySQL、PostgreSQL、MongoDB、Redis。

Quick Install / 快速安装

# PostgreSQL
apt install postgresql postgresql-contrib
systemctl enable postgresql --now

# MySQL
apt install mysql-server
mysql_secure_installation

# Redis
apt install redis-server
systemctl enable redis --now

Backup / 备份

# PostgreSQL
pg_dump -U postgres mydb > backup_$(date +%Y%m%d).sql

# MySQL
mysqldump -u root mydb > backup_$(date +%Y%m%d).sql

# Auto-backup script / 自动备份脚本
echo "0 3 * * * pg_dump -U postgres mydb | gzip > /backup/db_\$(date +\%Y\%m\%d).sql.gz" | crontab -

Optimize / 性能优化

-- PostgreSQL slow queries / 慢查询
SET log_min_duration_statement = 1000;  -- Log queries >1s

-- MySQL slow queries
SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 2;

Troubleshooting / 故障排查

systemctl status postgresql
journalctl -u postgresql -n 30
tail -f /var/log/postgresql/postgresql-*-main.log

📞 Contact / 联系方式

QQ: 3292957 | Email: snowdu@gmail.com

QR Code: see assets/qr-contact.png