Syncing openemr database with online storage

Day-to-Day Users
1

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.

2

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

3

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

4

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

5

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.