Database Configuration

Database Configuration

Below you will see the list of the configuration files available for editing in the database servers:

• MySQL
• MariaDB
• MongoDB
• PostgreSQL
• CouchDB

To get more information on which settings can be changed in the provided config folders, use the appropriate descriptions:

• etc
• cron
• scripts
• backup
• keys
• conf.d
• conf
• CouchDB

MySQL

Folder	File	Path
etc	my.cnf  php.ini	/etc
cron	mysql	/var/spool/cron
scripts	backup_script.sh	/var/lib/jelastic/bin/
backup		/var/lib/jelastic/backup
keys		/var/lib/jelastic/keys
conf.d	MyAdmin-jel.conf	/etc/httpd/conf.d/

 MariaDB

Folder	File	Path
etc	my.cnf  php.ini	/etc
cron	mysql	/var/spool/cron
scripts	backup_script.sh	/var/lib/jelastic/bin/
backup		/var/lib/jelastic/backup
keys		/var/lib/jelastic/keys
conf.d	MyAdmin-jel.conf	/etc/httpd/conf.d/

 MongoDB

Folder	File	Path
etc	mongod.conf  php.ini	/etc
cron	mongod	/var/spool/cron
scripts	backup_script.sh	/var/lib/jelastic/bin/
backup		/var/lib/jelastic/backup
keys		/var/lib/jelastic/keys

PostgreSQL

Folder	File	Path
conf	postgresql.conf pg_hba.conf pg_ident.conf	/var/lib/pgsql/data/
etc	php.ini	/etc
cron	postgres	/var/spool/cron
scripts		/var/lib/jelastic/bin/
backup		/var/lib/jelastic/backup
keys		/var/lib/jelastic/keys
conf.d	phpPgAdmin	/etc/httpd/conf.d/

 CouchDB

Folder	File	Path
CouchDB	default.ini local.ini	/etc/couchdb/
etc	php.ini	/etc
cron	couchdb	/var/spool/cron
scripts		/var/lib/jelastic/bin/
backup		/var/lib/jelastic/backup
keys		/var/lib/jelastic/keys
conf.d	couchdb.conf	/etc/httpd/conf.d/

ETC 

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

MySQL and MariaDB also include my.cnf config file for database settings. Note that if you change any configurations in this file you need to delete the following string in order not to lose your custom settings while updating:

#Jelastic autoconfiguration mark.

CRON

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

For example, here you can set the scheduled backups of your database. For MySQL, MariaDB, and MongoDB servers, there are already cron settings which can be used to run the default backup script. These settings just need to be uncommented and edited based on custom requirements. 

The detailed information on Cronjob configuration can be found in the Setting Up a Cronjob document. 

SCRIPTS

The scripts folder contains the default script for backup of MySQL, MariaDB, and MongoDB servers. You can also use this folder for uploading your custom scripts. 

CONF.D

The conf.d folder is usually used for storing and managing sub configs. 

In conf.d folder you have access to the MyAdmin-jel.conf (for MariaDB and MySQL), phpPgAdmin(for PostgreSQL) and couchdb.conf (for CouchDB) files.

These files can be edited in order to set appropriate criteria for allowing or denying access by IP address or domain to the application with the database on an Apache webserver level.

CouchDB

This folder is used for storing and managing the main CouchDB config files.