Change cluster parameter group

0

Hi,
I need to change my cluster parameter group in order to create workload queues.
Will I have any downtime doing this operation?

Thank you for your help.

질문됨 4년 전1860회 조회
3개 답변
0
수락된 답변

Dear Customer,

You can apply dynamic properties to the database without a cluster reboot, but static properties require a cluster reboot for changes to take effect. However, if you change dynamic and static properties at the same time, then you must reboot the cluster for all the property changes to take effect. This is true whether the changed properties are dynamic or static.

While dynamic properties are being applied, your cluster status is modifying. Switching between automatic WLM and manual WLM is a static change and requires a cluster reboot to take effect.

You can refer to below documentation [1] stating which parameters are dynamic and which are static in nature based on the WLM(auto/manual) type.

[1] Configuring Workload Management - Properties for the wlm_json_configuration Parameter - https://docs.aws.amazon.com/redshift/latest/mgmt/workload-mgmt-config.html#wlm-json-config-properties

When using manual WLM, if the timeout value is changed, the new value is applied to any query that begins running after the value is changed. If the concurrency or percent of memory to use are changed, Amazon Redshift changes to the new configuration dynamically. Thus, currently running queries aren't affected by the change. For more information, see [2]

[2] WLM Dynamic Memory Allocation - https://docs.aws.amazon.com/redshift/latest/dg/cm-c-wlm-dynamic-memory-allocation.html

Regards,
KK

Edited by: KalyanN-aws on Jan 29, 2020 8:12 PM

답변함 4년 전
0

Most modifications to an existing parameter group are applied dynamically and do not require a reboot

Parameter group changes that require a reboot: switching to a different parameter group, adding or removing queues.

Redshift reboots typically complete quickly.

답변함 4년 전
0

I might add to what Joe said to further help you expectation of what will occur is that your open read-only sessions will get parked and the current active query restarted after the reboot. However, your ope writer sessions will get severed and the SQL clients will need to reconnect to establish a new session.

Regards,
-Kurt

klarson
답변함 4년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠