Amazon Redshift Serverless 中的 AI 驱动扩展 [重复].pdf

1、 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.AI-driven scaling in Amazon Redshift ServerlessRohit VashishthaSr Analytics Specialist Solutions ArchitectAmazon Web ServicesDavide PaganoSoftware Development Manage

2、rAmazon RedshiftAmazon Web ServicesA N T 4 2 0-R 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.The Pain of SizingMeet the HeroDeep DiveAI-driven scaling in Amazon Redshift Serverless 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.The Pain of SizingCase 1:Dash

3、board queries during day,ingestion at nightCase 2:Complex query that needs large capacity,while 90%runs fine on small capacityCase 3:Sudden spike no time to resize 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Amazon Redshift ServerlessJDBC/ODBCData sharing clustersData APICompu

4、teStorageOperational DatabasesQuery Live DataIncremental MVsIntelligent and dynamic compute management Amazon SagemakerRedshift MLRedshift Managed StorageAmazon S3ML-based workload monitoringAutomatic tuningAutomatic scalingAutomatic workload managementPay for usePerformance at scaleAutomatic mainte

5、nanceAmazon Redshift Serverless Architecture 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Datawarehouse Sizing ExerciseReal customer workload:during the day,we have many dashboarding queries,but during the night we run large ingestionsSTEADY STATE PATTERNSAD HOC PATTERNSMEMORY

6、USAGELARGE ETL QUERIESSMALL DASHBOARD QUERIESJUMBO QUERIES0.00.51.01.5 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Amazon Redshift Serverless Scaling TodayBaseBaseCompute 1BaseHorizontal(auto)Vertical(manual)Compute 2Redshift Serverless EndpointRedshift Serverless EndpointReds