問題描述

我正在嘗試將我的 Aurora mysql 5.6.10(啟用數(shù)據(jù) API)實(shí)例中的 binlog_format 參數(shù)更新為 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.

我已經(jīng)相應(yīng)地更新了我的自定義參數(shù)組，但是當(dāng)我運(yùn)行 show variables like 'binlog_format' 時(shí)，這些更改不會反映在集群上.

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'.

• 更改參數(shù)組后，集群立即進(jìn)入 Modifying 狀態(tài)，但完成后參數(shù)尚未更新.
• 我似乎無法在 AWS UI 上找到重啟或停止集群的選項(xiàng).
• 使用 CLI 時(shí)，我在嘗試停止集群時(shí)遇到此錯誤:調(diào)用 StopDBCluster 操作時(shí)發(fā)生錯誤 (InvalidDBClusterStateFault):這些配置不支持 Stop-db-cluster .立>
• 嘗試更改容量設(shè)置，但沒有任何作用.

• 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?

推薦答案

您必須通過運(yùn)行以下命令來檢查無服務(wù)器引擎是否支持特定的屬性修改:

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"
            ]
        }

對于可修改的參數(shù)，理想狀態(tài)是這樣的:

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"
            ]
        },

這篇關(guān)于參數(shù)組更改未反映在 Aurora Serverless 數(shù)據(jù)庫集群上的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！