I've just started developing a mobile app which will use a server side, hopefully handling a lot of processing and traffic. I was inteding to use TomEE+ with built-in OpenJPA and Postgres DB, initially on one master server but as it grows more master servers will be set (in different geo locations/data centers) using some data sync mechanism between them.
Now that i've met ObjectDB I want to check the option using it instead of postgres so I have few questions regarding it:
- As the embedded DB seems to be with superior performance would you recommend using it with TomEE+ instead of creating a 2 TomEE+ frontend servers cluster with ObjectDB server as a backend DB?
- Does DB backup backs all objects including indexes? If yes, is there a way to backup data only? And. is there a way to backup specific entities only?
- What is the overhead of online backup?
- What is the overhead of the Transaction Replayer?