rights reserved. S U M M I T Construyendo aplicaciones intensivas en datos Julio Faerman AWS Technical Evangelist @faermanj https://speakerdeck.com/faermanj
rights reserved. S U M M I T Que son apicaciones “intensivas en datos” Usuarios: 1M+ Volumen: TB–PB–EB Localidade: Global Rendimiento: Milliseconds Ingestion: K-M RPS Accesso: Mobile, IoT, devices Escala: Up-out-in Económica: Pay-as-you-go SLA: Managed Social media Ride hailing Media streaming Dating
rights reserved. S U M M I T Modelos de datos híbridos Relational Referential integrity, ACID transactions, schema- on-write Lift and shift, ERP, CRM, finance Key-value High throughput, low- latency reads and writes, endless scale Real-time bidding, shopping cart, social, product catalog, customer preferences Document Store documents and quickly access querying on any attribute Content management, personalization, mobile In-memory Query by key with microsecond latency Leaderboards, real-time analytics, caching Graph Quickly and easily create and navigate relationships between data Fraud detection, social networking, recommendation engine Time-series Collect, store, and process data sequenced by time IoT applications, event tracking Ledger Complete, immutable, and verifiable history of all changes to application data Systems of record, supply chain, health care, registrations, financial
rights reserved. S U M M I T Bases de datos de propósito específico Relational Key-value Document In-memory Graph Time-series Ledger DynamoDB Neptune Amazon RDS Aurora Commercial Community Timestream Quantum ElastiCache DocumentDB
rights reserved. S U M M I T Amazon Aurora § Base de datos relacional construida para la nube § Compatible con MySQL o PostgreSQL § Rendimiento y disponibilidad de bases de datos enterprise a 1/10 del costo Availability and durability Fault-tolerant, self-healing storage; six copies of data across three AZs; continuous backup to S3 Fully managed Managed by RDS: no hardware provisioning, software patching, setup, configuration, or backups Highly secure Network isolation, encryption at rest/transit Performance and scalability 5x throughput of standard MySQL and 3x of standard PostgreSQL; scale-out up to 15 read replicas
rights reserved. S U M M I T Arquitectura Distribuida Master Replica Replica Replica Master Shared storage volume Replica Replica SQL Transactions Caching SQL Transactions Caching SQL Transactions Caching AZ1 AZ2 AZ3 ü Voting free protocol ü Write performance ü Read scale out ü AZ + 1 failure tolerance ü Instant database redo recovery 4/6 Write Quorum & Local tracking The log is the database
rights reserved. Write and read throughput Aurora MySQL is 5x faster than MySQL 0 50,000 100,000 150,000 200,000 250,000 MySQL 5.6 MySQL 5.7 MySQL 8.0 Aurora 5.6 Aurora 5.7 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 MySQL 5.6 MySQL 5.7 MySQL 8.0 Aurora 5.6 Aurora 5.7 Write Throughput Read Throughput Using Sysbench with 250 tables and 200,000 rows per table on R4.16XL
rights reserved. Variabilidad de rendimiento bajo carga Amazon Aurora >200x mas consistente SysBench OLTP (write-only) workload with 250 tables and 200,000 rows per table on R4.16XL 0 2 4 6 8 10 12 0 100 200 300 400 500 600 Time in seconds Write Response Time (seconds) Amazon Aurora MySQL 5.6 on EBS
en el tiempo sin requerir restauración de backup: § Recuperacion de operaciones no intencionales § No destructive § Ejecutar varias veces para encontrar el punto correcto en el tiempo t0 t1 t2 t0 t1 t2 t3 t4 t3 t4 Rewind to t1 Rewind to t3 Invisible Invisible
rights reserved. Perspectivas de rendimiento Dashboard showing database load § Easy – e.g. drag and drop § Powerful – drill down using zoom in Identifies source of bottlenecks § Sort by top SQL § Slice by host, user, wait events Adjustable time frame § Hour, day, week , month § Up to 2 years of data; 7 days free Max vCPU CPU bottleneck SQL w/ high CPU
rights reserved. Aurora Serverless Responde a tu carga de aplicación automáticamente Escala la capacidad en <10 segundos. Nueva instancia tiene buffer pool “cálido” Proxy multi-tenant de alta disponibilidad
rights reserved. Web Service Data API Accede a tu base de datos desde aplicaciones HTTP Sentencias SQL empaquetadas como peticiones HTTP Agrupación de conexiones gestionada detrás de proxy Web Service Data API Aurora Serverless
rights reserved. S U M M I T SQL vs NoSQL Optimized for storage Optimized for compute Normalized/relational Denormalized/hierarchical Ad hoc queries Instantiated views Scale vertically Scale horizontally Good for OLAP Built for OLTP at scale SQL NoSQL
rights reserved. S U M M I T Bases de datos en amazon.com The world’s largest e-commerce business, Amazon.com, runs on nonrelational cloud databases because of their scale, performance, and maintenance benefits. — Werner Vogels CTO, Amazon
rights reserved. S U M M I T Bases de datos en amazon.com The world’s largest e-commerce business, Amazon.com, runs on nonrelational cloud databases because of their scale, performance, and maintenance benefits. — Werner Vogels CTO, Amazon
rights reserved. S U M M I T RETO Escalar y administrar hasta 8 veces más usuarios durante las horas de pico. SOLUCIÓN DynamoDB almacena las coordenadas GPS de todos los viajes, ahorrando en infraestructura y permitiendo el crecimiento de la plataforma para las 23M personas que usan Lyft en todo el mundo. Lyft >1M paseos / dia, 8x tráfico en pico
rights reserved. S U M M I T Amazon DynamoDB Servicio de base de datos rápido y flexible para cualquier escala Comprehensive security Encrypts all data by default and fully integrates with AWS Identity and Access Management for robust security Performance at scale Consistent, single-digit millisecond response times at any scale; build applications with virtually unlimited throughput Global database for global users and apps Build global applications with fast access to local data by easily replicating tables across multiple AWS Regions Serverless No hardware provisioning, software patching, or upgrades; scales up or down automatically; continuously backs up your data
rights reserved. S U M M I T DynamoDB transactions Simplifique su código ejecutando múltiples acciones atómicas y en múltiplas tablas con una sola llamada a la API Single API Call
rights reserved. S U M M I T Que son apicaciones “intensivas en datos” Usuarios: 1M+ Volumen: GB-TB–PB Localidade: Global Rendimiento: Microseconds Ingestion: M+ RPS Accesso: Mobile, IoT, devices Escala: Up-out-in Económica: Pay-as-you-go SLA: Strict Social media Ride hailing Media streaming Dating
rights reserved. S U M M I T Amazon ElastiCache Totalmente Gestionado Rendimiento Extremo Fácilmente Escalable AWS manages all hardware and software setup, configuration, monitoring In-memory data store and cache for sub-millisecond response times Read scaling with replicas. Write and memory scaling with sharding. Non disruptive scaling
rights reserved. S U M M I T What’s New: Redis & Memcached • Redis Streams • SortedSets now have LIST capabilities (POP and BLOCK) ) • HyperLogLogs has an optimized algorithm • Speed Improvements (Jemalloc additions, etc.) • Active Defragmentation • Added In-line HELP command for redis-cli • Native TLS Integration Redis (ElastiCache) • Mo re at h t t p s://aw s.am az o n .co m /re dis/Wh at s_Ne w _R e dis5 • Automated Slab rebalancing • LRU crawler to background-reclaim memory • Faster hash table lookups with murmur3 algorithm Ø Redis 5.0 Ø Memcached 1.5.10
rights reserved. S U M M I T Visión general de Redis Fast <1ms latency for most commands Open source (5.0.4) Easy to learn Highly available Replication Atomic operations Supports transactions In-memory Powerful ~200 commands, Lua scripting, Geospatial, Pub/Sub Various data structures Strings, lists, hashes, sets, sorted sets, bitmaps, streams, and HyperLogLogs Backup/Restore Enables snapshotting
rights reserved. S U M M I T Mejores Prácticas de Clustering In-Memory Storage • Reserva de memoria: + 25% (Redis) + Change buffer (optional 10%) • Automatiza el desalojo con eviction policies y TTLs • Escala con alarmas CloudWatch • Usa instancias memory optimized Performance Benchmark operations using Redis Benchmark tool • For more READIOPS — Add replicas • For more WRITEIOPS — Add shards (scale out) • For more network IO— Use network optimized instances and scale out • Use pipelining for bulk reads/writes • Consider Big(O) time complexity for data structure commands
software management, fault tolerant, replication across multi-AZs within a Region § DynamoDB API compatible: Seamlessly caches DynamoDB API calls, no application rewrites required § Write-through: DAX handles caching for writes § Flexible: Configure DAX for one table or many § Scalable: Scales-out to any workload with up to 10 read replicas § Manageability: Fully integrated AWS service: Amazon CloudWatch, Tagging for DynamoDB, AWS Console § Security: Amazon VPC, AWS IAM, AWS CloudTrail, AWS Organizations DynamoDB Your Applications DynamoDB Accelerator Table #1 Table #2
rights reserved. S U M M I T GE’s Predix Platform Powered by ElastiCache Redis Using ElastiCache Redis with Open Service Broker, Predix Platform from GE Digital allows developers to easily create Redis clusters with standard, pre-configured parameters, sizing and network security. Developers build container-based stateless applications on AWS and ElastiCache is used to manage session state for these applications. The architecture makes is easy and simple for developers to build applications. Container Runtime VPC Control Plane Data Plane App Server Broker ElastiCache VPC EC2 API GE is the world’s largest digital industrial company. We use [ElastiCache Redis] to make it super easy and simple for developers to use Amazon services. Amazon ElastiCache team implemented the Redis AUTH feature in four regions in two months enabling application level security.” – Amulya Sharma Senior Staff Software Engineer GE Digital “
rights reserved. S U M M I T Expedia’s Real-time Analytics with ElastiCache Expedia is a leader in the $1 trillion travel industry, with an extensive portfolio that includes some of the world’s most trusted travel brands. Expedia’s real-time analytics application collects data for its “test & learn” experiments on Expedia sites. The analytics application processes ~200 million messages daily. With ElastiCache Redis as caching layer, the write throughput on DynamoDB has been set to 3500, down from 35000, reducing the cost by 6x.” – Kuldeep Chowhan Engineering Manager, Expedia “ Kenesis Firehose Real-time streams of lodging mark data EC2 Redshift Aurora S3 Ingest multiple data streams Join/ compare events ElastiCache (Redis) Reference data on-premises Historical queries on up to 2 years of data Staging near real- time data Operational queries of real-time data
rights reserved. S U M M I T Amazon Timestream (Preview) Base de datos de series temporales rápida, escalable y totalmente gestionada 1,000x faster at 1/10th the cost of relational databases Trillions of daily events Analytics optimized for time series data Serverless Collect fast moving time- series data from multiple sources at the rate of millions of inserts per second Capable of processing trillions of events daily; the adaptive query processing engine maintains steady, predictable performance Built-in analytics for interpolation, smoothing, and approximation to identify trends, patterns, and anomalies No servers to manage; time-consuming tasks such as hardware provisioning, software patching, setup, & configuration done for you
rights reserved. S U M M I T Servicios arquitectados para la nube y para aplicaciones intensivas en datos Servicios específicos, optimizados para cada tipo de carga de trabajo Innovar más rápido através de servicios gestionados Nuestro enfoque Migrar aplicaciones y bases de datos existentes a la nube
rights reserved. S U M M I T Referencia rápida Situación Solución Existing application Use your existing engine on RDS • MySQL Amazon Aurora, RDS for MySQL • PostgreSQL Amazon Aurora, RDS for PostgreSQL • MariaDB Amazon Aurora, RDS for MariaDB • Oracle Use SCT to determine complexity Amazon Aurora, RDS for Oracle • SQL Server Use SCT to determine complexity Amazon Aurora, RDS for SQL Server New application • If you can avoid relational features DynamoDB • If you need relational features Amazon Aurora In-memory store/cache • Amazon ElastiCache Time series data • Amazon Timestream Track every application change, crypto verifiable. Have a central trust authority • Amazon Quantum Ledger Database (QLDB) Don’t have a trusted central authority • Amazon Managed Blockchain Data Warehouse & BI • Amazon Redshift, Amazon Redshift Spectrum, and Amazon QuickSight Adhoc analysis of data in S3 • Amazon Athena and Amazon QuickSight Apache Spark, Hadoop, HBase (needle in a haystack type queries) • Amazon EMR Log analytics, operational monitoring, & search • Amazon Elasticsearch Service and Amazon Kinesis
faermanj
lycorp_recruit_jp
trishagee
kazzpapa3
chanyou0311
kakehashi
nikinusu
rrreeeyyy
sudoakiy
oracle4engineer
shonansurvivors
hogelog
ewolff
yeseniaperezcruz
keathley
eileencodes
sstephenson
colly
phodgson
pauljervisheath
vanstee
brianwarren
bluesmoon
jmmastey
soudai
