So things just going to be easier to maintain and better optimized that we don't need to scale the service in the future to use load balancers?

Or things will be optimized but we might also reach a point where 32 cores aren't enough and we'll be needed 2 or 3 database servers which we should use MySQL for ot postgres so we can make it a cluster?