Configuration Options
Nine configures environments to cover a wide range of requirements. In addition, it is possible to customize some options directly through our Cockpit.
Please note that we cannot make manual changes to the configuration. We are happy to implement individual configuration requests as part of a Managed Server.
General configuration parameters
You can use the following configuration parameters to customize the database instance to your needs.
Name
The name of the database instance can be freely chosen, but must be unique. Once created, the name cannot be changed.
Backup retention
The backup retention period in days can be selected between 0 and 365 days.
If 0 days is selected, the backup routine will be disabled and all existing backups will be deleted.
Please note that the storage space requirement increases if the local retention period is long. This may result in higher instance costs. We have summarized information about automatic disk space expansion in this article: Automatic Storage Expansion.
For more information about backing up your databases on a daily basis, accessing the backups, and how to create your own backups if needed, see the following article: Database Backup Information.
Machine type
To meet the requirements of your environment, Nine provides multiple machine types. The machine type can be customized to your needs at a later time.
Please note that after an adjustment, the database instance will be restarted and will be unavailable for a few minutes.
The available machine types are documented in the article Nine Kubernetes Engine. Please note that for some services only a subset of machine types is available.
The storage space of a database instance is initially set to 25 GB. The storage space is automatically extended if required. For more information, see the article Automatic storage space expansion.
Location
Database instances can be created at three different locations, depending on the available resources.
These are two rooms in the "ColoZüri" data center and the "NTT" data center in Rümlang. The location of the database instance cannot be adjusted afterwards.
Allowed IP addresses
Here you can define IPv4 addresses and address ranges from which you want to establish connections to the database service. Access from our Kubernetes products NKE and GKE as well as from deplo.io is already enabled.
The access restriction can be adjusted at any time. Adjustments are made non-disruptively moments after the form is submitted.
SSH Public-Keys
In this field you can store SSH public keys to access the database backups via SSH. The SSH keys can be adjusted at any time.
For more information about database backups, see the article Information about database backups.
PostgreSQL
Version
You can select your desired PostgreSQL version when creating the database instance. The version cannot be adjusted after the instance is created.
In the following table you can find the support period of each PostgreSQL version:
| PostgreSQL Version | Support End |
|---|---|
| 16 | November 09, 2028 |
| 15 | November 11, 2027 |
| 14 | November 12, 2026 |
| 13 | November 13, 2025 |
Extensions
Nine provides a variety of extensions that you can activate as needed. The following extensions are available:
- address_standardizer
- address_standardizer_data_us
- btree_gin
- btree_gist
- citext
- cube
- dict_int
- earthdistance
- fuzzystrmatch
- hstore
- intarray
- isn
- lo
- ltree
- pg_prewarm
- pg_stat_statements
- pg_trgm
- pgcrypto
- plpgsql
- postgis
- postgis_tiger_geocoder
- postgis_topology
- seg
- tablefunc
- tcn
- tsm_system_time
- tsm_system_rows
- unaccent
- uuid-ossp
MySQL
Adjusting the MySQL configuration parameters results in a restart of the database service. Restarting the service may take several minutes.
Version
Nine currently provides On-Demand MySQL environments with MySQL 8 only.
Long Query Time
The "Long Query Time" specifies the time in seconds after which the MySQL service considers the execution of a query to be slow and logs the query.
Min Word Length
This value configures the minimum length of a word that MySQL will use for full text search.
Nine sets the value chosen here for both ft_min_word_len (MyISAM Storage Engine, Legacy) and innodb_ft_min_token_size (InnoDB Storage Engine).
Character Set
You have the possibility to customize the character set used by the service according to your needs. From experience the default values utf8mb4_unicode_ci / utf8mb4 cover the usual needs.
If you are considering customizing these values, please consult the MySQL documentation in advance: Character Sets and Collations in MySQL
Transaction Isolation
Nine recommends not making any adjustment to the selected default value unless absolutely necessary due to application requirements.
Be sure to consult the MySQL documentation in advance and familiarize yourself with the related implications: Transaction Isolation Levels.
SQL Modes
The SQL Mode should also only be adjusted if the application absolutely requires it. Nine uses the default values set by Oracle for MySQL 8.
Oracle provides documentation and FAQ about SQL Modes in the following articles: