Amazon Web Service

Amazon RedShift

Amazon Redshift is petabyte-scale data warehouse managed service. Analyzing your data is simple and cost-effective and it supports existing business intelligence tool. It is the cost-effective solution to store hundred of gigabytes to petabytes of datasets.


A collection of computing resources called node makes an Amazon Redshift data warehouse. These nodes are organized into the cluster and can contain one or more databases. Amazon Redshift engine is run all clusters.


Amazon Redshift manages all work related to setup, configuration, scaling, provisioning, backup and patching Amazon Redshift engine.


When you start Amazon Redshift cluster it creates one database. All the data resides in the database created when a cluster is provisioned. You can run queries on your data. You can create another database whenever you need. While provisioning a cluster you specify a master user that has access to all the databases that are available within the cluster. This master user acts like superuser and later you can create additional superuser and user.


The behavior of the databases such as date style within the cluster is defined by parameter groups. Default parameter will be used if you don't specify a parameter group.


Cluster management includes scaling up and scaling down your cluster whenever it is needed. For taking backups of your cluster you can take snapshots of your cluster. Point in time backups is called snapshots. Amazon Redshift provides automated and manual backups.


Security

By default AWS account holder is able to access to the cluster. You can create another user using Identity and Access Management. You can attach a policy to the user for accessing to the cluster.


Security groups is another to manage access to the clusters. You can specify a range of IP address for Inbound access to the cluster.


You can opt for encryption while creating your cluster. If you choose to encrypt data Amazon Redshift encrypts all data and then store in user tables.


You can also encrypt the connection between SQL client and cluster by using SSL encryption.


Next

Must Read Article

How To Launch EC2 Machine

How To Launch EC2 Machine

In this article we are going to learn how to launch a EC2 instance. For this you need to have AWS account.

How to install WordPress on ec2 machine

How to install WordPress on ec2 machine

Before you start installing WordPress on ec2 machine. You must log in into the machine.

How to create a VM instance in Azure

How to create a VM instance in Azure

In this Tutorial we are going to launch a Virtual Machine in azure.

How to install WordPress on VM instance in Azure

How to install WordPress on VM instance in Azure

Before you start installing WordPress on VM instance on Azure. You must log in into the machine. You can launch a VM Instance in Azure using this tutorial. After launch of machine log in into the machine using SSH. If you do not know how to SSH in VM instance you can follow this tutorial.

How to launch a VM instances in Google Cloud

How to launch a VM instances in Google Cloud

In this tutorial we are going to launch a Compute Egine instance.

How to install wordpress in VM instances in Google Cloud

How to install WordPress on VM instance in Google Cloud

Before you start installing WordPress on VM instance on Google Cloud. You must log in into the machine. You can launch a VM Instance on Google Cloud using this tutorial. After launch of machine log in into the machine using SSH. If you do not know how to SSH in VM instance you can follow this tutorial.