So I've got a very large database that will likely consist of hundreds of thousands of files, possibly millions and I need it to be accessible by people thousands of kilometers away from each other.
What I'm thinking is people at different locations will 'checkout' the image and video files into a read only database (so that they can view images quickly) and any changes to the metadata would be writing directly to the main database (and local) to avoid any future conflicts with other users.
Essentially, the user should read from 1 database (which is local so its fast) and write to both the local and main database (which could be thousands of kms away, so very slow to read from directly).
Would this sort of thing be possible? if so how could it be achieved?