Resetting Amazon DocumentDB Cluster Parameter Groups

    Follow these steps to reset some or all of a cluster parameter group’s parameter values to their default values.

    To reset a cluster parameter group’s parameter values

    1. Sign in to the AWS Management Console, and open the Amazon DocumentDB console at https://console.aws.amazon.com/docdb.

    2. In the navigation pane on the left side of the console, choose Parameter groups.

    3. In the Cluster parameter groups pane, choose the name of the cluster parameter group that you want to reset.

    4. Choose Actions, and then choose Reset to reset that parameter group.

    5. On the resulting Cluster parameter group reset confirmation page, confirm that you want to reset all cluster parameters for that parameter group to their defaults. Then choose Reset to reset your parameter group. You can also choose Cancel to discard your changes.

    To reset some or all of a cluster parameter group’s parameter values to their default values, use the operation with the following parameters.

    • --parameters — Optional. A list of ParameterName and ApplyMethod in the cluster parameter group to reset to their default values. Static parameters must be set to pending-reboot to take effect on the next instance restart or reboot-db-instance request. You must call reboot-db-instance for every instance in your cluster that you want the updated static parameter to apply to.

      This parameter and --reset-all-parameters are mutually exclusive: you can use either one but not both.

    • --reset-all-parameters or — Optional. Specifies whether to reset all parameters (--reset-all-parameters or only some of the parameters (--no-reset-all-parameters) to their default values. The --reset-all-parameters parameter and --parameters are mutually exclusive: you can use either one but not both.

      When you reset the entire group, dynamic parameters are updated immediately. Static parameters are set to pending-reboot to take effect on the next instance restart or reboot-db-instance request. You must call reboot-db-instance for every instance in your cluster that you want the updated static parameter applied to.

    Example 1: Resetting all parameters to their default values

    The following code resets all parameters in the cluster parameter group sample-parameter-group their default values.

    For Linux, macOS, or Unix:

    For Windows:

    1. aws docdb reset-db-cluster-parameter-group ^
    2. --reset-all-parameters

    The following code resets the tls parameter in the cluster parameter group sample-parameter-group to its default value.

    For Linux, macOS, or Unix:

    For Windows:

    1. --db-cluster-parameter-group-name sample-parameter-group ^
    2. --no-reset-all-parameters ^
    3. --parameters ParameterName=tls,ApplyMethod=pending-reboot

    Output from this operation looks something like the following (JSON format).

    Rebooting a cluster instance

    Before a static parameter’s value is changed, the cluster instance must be rebooted. Reboot each instance in your cluster that you want the updated static parameter to apply to.

    For Linux, macOS, or Unix:

    1. aws docdb reboot-db-instance \
    2. --db-instance-identifier sample-cluster-instance

    For Windows: