I am a surgeon with some coding ability considering the implementation of OpenEMR for my practice using AWS and have a few questions. I am trying to decide between express plus and standard and I don’t exactly understand what the modular db and managed db features actually mean. Can someone please explain these.
Hello, Bala.
Express Plus uses an on-instance MySQL container to help keep costs down. Standard uses an Amazon RDS instance, which may be better for long-term scalability.
Makes sense. Thank you.
It is a limitation by AWS hosting service and not a limitation by neither MySQL (Express) nor PostgreSQL (Standard).
Uh…not sure what you mean by that. Seems the difference between express and standard is either running the app and db on the same compute unit or running them on different compute units. The benefits are obvious but i am not sure they are necessary for small practices. It all depends on how much compute power you get with each instance and how many users will be using the app.
The performance of MySQL, PostgreSQL and for that matter Oracle and Microsoft SQL server is religious war and I dont even dare to open that topic. It all depending on the size of the DB and the type of application.
You are absolutely right on your understanding - it all depends on the “computing power and the size of the allocated storage” by AWS.
What I meant was, you simply dont decide based on the DB but decide based on the compute/storage requirement of your business.
And, perhaps, where you want the buck to stop on support. If you’re running Express Plus you’re managing that MySQL; you’re being provided some very solid backups but maybe you’re not comfortable with the idea of fixing the server yourself if something breaks, or you’d like to simplify scaling by keeping database load from affecting PHP performance.