Syncing openemr database with online storage

rdh61 wrote on Saturday, September 24, 2011:

Hi, I would like to have my openemr database available for various computers in different locations. I thought of syncing with a web storage facility like Ubuntu One. Can this be achieved and how?
Many thanks.

verbus wrote on Saturday, September 24, 2011:

Greetings,

This can be achieved by using what is called Master-Master Replication. See the following web site for a definition -> http://en.wikipedia.org/wiki/Multi-master_replication

We have OpenEMR set up on two servers connected with Master-Master Replication at the following two URLs:
http://server1.emrtsolutions.com/openemr/
http://server2.emrtsolutions.com/openemr/

User/pass : admin/admin

As you will see a change made to one is a change made to both.

Contact me offline if you need more info.

verbus@gmail.com

rpl121 wrote on Monday, September 26, 2011:

Another approach to this problem is to use a single database and connect remotely through a secure shell.  (OpenSSH, SSH or Windows versions like putty).  These can create an encrypted tunnel link across Internet.  One can use a nonstandard port (i.e. not 22) for ssh access and can create tunnels for port 80 (i.e. html browser).  Security can be enhanced with password and/or certificates. Then all you have to do is use a broswer directed to localhost/openemr on the remote computer.

All this functionality can be set up on any computer without buying any any software in a matter of a few minutes.  A side benefit is that one could also choose (entirely apart from using OpenEMR) to tunnel ports for vnc access to workstations for other purposes.

Ronald Leemhuis MD

bradymiller wrote on Monday, September 26, 2011:

Hi,

Another option is to use a single database that you can connect to over internet via https that is protected via client certificates with apache.

-brady
OpenEMR

rdh61 wrote on Wednesday, October 05, 2011:

Thanks for all your answers. I can see from the jargon that I’m going to have to seek the help of someone more technically expert than me(!), but I’m sure your answers will help orientate him.