Score:0

MySQL Server Scaleing with AWS issues

mx flag
Tom

MySql server doesn't seem to be scale up correctly when scaling up my AWS instance. Its almost like MySql is cacheing the instance sizes.

This happens after a scale down the AWS instance and then when we scale back up the the AWS instance, the MySQL server seems to remain in the smaller state even though the AWS instance has doubled in RAM and CPU

Any suggestions?

jp flag
Why do you expect MySQL to scale up with the instance size?
Tom avatar
mx flag
Tom
Yes, thats how I expected it to work, or get some advice on how I can achieve the MySQL to scale up automatically. or the setting I need to change manually, post scale up if its not possible automatically thanks T
Wilson Hauck avatar
jp flag
@Tom Additional information request, please. AWS instance type? Any SSD or NVME devices on MySQL Host server? Post on pastebin.com and share the links. From your SSH login root, Text results of: A) SELECT COUNT(*) FROM information_schema.tables; B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; for server workload tuning analysis to provide suggestions. Welcome to serverfault.
ua flag
How much RAM in each case?
Score:1
jp flag

MySQL doesn't adjust its settings according to the resources available on the server. For example, by default, it allocates a mere 128 MB for its InnoDB pool. It is expected that you read MySQL documentation and adjust settings according to your needs.

Alternatively, instead of running MySQL on EC2 you can run a managed AWS RDS MySQL instance, they have some settings already adjusted to the instance size.

Tom avatar
mx flag
Tom
Hi @AlexD We are using a managed AWS RDS MySQL instance, yet when we scale done and back up the MySQL seems to remain in the smaller size. What settings would you recommend looking at so this MySQL scales up correctly?
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.