Modifying Database Option Settings

Automation Console

You can modify database options in the Edit Database panel of the Automation Console while your database is still running, but a restart of the database may have to happen in order for the new option to take effect. See Database Options for more information about setting database options. Modifying database options in the Default Database Options>> panel, will modify the option for all processes in the domain. Modifying database options in the Process Group Options>> panel, will modify the option for all processes in that process group. A process group is a combination of an optional region and either TEs or SMs, meaning all transaction engines in one or all regions or all storage managers in one or all regions.

Note: See Database Options for information about important distinctions between database process options and database system options. Note that database process options will not take effect until that process (TE, SM, or SSM) is restarted.

Options that should be specified per host (for example, options that might point at local directories) should be specified in the nuodb.config file.

In the following example, we will add the database option, journal-max-directory-entries. Since this only applies to storage managers, we will set it for the SMs process group only. In the Edit Database panel of the Automation Console, expand Process Group Options>> and click on the plus sign to add a new line for a new option.

Choose the SMs process group, and click under Key and enter journal-max-directory-entries and click under Value to add 500, for example.

NuoDB Manager

nuodb [domain] > show database config
Database: test
Database: test, ACTIVE, Status=RUNNING, template [Single Host]
  Variables: {HOST=fe597e42-201b-491f-ac94-b9906f777753}
  Options: {}
  Default Options: { "commit": "${COMMIT:remote:1}","backoff.reqMinUptime":"30000"}
  Process group options:
  Process group tag constraints:
  Archive Locations:
    ip-172-31-2-230/54.148.240.227:48004, requirements: SMs, region: us-west-2:
      archive: /var/opt/nuodb/production-archives/test
      journal-dir: /var/opt/nuodb/production-archives/test
  Single Host MET

nuodb [domain] > update database
Database Name: test
Template Name (Single Host, Minimally Redundant, Multi Host, Region distributed): Single Host
Template Variables (optional): 
Database Options (optional): 
Template Variable HOST (default: localhost): 52.24.143.83
Database Options for SMs (optional): journal-max-directory-entries 500
Tag Constraints for SMs (optional): 
Database Options for TEs (optional): 
Tag Constraints for TEs (optional): 
 
nuodb [domain] > show database config
Database: test
Database: test, ACTIVE, Status=RUNNING, template [Single Host]
  Variables: {HOST=fe597e42-201b-491f-ac94-b9906f777753}
  Options: {}
  Default Options: { "commit": "${COMMIT:remote:1}","backoff.reqMinUptime":"30000"}
  Process group options:
     SMs: {journal-max-directory-entries=500}
  Process group tag constraints:
  Archive Locations:
    ip-172-31-2-230/54.148.240.227:48004, requirements: SMs, region: us-west-2:
      archive: /var/opt/nuodb/production-archives/test
      journal-dir: /var/opt/nuodb/production-archives/test
  Single Host MET