Quotas, access restrictions, and functional restrictions
The size of a database is limited. The maximum size is 20 GB. It can be increased upon request. Please contact the RRZ service line for this purpose. If the maximum size of a database is exceeded, write access (insert, update, create, alter) to the database will be blocked. However, read access will still be possible. Write access can only be restored manually by the RRZ. Please also contact the service line for this.
Furthermore, for security reasons, access to the databases is restricted to the university network (*.uni-hamburg.de). It is not possible to assign rights for university subnets or individual hosts.
Users of the database server can access their database(s) using their user ID, but the password is not the one stored in the central user administration, but a local one that is only valid for use on the database server. Security considerations were the deciding factor in this decision.
Certain SQL statements are not possible or are blocked:
- LOAD_FILE
- INTO DUMPFILE
- LOAD DATA INFILE
- INTO OUTFILE
The reason for this is, on the one hand, that some of these statements cannot be replicated and, on the other hand, that users do not have direct access to the database server at file level.
The configuration of the database server system specifies further limitations or settings (e.g., the size and number of temporary tables), which we will inform you about on request. If your database application requires specific configuration settings, we will set these up if the operating concept of the database system allows it.
Database owners cannot grant other users the right to access their database (MariaDb: grant_priv=N). Please contact the RRZ via the service line to have these rights set up.
The “test” database can be used by any user of the MariaDb database server, but (as the name suggests) only for testing purposes, not for permanent use. We delete this database from time to time without notice and reserve the right to remove the database permanently.
Please note that the current versions of MySQL and MariaDb are no longer readily compatible.