In this post, we will discuss what to do when you add more memory
to your instance. Adding memory to a server where MySQL is
running is common practice when scaling resources.
First, Some Context
Scaling resources is just adding more resources to your
environment, and this can be split in two main ways: vertical
scaling and horizontal scaling.
Vertical scaling is increasing hardware capacity for a given
instance, thus having a more powerful server, while horizontal
scaling is adding more servers, a pretty standard approach for
load balancing and sharding.
As traffic grows, working datasets are getting bigger, and thus
we start to suffer because the data that doesn’t fit into memory
has to be retrieved from disk. This is a costly operation, even
with modern NVME drives, so at some point, we will need to deal
with either of the scaling solutions we mentioned.
In this case, we will discuss adding more …
[Read more]