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
| 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
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
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
CONF.D
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!