I am investigating whether or not it is possible to synchronize multiple instances of OpenEMR such that the databases will remain in sync whenever both instances are online, as well as allow individual instances to make changes “off the grid” and then synchronize when brought back online. If this is possible, what are the best practices?
We have a functioning instance at our clinic already, but wish to be able to bring remote instances of OpenEMR on a laptop to remote areas where even cellular data service is impractical. Upon bringing the laptop back to the main clinic, the databases would synchronize.
Is MySQL master-master replication suitable for this? How do we avoid collisions? There was some talk of OpenEMR being modified for the Peace Corps and mobile apps in order to support this type of behaviour, but I’m not sure if these features were ever completed.
Thank you very much for your help and for your contributions to the open source world!