When to switch to a bigger RDS instance

In this Blog, we explain when to switch to a bigger RDS instance or upgrade RDS Instance type in AWS, You need to know what differences therein configuration between my.cnf and RDS DB-Parameter. When to switch to a bigger RDS instance

All default MySQL settings that would normally be written in my.cnf. All values are the same in RDS with the exception of two which are mention below:
·         max_connections
·         innodb_buffer_pool_size
Amazon set the following values based on server model:
If your CPU is averaging > 70% or so, you might want to start planning on an upgrade.
Before Upgrading your Box, ensure checkpoints:
|-> Ensure how much DB connection min required by your application
|-> Ensure NO Slow Query running more than 10sec
|-> Ensure is any scripts making more DB connection with query for select / update / alter etc…
|-> Is there any network latency between DB and application?

Related Articles

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.


Adblock Detected

Please consider supporting us by disabling your ad blocker
%d bloggers like this: