Skip to content

Configuration Files Management

Clicking the "File Editor" tab of the instance detail, opens a new tab where users are able of modifying the different configuration files available for each type of instance.

Users can edit the files using the embedded editor or by means of downloading/uploading the configuration files.

DBOD does not provide versioning for these configuration files, so locally saving the previous version when making changes is always recommended.

file_management

Click on one of the buttons to upload or download the configuration file. The Download button will provide you with the file stored on your server.

Clicking the Upload button will open the file in the online file editor.

Once you have performed/uploaded your changes to the online editor, you can click the button "Submit changes", which will check the validity of your changes. If any error or illegal value is found an error will be shown on the top of the online editor. If no errors are found it will copy the configuration file to the server, and for postgres you can choose to reload the configuration at the same time.

MySQL

Configuration files

The following parameters cannot be changed in my.cnf through the web interface:

- allow-suspicious-udfs
- automatic_sp_privileges
- binlog_checksum
- binlog_expire_logs_seconds
- binlog_format
- chroot
- datadir
- default_authentication_plugin
- expire_logs_days
- general-log-file
- innodb-read-io-threads
- innodb_checksum_algorithm
- innodb_file_per_table
- innodb_flush_log_at_trx_commit
- innodb_flush_method
- innodb_io_capacity
- innodb_log_file_size
- innodb_open_files
- innodb_write_io_threads
- key_buffer_size
- local_infile
- log-bin
- log_error
- log_output
- log-slave-updates
- max_allowed_packet
- max_binlog_size
- max_heap_table_size
- mysqlx
- mysqlx_cache_cleaner
- performance_schema
- port
- safe-user-create
- secure_file_priv
- server-id
- skip-grant-tables
- skip_name_resolve
- skip_networking
- skip_show_database
- slow_query_log
- slow_query_log_file
- socket
- ssl-ca
- ssl-cert
- ssl-cipher
- ssl-key
- sync_binlog
- table_definition_cache
- table_open_cache
- thread_cache_size
- tmp_table_size

The following parameters can be changed in my.cnf through the web interface, but only in a specific range (min,max):

- innodb_buffer_pool_size (100M, 2G)
- max_connections (10, 1000)
- max_user_connections (10, 1000)

If you want to change these parameters, please open a ticket.

PostgreSQL

Configuration files

Select the type of configuration file (postgresql.conf or pg_hba.conf) in the selector, this will open the selected configuration file on the online editor.

The following parameters cannot be changed in postgresql.conf through the web interface:

- achive_command
- archive_mode
- datestyle
- default_text_search_config
- full_page_writes
- hot_standby
- lc_messages
- lc_monetary
- lc_numeric
- lc_time
- listen_addresses
- log_destination
- log_directory
- log_filename
- log_line_prefix
- log_rotation_age
- log_rotation_size
- log_timezone
- log_truncate_on_rotation
- logging_collector
- max_wal_size
- min_wal_size
- port
- ssl
- ssl_ca_file
- ssl_cert_file
- ssl_ciphers
- ssl_key_file
- timezone
- unix_socket_directories

The following parameters can be changed in postgresql.conf through the web interface, but only in a specific range (min,max):

- max_connections (10, 150)
- shared_buffers (100MB, 2GB)

If you want to change these parameters, please open a ticket.

For pg_hba.conf you are not allowed to change the file above this line:

# User related -- PLEASE EDIT HERE

InfluxDB

Configuration files

The following parameters cannot be changed in influxdb.conf through the web interface:

reporting-disabled
bind-address
[meta]
    dir
    retention-autocreate
    logging-enabled
[data]
    dir
    wal-dir
    index-version
    cache-snapshot-write-cold-duration
    compact-full-write-cold-duration
    max-series-per-database
    series-id-set-cache-size
[coordinator]
    max-concurrent-queries
    query-timeout
    log-queries-after
[retention]
    enabled
[shard-precreation]
    enabled
[monitor]
    store-enabled
    store-database
    store-interval
[http]
    enabled
    flux-enabled
    flux-log-enabled
    bind-address
    auth-enabled
    log-enabled
    access-log-path
    write-tracing
    pprof-enabled
    https-enabled
    https-certificate
    https-private-key
    max-connection-limit
[logging]
    format
    level
[subscriber]
    enabled
[continuous_queries]
    enabled
    log-enabled
    run-interval

If you want to change these parameters, please open a ticket.