what is load balancer?

A load balancer is a networking service or device that distributes incoming traffic across multiple servers or resources. its ensure no single server becomes overwhelmed

What is the purpose of an RDS read replica's promotion feature?

Can an RDS read replica be in a different region?

How do you ensure data consistency between the primary database and read replicas?

What happens to read replicas during an automatic failover?