Specifying Retry and Back-Off Policy for a Process Group

When you create a database you can specify a retry and back-off policy that applies to one process group, for example, it could apply to only the SMs group in the built-in templates. Specification of a retry and back-off policy for a process group overrides the retry and back-off policy specified for the database.

To use the Automation Console to create a database and specify the retry and back-off policy for a process group:

  1. In the left panel, click Databases .
  2. In the upper right corner, select Actions > Add Database.
  3. In the Create Managed Database dialog, fill in the fields. See Creating Databases Using Automation Console.
  4. In the Create Managed Database dialog, click Process Group Options to expand it and then click the plus sign that appears on the right side. The Automation Console displays a new line for adding a process group option.
  5. In the new line, click below Group and select a process group.
  6. Click below Key and enter backoff.reqMinUptime.
  7. Click below Value and enter a number of milliseconds. For example, 60000 milliseconds indicates one minute.
  8. Click Submit.

To use NuoDB Manager to specify the retry and back-off policy for a process group, specify groupOptions as part of the database options, identify the process group you want to set the option for, and then set the backoff.reqMinUptime option to the desired value. You can specify additional options as well. Use the following format:

groupOptions:process_group_name 'option_name option_value [option_name option_value]...'

For example, the following command creates a database that has a retry and back-off policy for the database as a whole. A process must be up for a minimum of 30 seconds before the broker tries to restart a failed process.

create database dbname foo template 'Single Host' dbaUser dba dbaPassword dba \
options 'mem 1g backoff.reqMinUptime 30000'

Suppose you want a storage manager process to be up for a minimum of 60 seconds. To override the database's retry and back-off policy for the SMs process group, you would use a command such as the following to create the database:

create database dbname foo template 'Single Host' dbaUser dba dbaPassword dba \
options 'mem 1g backoff.reqMinUptime 30000' groupOptions:SMs 'mem 2g backoff.reqMinUptime 60000'