How should I do Database Configuration

Database Configuration

Below I 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 I change any configurations in this file I need to delete the following string in order not to lose my custom settings while update:

#Jelastic autoconfiguration mark.

CRON

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

For example, here I can set the scheduled backups of my 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. I can also use this folder for uploading my custom scripts.

CONF.D

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

In conf.d folder I 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 web server level.

CouchDB

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

That's All!