Database
- Introduction
- Supported Databases
- Install Database
- Uninstall Database
- Create Database
- Delete Database
- Sync Databases
- Create Database User
- Link User to Database
- Sync Database Users
- Backup
Introduction
Vito provides a simple interface to manage your databases disregards to their type, and you can create databases, users, and link users to databases.
Supported databases
- Mysql 5.7
- Mysql 8.0
- Mariadb 10.3
- Mariadb 10.4
- Mariadb 10.6
- Mariadb 10.11
- Mariadb 11.4
- Postgresql 12
- Postgresql 13
- Postgresql 14
- Postgresql 15
- Postgresql 16
- Postgresql 17
Install database service
To install a database, you can select the database type and version during the server creation.
Vito also allows you to install databases after the server creation in the Services section.
Every server can have only one database type installed. For example, you can not install both Mysql and Postgresql on the same server.
Uninstall database
To uninstall a database, you can go to the Services section and Uninstall
the database you
want to
remove.
Vito won't allow the database service to be uninstalled if there are any databases or users or backups created for that. You will need to delete them first.
Create database
To create a database, you can go to the Databases
section in the server's menu and click on the Create
button.
Enter a unique name for the database and select a charset and collation for the database.
The charsets and collations are fetched from the database server when the database service is installed.
Delete database
To delete a database, you can go to the Databases
section in the server's menu and click on the Delete
in the
database menu. Vito will ask you to confirm the deletion of the database.
Sync databases
Sometimes you might need to create a database manually on the server, or you might have created a database using the command line.
Vito allows you to sync the databases that are created manually on the server with the Vito's database management system.
To sync the databases, you can go to the Databases
section in the server's menu and click on the Sync
button.
Syncing databases will also sync the charsets and collations of the databases again.
Create database user
To create a database user, you can go to the Database Users
section in the server's menu and click on the Create
You can allow a database user to be accessed from outside the server by checking the Allow remote access
. Then you
will need to provide the IP address or hostname of the remote machine that will access the database.
Users can have the following permissions:
MySQL/MariaDB:
- READ: SELECT, SHOW VIEW
- WRITE: SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, LOCK TABLES, REFERENCES, SHOW VIEW, TRIGGER, CREATE VIEW, EXECUTE (excludes DROP and TRUNCATE)
- ADMIN: ALL PRIVILEGES
PostgreSQL:
- READ: CONNECT, USAGE, SELECT on database, schemas, tables, and sequences
- WRITE: CONNECT, USAGE, CREATE, SELECT, INSERT, UPDATE, DELETE, REFERENCES, TRIGGER, EXECUTE (excludes DROP and TRUNCATE)
- ADMIN: ALL PRIVILEGES on database, tables, and sequences
Link user to database
Creating a database and a user is not enough to use the database, You need to link the user to the database.
Vito provides a simple interface to link users to databases. You can simply link a user to multiple databases in the
Database Users
section.
Sync database users
Sometimes you might need to create a database user manually on the server, or you might have created a user using the command line.
Vito allows you to sync the database users that are created manually on the server with the Vito's database management system.
Backup
Vito supports database auto backups. It runs backups for your databases and stores them in the external storages that you provide.
To create a backup you need to connect a storage provider and then create the backup
in the Backups
section in the
Databases
menu.
After creating a backup, you can restore the backup files into the same or other databases.
Backups have a retention policy, which means that Vito will automatically delete the old backups based on the retention policy you set.
To set the retention policy, you can set the Backups to keep
field when creating a backup. You can edit this later as
well.
Vito will not allow you to create a backup if there are no storage providers connected.
You can also define an interval for the backups to be created automatically. This can be done when creating a backup or by editing the backup later.