It's highly unlikely your problems are associated with the increase in storage size. That you increased max_connections is more of a hint to me as it suggests you are driving the t2.micro harder and perhaps beyond what its limited memory can support. Also remember you have the CPU burst balance to deal with. All database systems are subject to some level of instability if you push them too far beyond the resource limits, and I believe MySQL is one of the worst offenders. You might want to do some performance analysis to see what is going on.
On the connectivity front it sounds like the application does not properly handle connections dying. It should be getting an error and re-connecting.
Thanks a lot! This clarified a couple things for sure. It was helpful.
We had reset max_connections parameter value to its default value soon after we posted the question. Therefore, yesterday was a better day, once again. There was a very brief period when our app maxed on DB connections, but it recovered immediately. It was such a relief!
The reconnecting logic could be tricky when the system is already saturated. We will figure this out.
This is just to inform that the RDS instance has been stable as it used to be in the past. All that we did was to reset max_connections parameter. Little did I know it would cause such stress, panic and havoc.
Does Recovery of DB instance run automatically?Accepted Answerasked 3 months ago
[RDS, Aurora MySQL] Frequent "Recovery of the DB instance has started. Recovery time will vary with the amount of data to be recovered."asked 2 months ago
What happens after failover in RDSAccepted Answerasked a month ago
Reason for providing the 'source-dbi-resource-id' parameter in the AWS RDS CLI command 'restore-db-instance-to-point-in-time'?asked 8 months ago
RDS Aurora compute db instance type not availableasked 2 days ago
Modifying an Amazon RDS DB Instance and first-touch penaltiesAccepted Answerasked 3 years ago
DB Instance restarting due to " MySQL induced log backup issues"asked 6 months ago
AWS RDS Storage increasing unexpectedlyasked 2 months ago
Instability in RDS MySQL db after increasing storage spaceasked 3 years ago
How can I retrieve the list of all databases in an RDS DB instance via API?Accepted Answerasked 2 years ago