How does horizontal scaling differ from vertical scaling in cloud databases

Question

I'm confused about when to use horizontal vs. vertical scaling for databases in the cloud. I get that vertical scaling means adding more resources to a single instance, and horizontal means adding more instances, but I’m not clear on the impact on performance and cost in real-world use. When is one approach better than the other?