Magento Business Intelligence Help Center

Creating and launching a cluster




In this section, you’ll set up the cluster, configure the nodes, and launch. If you’d like to use Amazon’s Getting Started guide for reference, this link will take you to the corresponding page for this section.

What are nodes?

A node is a single computer that participates in a cluster. Your Redshift cluster can have from one to many nodes; the more nodes, the more data it can store and the faster it can process queries. Amazon currently offers four different types of nodes, each of which has its own CPU, RAM, storage capacity, and storage drive type. In addition, each node also has its own pricing plan.

The type and number of node(s) you choose when creating your cluster is dependent on your needs and dataset. We do, however, recommend you set up a multi-node configuration to provide data redundancy. For some guidance on choosing the number of nodes, click here to read the ‘Determining the Number of Nodes’ section of the Amazon Redshift guide.


Magento PDW is now compatible with clusters based in any AWS region!

Lets get started. Make sure you're on the Redshift Dashboard page before you begin.

What's this about ports? Ports are user-defined openings in firewalls that allow in and outbound traffic. Amazon Redshift uses port 5439 by default, which will work for most users.
  1. On the Redshift Dashboard, click the Launch Cluster button. This will launch the Cluster Details page, where you’ll name the cluster, set the port, and create login credentials. Click Continue when finished to move onto configuring nodes.
  2. On the Node Configuration page, you’ll select the node and cluster type. For information about node type and the number of nodes required, refer to the ‘What are nodes?’ section at the top of this page. Click Continue when finished to move onto setting the final configuration options.
  3. The Additional Configuration page allows you to define a parameter group and encryption settings, set your networking options, and associate a security group with your cluster. For the purposes of this tutorial, we’ll leave most of the default settings as-is.

    We'll be focusing on the Configure Networking Options and Security Options sections. 
  4. First, look at the Choose a VPC option. For the purposes of this tutorial, set this to the Default VPC. For more information about creating your own VPC, refer to Amazon’s Getting Started with VPC guide.

    When you select a VPC, the rest of the settings we need to define (don't worry, they're listed below the image) will display. The page should now look like this:

  5. Define the remaining settings:
    1. Cluster Subnet Group - By default, all new AWS accounts are created with a default public subnet - set this to the default subnet.

      This must be a public subnet for Magento BI to connect to your Redshift instance.
    2. Publicly Accessible - This must be set to Yes for Magento BI to access your instance.
    3. VPC Security Groups - In this field, select the Default security group. We’ll edit the access rules for this group in the Authorizing Cluster Access section of this tutorial.
  6. When finished, click the Continue button.

That's it! Note that cluster creation can take a few minutes - the status will change to ‘available’ when the process completes.

The next step to setting up your Redshift cluster is configuring the authorization settings.

Was this article helpful?
0 out of 0 found this helpful


Powered by Zendesk