Database Configuration

In this guide, we’ll list all the main configuration files in the Jelastic-managed database servers. Each line of the table corresponds to the folder with configs for the databases listed in the Database Types column.

FolderPathDatabase Types
conf/var/lib/pgsql/dataPostgreSQL
etc/etcall
cron/var/spool/cronall
scripts/var/lib/jelastic/binall
backup/var/lib/jelastic/backupall
keys/var/lib/jelastic/keysall
conf.d/etc/httpd/conf.dMySQL, MariaDB, Percona, PostgreSQL

ETC

The PHP configurations are performed in the php.ini file, which is located in the etc folder.

database php.ini

MySQL, MariaDB and Percona include the my.cnf configuration file for database management. Note that Jelastic automatically manages the following settings in this file:

  • key_buffer_size
  • table_open_cache
  • myisam_sort_buffer_size
  • innodb_buffer_pool_size

If you want to manually change any of the settings from the list above, you need to remove the “#Jelastic autoconfiguration mark.” line at the start of the file. Otherwise, your custom changes will be overwritten.

Tip: Alternatively, you can override any of the settings in the /etc/my.cnf file (including ones managed by Jelastic autoconfiguration mark) by stating them in the /etc/mysql/conf.d/custom.cnf file.

MySQL my.cnf

CRON

The database servers include the /var/spool/cron folder with a config file, where cron jobs can be configured.

For example, you can set the scheduled backups of your database. The required cron expression is included in the cron config file by default. You just need to uncomment the appropriate line and, if necessary, adjust it based on your custom requirements.

database cron config

You can find more information in the Setting Up Cronjob documentation.

SCRIPTS

This folder contains the default backup_script.sh script. You can also use the /var/lib/jelastic/bin folder for uploading your custom scripts.

database scripts folder

BACKUP

The /var/lib/jelastic/backup folder is used for storing the database backup files. You can use these files for restoring your database data.

database backup folder

KEYS

The /var/lib/jelastic/keys directory is used as a location for uploading private keys that are needed for your application.

Generate the key, save it as a simple file, and upload it to the keys folder. You can then use it for different cases by merely stating the path to your key, i.e. /var/lib/jelastic/keys/{keyName}.

database keys folder

CONF.D

The /etc/httpd/conf.d folder is usually used to store and manage sub-configs.

database conf.d folder

For example, you can access the admin panel configuration file (depends on the database, e.g. phpMyAdmin-jel.conf for MySQL) via the conf.d folder. Use these files to set appropriate criteria for allowing/denying access by IP address or domain.

CONF

The main configuration files of the PostgreSQL database server are located in the /var/lib/pgsql/data folder. For example, it includes configs such as postgresql.conf, pg_hba.conf, pg_ident.conf, etc.

postgresql.conf configuration file

Jelastic PaaS automatically manages the following two parameters in the /var/lib/pgsql/data/postgresql.conf file for PostgreSQL databases:

  • shared_buffers - calculates as a part of total RAM - quarter if a container has eight or more cloudlets, seventh part otherwise (but not less than 128 KB)
  • max_stack_depth - calculates as 1024 subtraction from the maximum stack size (response of the ulimit -s command), converted to MB

If you want to change any of these settings manually, you need to remove the “#Jelastic autoconfiguration mark.” line at the start of the file. Otherwise, your custom changes will be overwritten.

What’s next?