Will Redshift Endpoint Change When Vertical Scaling Cluster?

Question

I have a Redshift cluster currently configured with two ra3.xlplus nodes. I am going to vertical upscale the cluster from two ra3.xlplus nodes to three ra3.xlplus nodes. A planning assumption is that the endpoint will not change. However, due diligence is required and I am seeking input from the community.

I do not believe the endpoint will change as a result of the vertical scaling operation to add a node of the same type. Is this a correct planning assumption?

**Update:** I ran the aws redshift describe-node-configuration-options --cluster-identifier  --action-type resize-cluster command that is listed on more than one Redshift cluster resize page. An example of such a page is [here](https://repost.aws/knowledge-center/resize-redshift-cluster).  Returned was a configuration option for four (4) nodes rather than three (3) nodes. So, my reference in original should reference four (4) nodes. This is not material to the original question. Am sharing to help other members of the Community who might choose to reply or use the question and replies for their own situation.

Accepted Answer

The endpoint will be the same after scale horizontal or vertical.

https://aws.amazon.com/blogs/big-data/scale-your-amazon-redshift-clusters-up-and-down-in-minutes-to-get-the-performance-you-need-when-you-need-it/

When you perform vertical scaling on an Amazon Redshift cluster, the endpoint does not change. Vertical scaling in Redshift typically involves changing the node type to a more powerful one, or vice versa, to adjust the performance and capacity of the cluster. Here's a brief overview:

The endpoint of an Amazon Redshift cluster, which includes the URL and port through which you connect to your database, remains the same before and after the scaling operation. This stability is crucial because it ensures that applications and services that depend on the database don't need to be reconfigured with a new endpoint after scaling.

Will Redshift Endpoint Change When Vertical Scaling Cluster?

관련 콘텐츠