揭秘 Aurora DSQL 事务和并发控制.pdf

《揭秘 Aurora DSQL 事务和并发控制.pdf》由会员分享，可在线阅读，更多相关《揭秘 Aurora DSQL 事务和并发控制.pdf（50页珍藏版）》请在三个皮匠报告上搜索。

1、 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.D A T 4 5 2Demystifying Aurora DSQL transactions and concurrency controlAditya SamantPr.Database Specialist Solutions ArchitectSimon KomenderaPr.Database Specialist

2、Solutions Architect 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.AgendaScaling challengesDSQL architectureConcurrency in relational databasesDistributed optimistic concurrencyQ&A(Anytime!)2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Application scalingScal

3、ingchallengesExisting apps reach scaling limits(throughput/data)AvailabilityContinuous availability:zonal,regional,globalGlobal scaleGlobal presence without giving up on performance consistency,strong readsRead/write anywhereApplications should enjoy equal database experience no matter the location

4、2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Aurora DSQL architecture 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.FRONTENDQUERYPROCESSORADJUDICATORJOURNALCROSSBARSTORAGEAurora DSQL architecture 2025,Amazon Web Services,Inc.or its affiliates.All rights res

5、erved.FRONTENDQUERYPROCESSORADJUDICATORJOURNALCROSSBARSTORAGEAurora DSQL architecture 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Aurora QP and Adjudicatoridbrandquantitytaste1Harvest Hound952Artisan Canine 59Foodidfood_idquantitytime1112025-12-03T 12:00ZMealSELECT id,brand,ta

6、ste FROM foodWHERE id in(1,2)UPDATE food SET quantity=quantity-5 WHERE id=2INSERT INTO meals(food id,quantity,time)VALUES(3,5,now()2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.START TRANSACTIONSELECT id,brand,taste FROM foodWHERE id in(1,2)FRONTENDSTORAGESTORAGESTORAGE 2025,Ama