参数组更改未反映在 Aurora Serverless 数据库集群上

2021-10-27 00:00:00 amazon-web-services mysql amazon-aurora

我正在尝试将我的 Aurora mysql 5.6.10(启用数据 API)实例中的 binlog_format 参数更新为 ROW，但我无法更改它.

I'm trying to update the binlog_format parameter in my Aurora mysql 5.6.10 (Data API enabled) instance to ROW but I'm not able to change it.

我已经相应地更新了我的自定义参数组，但是当我运行 show variables like 'binlog_format' 时，这些更改不会反映在集群上.

I've updated my custom parameter group accordingly but those changes do not reflect on the cluster when I run show variables like 'binlog_format'.

  • 更改参数组后，集群立即进入 Modifying 状态，但完成后参数尚未更新.
  • 我似乎无法在 AWS UI 上找到重启或停止集群的选项.
  • 使用 CLI 时，我在尝试停止集群时遇到此错误:调用 StopDBCluster 操作时发生错误 (InvalidDBClusterStateFault):这些配置不支持 Stop-db-cluster .立>
  • 尝试更改容量设置，但没有任何作用.
  • Right after changing the parameter group, the cluster goes into Modifying state but after that finishes the parameter hasn't been updated.
  • I can't seem to find an option to reboot or stop the cluster on the AWS UI.
  • Using the CLI, I get this error trying to stop the cluster: An error occurred (InvalidDBClusterStateFault) when calling the StopDBCluster operation: Stop-db-cluster is not supported for these configurations.
  • Tried changing the capacity settings but that didn't do anything.

还有什么我想念的方法吗?

Is there any other way I'm missing?

推荐答案

您必须通过运行以下命令来检查无服务器引擎是否支持特定的属性修改:

You'll have to check if the specific property modification is supported by serverless engine or not by running this command:

aws rds describe-db-cluster-parameters --db-cluster-parameter-group-name <param-group-name>

如果您阅读上述语句的输出，它会为 SupportedEngineModes 显示已配置":

If you read the output from above statement, it says 'provisioned' for SupportedEngineModes:

       {
            "ParameterName": "binlog_format",
            "ParameterValue": "OFF",
            "Description": "Binary logging format for replication",
            "Source": "system",
            "ApplyType": "static",
            "DataType": "string",
            "AllowedValues": "ROW,STATEMENT,MIXED,OFF",
            "IsModifiable": true,
            "ApplyMethod": "pending-reboot",
            "SupportedEngineModes": [
                "provisioned"
            ]
        }

对于可修改的参数，理想状态是这样的:

Ideal state is something like this for a modifiable parameter:

       {
            "ParameterName": "character_set_server",
            "Description": "The server's default character set.",
            "Source": "engine-default",
            "ApplyType": "dynamic",
            "DataType": "string",
            "AllowedValues": "big5,dec8,cp850,hp8,koi8r,latin1,latin2,swe7,ascii,ujis,sjis,hebrew,tis620,euckr,koi8u,gb2312,greek,cp1250,gbk,latin5,armscii8,utf8,ucs2,cp866,keybcs2,macce,macroman,cp852,latin7,utf8mb4,cp1251,utf16,cp1256,cp1257,utf32,binary,geostd8,cp932,eucjpms",
            "IsModifiable": true,
            "ApplyMethod": "pending-reboot",
            "SupportedEngineModes": [
                "provisioned",
                "serverless"
            ]
        },

相关文章