🎉 拥抱现代化运维,GoPanel强势来袭! 查看详情 →

Databases

Create databases, grant least privilege and keep reliable backups.

The database manager handles creation, accounts and backups for the common engines from one place.

Create a database

Create the database and a dedicated application account instead of using the root account for the app.

Grant least privilege

Give the app account only the permissions it needs on its own database. Keep administrative credentials separate and used only for management.

Do not reuse one account across unrelated applications.

Back up and restore

Set a periodic backup schedule and a retention policy, and test a restore before you need it. A backup you have never restored is not a backup yet.

Change schemas safely

Back up before any structural change, apply it through migrations rather than ad-hoc statements, and keep an audit trail for key operations.