Database sync - multiple locations however for the same DB?

Hi, I had webDAV setup at one point, however moving houses caused it to fail. Subsequently found out it was due to Carrier-Grade NAT.

I have separate databases and separate locations for each. Primarily due to the total size of each database being up to 50GB.

For a single database (ie. Finance). I have the following

  • https://[local IP address]:[port]/webDAV/
  • https://[DDNS Name]:[port]/webDAV/
  • Bonjour to another Mac within same network.

the Local IP link - was the original.

  • added Bonjour location - and Activity manager showed upload to database location (ie. sync)
  • added DDNS location - and currently showing another upload to database location

Does this mean that the single Finance database is effectively being loaded 3x times?
Are there any issues with having multiple locations for the same database?
Not too sure what additional overhead it will create as from the above behaviour?

TIA

Changes have to be uploaded to all 3 locations of course and the synchronization runs more often. But remote file contents are only downloaded if remote copies newer than the local copies are available, therefore the metadata overhead while pulling changes is also 3 times higher but file contents are only downloaded once.

yes… i noted that behaviour.
I would think MAC1 - having the same webDAV db, it will only upload 1x times. For the 2nd location even though pointing to the same webDAV db, the file timestamp would be verified and thus not loaded.

It did however took a long time to sync ~60k of records. Almost the same time as the initial sync. [this is just my guess/ observation.

i’ll remove the local IP address and keep the DDNS location as they both serve the same purpose.

However can i ask here, is there any value then to have bonjour locations?
I am looking for quicker sync where the local wireless is used to sync where DDNS location is not possible due to firewalls or internet down.

i drew this out as not to be confused.

In your initial post it wasn’t clear whether the WebDAV locations are identical. But in that case each sync location just checks the WebDAV sync store but if the other sync location already uploaded/downloaded the necessary changes, then no more additional processing is required.

A Bonjour sync on its own is faster (and synchronous), meaning that the changes are synchronized a little earlier compared to WebDAV. But as all locations have to be updated and only one location can synchronize a database at the same time, multiple locations don’t speed up anything in the end.

1 Like