Setting Database Options Related to Retry and Back Off

The following table describes the options you can set to define the retry and back-off policy for a database.

Database Option (Key in Automation Console) Option Argument (Value in Automation Console) Default Description
backoff.reqMinUptime n 30000

Specifies the minimum required time, in milliseconds, for a database process to be available before it is considered for restart. The default is 30 seconds. Specify -1 to disable the retry and back-off mechanism. However, NuoDB strongly advises you to keep the retry and back-off mechanism turned on. For more information, see About the Retry and Back-Off Mechanism.

backoff.maxRetry n 10

Specifies the maximum number of times to try restarting a database process. If the maximum retry number is reached and the process does not restart then enforcement stops for that process. If backoff.stopOnMaxRetry is false then enforcement stops only for that process. If backoff.stopOnMaxRetry is true then enforcement stops for the database and the database is then in a STOPPED state with regard to enforcement. In other words, enforcement is disabled but the database can be active and running while enforcement is stopped.

backoff.delay n 60000 Specifies the initial amount of time in milliseconds for the broker to wait before retrying a database process. The delay time between retries increases two times (2x) with each retry. The default is 60 seconds.
backoff.stopOnMaxRetry true | false false If backoff.stopOnMaxRetry is true and backoff.maxRetry is met for at least one process, then the database will be in the STOPPED state with regard to enforcement. In other words, enforcement is disabled but the database can be active and running while enforcement is stopped.