search

ljvillanueva / pumilio

Pumilio: A Web-Based Management System for Ecological Recordings
12 stars 2 forks source link

Shared pumilio database #26

Open aloboa opened 10 years ago

aloboa commented 10 years ago

I understand the main reason behind using the php infrastructure is using pumilio remotely. Nevertheless, security risks are a concern and here I'm behind a firewall so it would be not easy using my pumilio installation from outside. I wonder if I could have the sounds, images and previewsounds as soft links to directories on the cloud, then have the same pumilio setup in my "rover" computer and be able to work remotely. An alternative would be having the 2 installations synced using dropbox or alike. This would imply duplicating the required disk space, though. Also, I wonder if I also would need to sync the /var/lib/mysql/pumilio folder, and the implications of this.

Ultimately, perhaps the future would be using a local software (not php based) to manage the mysql database and have the data on the cloud.

villanueval commented 10 years ago

Syncing the files, having softlinks to the cloud/NAS/other filesystem, etc, should not affect the system. It is just a matter of managing the permissions and keeping the folder structure.

aloboa commented 10 years ago

But do I need to sync or soft-link the /var/lib/mysql/pumilio folder as well? That folder is owned by mysql:mysql Could that be a problem?

villanueval commented 10 years ago

That falls outside what Pumilio's intended use is. There are many ways of doing this, as long as it is transparent to it, the application won't notice.