Databases on aws part 2

Databases on aws part 2

• 1.
  Intro
• 2.
  Amazon Redshift 2 ▪ AmazonRedshift is a powerful, fully managed cloud data warehouse service. ▪ Redshift Spectrum extends the power of Redshift to query unstructured data in S3 – without loading your data into Redshift. ▪ With a few clicks in the AWS Management Console, you can launch a Redshift cluster and get started analyzing your data.
• 3.
  Amazon Redshift 3 ▪ TheAmazon Redshift service manages all of the work of setting up, operating, and scaling a data warehouse. ▪ These tasks include provisioning capacity, monitoring and backing up the cluster, and applying patches and upgrades to the Amazon Redshift engine. ▪ Amazon Redshift creates one database when you provision a cluster.This is the database you use to load data and run queries on your data. ▪ You can create additional databases as needed by running a SQL command
• 4.
  Amazon Elastic Cache 4 ▪ElastiCache is a web service that makes it easy to set up, manage, and scale a distributed in-memory data store or cache environment in the cloud. ▪ It provides a high-performance, scalable, and cost-effective caching solution, while removing the complexity associated with deploying and managing a distributed cache environment. ▪ Amazon ElastiCache supports the Memcached and Redis cache engines. Each engine provides some advantages. Important After you create a cache cluster or replication group, you can upgrade to a newer engine version, but you cannot downgrade to an older engine version. If you want to use an older engine version, you must delete the existing cache cluster or replication group and create it again with the earlier engine version.
• 5.
  Amazon Elastic Cache 5 Memcached Redis Sub-millisecondlatency Yes Yes Developer ease of use Yes Yes Data partitioning Yes Yes Support for a broad set of programming languages Yes Yes Advanced data structures - Yes Multithreaded architecture Yes - Snapshots - Yes Replication - Yes Transactions - Yes Pub/Sub - Yes Lua scripting - Yes Geospatial support - Yes
• 6.
  Amazon Aurora 6 – AmazonAurora:the relational database reinvented for the cloud ▪ Up to five times better performance than MySQL ▪ At a price point 1/10 of a commercial database ▪ Designed for drop-in compatibility with MySQL 5.6 – Pay only for the storage you use – Runs inAmazonVPC; offers encryption at rest and in transit – Amazon RDS handles administrative tasks for Aurora – AmazonAurora: high availability by default ▪ Your data is replicated 6 ways across 3 AZs ▪ Storage grows up to 64TB seamlessly ▪ Up to 15 Aurora Replicas with instant crash recovery
• 7.
  Amazon Aurora 7 ▪ Whenyou create an AmazonAurora instance, you create a DB cluster. A DB cluster consists of one or more DB instances, and a cluster volume that manages the data for those instances. ▪ An Aurora cluster volume is a virtual database storage volume that spans multiple Availability Zones, with each Availability Zone having a copy of the DB cluster data.Two types of DB instances make up an Aurora DB cluster: – Primary instance – Supports read and write operations, and performs all of the data modifications to the cluster volume. EachAurora DB cluster has one primary instance. – Aurora Replica – Supports only read operations. EachAurora DB cluster can have up to 15 Aurora Replicas in addition to the primary instance. MultipleAurora Replicas distribute the read workload, and by locating Aurora Replicas in separate Availability Zones you can also increase database availability.
• 8.
  Amazon Aurora 8 The followingdiagram illustrates the relationship between the cluster volume, the primary instance, andAurora Replicas in anAurora DB cluster.
• 9.
  Amazon Databases Summary 9 Ifyou need Consider Using Product Type A fully managed MySQL and PostgreSQL-compatible relational database with the performance and availability of enterprise databases at 1/10th the cost. AmazonAurora Relational Database A managed relational database in the cloud that you can launch in minutes with just a few clicks. Amazon RDS Relational Database A serverless, NoSQL database that delivers consistent single-digit millisecond latency at any scale. Amazon DynamoDB NoSQL Database A fast, fully managed, petabyte-scale data warehouse at 1/10th the cost of traditional solutions. Amazon Redshift Data Warehouse To deploy, operate, and scale an in-memory data store based on Memcached or Redis in the cloud. Amazon ElastiCache In-Memory Data Store A fast, reliable, fully managed graph database to store and manage highly connected data sets. Amazon Neptune Graph Database Help migrating your databases to AWS easily and inexpensively with minimal downtime. AWS Database Migration Service Database Migration