HA on rds uses synchronous replication - you won’t lose data on automated failover under any normal circumstances.