Amazon Redshift: a new data warehouse to the petabytes

Amazon rolled out a fundamentally new service Redshift for database storage size from several hundred gigabytes to many petabytes. The product is aimed at corporate customers, which constrains the limit of 1 terabyte traditional RDS I want to use familiar SQL applications and to ensure immediate availability of data.

The cluster Redshift rises in a few clicks from the administration panel AWS. The cost of data storage here compared to the normal S3 and depends on the type of cluster and data plan. For example, for a three-year plan it is $999 per terabyte per year.

Users Redshift offers two types of servers for cluster: XL and 8XL.

the

High Storage Extra Large (XL) DW Node


the
    the
  • CPU: 2 virtual cores
    • the
  • ECU: 4.4
    • the
  • Memory: 15 GiB
    • the
  • Discs: 3 HDD with 2 TB of local attached storage
    • the
  • Network: medium
    • the
  • Speed I/O disk: medium
    • the
  • API: dw.hs1.xlarge


the

High Storage Eight Extra Large (8XL) DW


the
    the
  • CPU: 16 virtual cores
    • the
  • ECU: 35
    • the
  • Memory: 120 GiB
    • the
  • Discs: 24 HDD with 16 TB of local space
    • the
  • Network: 10 Gigabit Ethernet
    • the
  • Speed I/O disk: very high
    • the
  • API: dw.hs1.8xlarge

Concurrently with the announcement of Amazon Redshift 25% reduced the price of the hosting S3.



On the same day, Google also reduced prices by 20% storing data in Google Cloud Platform, and announced the launch of a new service for the cheapest long term storage archives Durable Reduced Availability Storage, the type of AWS Glacier.

Article based on information from habrahabr.ru

Comments

Post a Comment

Popular posts from this blog

Powershell and Cyrillic in the console (updated)

Image
In the development process is very often necessary to run a powershell script from a console application. What could be easier? the #test.ps1 & $PSScriptRoot\ConsoleApp.exe Examine the behavior of console applications when running them from the command line, using PowerShell and using PowerShell ISE: execution Result In PowerShell ISE, there is a problem with encoding, as the ISE expects the output to the encoding 1251. Use Google and find two problem solving: c use [Console]::OutputEncoding and through the powershell pipeline. Let's use the first solution: test2.ps1 $ErrorActionPreference = "Stop" function RunConsole($scriptBlock) { $encoding = [Console]::OutputEncoding [Console]::OutputEncoding = [System.Text.Encoding]::GetEncoding("cp866") try { &$scriptBlock } finally { [Console]::OutputEncoding = $encoding } } RunConsole { & $PSScriptRoot\ConsoleApp1.exe } execution Result At the command prompt, all is well, bu...
Read more

Active/Passive PostgreSQL Cluster, using Pacemaker, Corosync

Image
Description This article describes an example of configuring Active/Passive PostgreSQL cluster, using Pacemaker, Corosync. As the disk subsystem is considered the drive from the system data storage (CSV). Similar to the Windows Failover Cluster from Microsoft. Technical details: OS Version — CentOS 7.1 Version package pacemaker — 1.1.13-10 Package version pcs — 0.9.143 PostgreSQL — 9.4.6 As servers(2pcs) — iron server 2*12 CPU/ memory 94GB As a CSV(Cluster Shared Volume) — an array of class Mid-Range Hitachi RAID 1+0 Preparation of cluster nodes Rule /etc/hosts on both hosts and make the visibility of hosts to each other by short names, for example: the [root@node1 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 10.1.66.23 node1.local.lan node1 10.1.66.24 node2.local.lan node2 Also make exchange between servers using SSH keys and ...
Read more

Experience with the GPS logger Holux M-241. Working from under Windows, Mac OS X, Linux

Image
Inspired by the recent article on the GPS logger. I would like to tell you about GPS logger (GPS Receiver / Data Logger) Holux M-241, its features, capabilities and usability. May be someone this review will seem useful in the selection of such devices. The logger I needed to create tracks velopokatushki, forest walks skiing and snapping photos to coordinates. Bought this device at Dealextreme back in 2011 for about the same price for which he sold there now, something around 70$. There are of course the device is newer and cheaper, but for some features they lose this logger. (Photos of the device borrowed from Dealextreme) photos When choosing a logger, watching the small avaricious reviews of devices and spent a lot of time to form a view about the necessary for me features. In the end, I came to the following requirements: 1. Power supply — always removable, preferably standard batteries AA or AAA. After all, if you have to foray outside of civiliz...
Read more