5 ms·
No mention of connection pooling? Does Aurora handle 1000s of concurrent connection considering it is cloud-native?
by tirumaraiselvan 8y ago
No mention of connection pooling? Does Aurora handle 1000s of concurrent connection considering it is cloud-native?
- kondro 8y agoAurora is still ultimately a standard cluster of MySQL (or other) instances on the front end — it's just the storage engine that's significantly different. From the docs, the largest instance size defaults to the recommend maximum of 6,000 connections (16k maximum) per server (and only one write-based sever and 15 read replicas) https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...
- wgjordan 8y agoYes, Aurora has connection pooling that allows it to scale to thousands of concurrent connections: > Amazon Aurora for MySQL comes with internal server connection pooling and thread multiplexing, which helps reduce contention and improve scalability when dealing with thousands of concurrent connections. You can configure each Aurora DB instance to allow up to 16,000 concurrent connections. https://aws.amazon.com/blogs/database/planning-and-optimizing-amazon-aurora-with-mysql-compatibility-for-consolidated-workloads/ https://aws.amazon.com/blogs/database/planning-and-optimizin...
- etaioinshrdlu 8y agoI had an issue where Aurora MySQL would refuse connections above 1000 even though Max Connections was configured several times higher. Most of the connections were idle too. Any pooling they are doing is not very effective. The product is pretty disappointing.