Reccommended Vault multi-site configuration

[tmccar]

I am looking for advice and recommendations for a roll-out of Autocad 2012 and Inventor 2012 with Vault Pro to 5 sites. The first site will have the master database of drawings and master library, but all 5 will need access to this data continually.

      Is there a recommended/recognized architecture for this configuration?

      And do we need multiple SQL servers or just one?

  One condition that we must meet is that the master data will be stored on a server in a data center (apart from the 5 sites), but will need to be replicated to each site daily.

[paul.gunn]

Hi,

The answer to this largely depends on the latency between the various sites.

If latency is high, then a connected workgroups topology may be advised. This is where you have multiple SQL servers using SQL replication between them. This mitigates latency issues but has a few downsides (1) requires full sql [sql express doesn't support replication] (2) More complex to set up and administer (3) End users need to be aware of workgroup ownership [only one workgroup owns [can edit] a given object at a time]

If latency is low [critical for good performance here], it is possible for multiple adms servers [sites] to connect to one SQL server. A hybrid approach is also possible - multiple sites connecting to a couple of different workgroups [sql servers]

Paul

[tmccar · Accepted solution]

Thanks Paul for that useful info. And do you have any useful way to check the latency, or any benchmark test I could run? I have already scheduled a test using an Inventor assembly, but I feel it's not going to put much of a demand on the links. (It's 42mb zipped)

Tom

[paul.gunn]

Hi Tim,

You can get a rough idea of latency [in milliseconds] by pinging the remote machine. i.e. the ping command from the windows cmd.

Paul