I've been a DBA 20+ years; been writing SQL for almost 20, now.

I don't care. Yeah, you need a naming convention. It should be simple and consistent and mostly, IMO,...

I've done something similar using replication. Segment ID spaces and replicate across servers. If one server goes down, the load balancer picks up and repoints at another (virtually identical, except...