Database Configuration

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

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

MySQL #

FolderFilePath
etcmy.cnf
php.ini
/etc
cronmysql/var/spool/cron
scriptsbackup_script.sh/var/lib/jelastic/bin/
backup/var/lib/jelastic/backup
keys/var/lib/jelastic/keys
conf.dMyAdmin-jel.conf/etc/httpd/conf.d/

    MariaDB #

    FolderFilePath
    etcmy.cnf
    php.ini
    /etc
    cronmysql/var/spool/cron
    scriptsbackup_script.sh/var/lib/jelastic/bin/
    backup/var/lib/jelastic/backup
    keys/var/lib/jelastic/keys
    conf.dMyAdmin-jel.conf/etc/httpd/conf.d/

      MongoDB #

      FolderFilePath
      etcmongod.conf
      php.ini
      /etc
      cronmongod/var/spool/cron
      scriptsbackup_script.sh/var/lib/jelastic/bin/
      backup/var/lib/jelastic/backup
      keys/var/lib/jelastic/keys

        PostgreSQL #

        FolderFilePath
        confpostgresql.conf
        pg_hba.conf
        pg_ident.conf
        /var/lib/pgsql/data/
        etcphp.ini/etc
        cronpostgres/var/spool/cron
        scripts/var/lib/jelastic/bin/
        backup/var/lib/jelastic/backup
        keys/var/lib/jelastic/keys
        conf.dphpPgAdmin/etc/httpd/conf.d/

          CouchDB #

          FolderFilePath
          couchdbdefault.ini
          local.ini
          /etc/couchdb/
          etcphp.ini/etc
          croncouchdb/var/spool/cron
          scripts/var/lib/jelastic/bin/
          backup/var/lib/jelastic/backup
          keys/var/lib/jelastic/keys
          conf.dcouchdb.conf/etc/httpd/conf.d/

            ETC #

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

            database-configuration-files 1

            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 update:
            #Jelastic autoconfiguration mark.

            save custom settings

            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 the custom requirements.

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

            database-configuration-files 2

            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.

            database-configuration-files 3

            BACKUP #

            This folder is used for storing the backup files of your database. These files can be used for restoring the data.

            The instructions on how to restore these files can be found in the following documentation:

            database-configuration-files 4

            KEYS #

            The keys directory is used as a location for uploading any private key which is needed for your application.

            Generate the key, save it as a simple file and upload to the key folder. Now you can use it for different cases by simply stating the path to your key:

            /var/lib/jelastic/keys/{key_file_name}

            database configuration files 5

            CONF.D #

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

            confd mysql

            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 web server level.

            CONF #

            The main configuration files of the PostgreSQL database server are located in the conf folder.

            database configuration files 7

            COUCHDB #

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

            database configuration files 8

            Powered by BetterDocs