Hardware Load Balancing Possibilities

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
popezilla
Posts: 57
Joined: Tue Jul 13, 2004 1:17 pm
Location: MD
Contact:

Hardware Load Balancing Possibilities

Post by popezilla » Thu Jul 05, 2007 2:49 pm

We're planning on deploying Vault 4.0 to two separate web servers that use a hardware load balancer for redundancy. Both web servers will reference the same database on the same SQL server. I’m curious if there are any known or expected issues when Vault is configured in this way. Even though our load balancer uses the ‘sticky’ approach, I wanted to double check with support before proceeding.

Thanks.

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Thu Jul 05, 2007 7:58 pm

I’m curious if there are any known or expected issues when Vault is configured in this way.
Yes, this can corrupt your database, as there is no transaction regulation if two Vault Web servers are updating the same repositories.

The however it is possible to configure each Vault server to
communicate only with specific repositories. This means server #1 updates repositories one and two, and server #2 will update repositories three and four.

E-mail support at sourcegear.com Attn: Linda, and I'll send you the details.
Linda Bauer
SourceGear
Technical Support Manager

popezilla
Posts: 57
Joined: Tue Jul 13, 2004 1:17 pm
Location: MD
Contact:

Post by popezilla » Fri Jul 06, 2007 6:54 am

Ouch.

Thanks for the information.

Locked