Questions about DBDOWNLOAD

[NLMR]

Hi,

Could anyone give me more information about what's going on behind the scenes when using the server/mirrorsync/dbdownload/UID functionality?

Is the target databased directly downloaded or is a copy created on the server first. If a copy is created, where is this filed (temporarily?) stored and is there a way to change this location?
Is there a way to make that copy structure only as opposed to structure + data?

Might have follow up questions. Many thanks in advance for any information or links to relevant resources.

Nils

[Jesse Barnum]

When the MirrorSync process receives a download request, it:

* Pauses the database

* Duplicates it into the OS temp directory. If you selected the empty clone option when creating the MirrorSync download URL, then an empty structure-only clone is also created. There is not a way to change the location currently, if you need that we can get you a quote for customizing that.

* Resumes the database

* Sends the duplicate to the client with gzip compression

* Deletes the duplicate (on Windows. With Mac, we don't have permission to delete the duplicates because we are not running as the same user as FMS).

[NLMR]

Very useful information, Jesse. Thanks!

I'm not the one who set the process up. Is the empty clone option creating a structure-only clone of the database as well as a full copy or is it one or the other?

Cheers.

Edited May 9, 2018 by NLMR

[Jesse Barnum]

For empty clones, a full copy of the database is created as well as an empty clone. We wish it didn't work this way, but that's a limitation of how the fmsadmin command line tool works.

[NLMR]

Great stuff Jesse, thanks again.

We just ran a test with 7 concurrent requests and it worked ok but it seems the last copy stays in the temp directory for some reason...

[Jesse Barnum]

Mac or Windows server?

[NLMR]

Windows

[Jesse Barnum]

OK, I haven't seen that happen in Windows before. If it seems to be a reproducible issue, contact [email protected] and we'll get your log files to see why that's happening.

[NLMR]

The log file in MirrorSync\Applications\logs is quite detailed but I'm not  really sure what to look for...

Ok, will direct further questions to the support. Thanks again and enjoy your day!

[NLMR]

Seems it was deleted eventually. All good!