1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
You can specify a parameter group using the api create-db-instance-read-replica
also, for memory parameters you can use formulas that are based on the size of the instance, this allows a common parameter group to work for any instance size:
{
"ParameterName": "innodb_buffer_pool_size",
"ParameterValue": "{DBInstanceClassMemory*3/4}",
"Description": "The size in bytes of the memory buffer innodb uses to cache data and indexes of its tables",
"Source": "system",
"ApplyType": "static",
"DataType": "integer",
"AllowedValues": "335544320-9223372036854775807",
"IsModifiable": true
},
I think that the UI should provide all the options the API provides, especially attributes such as parameter group and option group which are already present on the UI when creating a standalone RDS instance.
And my innodb_buffer_pool_size parameter is already based on the formula you've posted, it's the session memory buffers which I believe are causing the issue.
Nevertheless, I have other parameters which I use to prevent replication sync issues as I've mentioned and I need on creation, not post-creation.