I´m trying to resolve following problem.
I have 2 application servers on Rackspace that are connected to a load balancer. Both servers must have the same applications and share the same data. Basically on each server is a Java EE application that will be writing some data into database. This data will be accessible from outside. Each server must have the same data (so he has to take them from the other servers database and viceversa).
This fact means that I need to have 2 database servers (so that one database server is not so busy if we have big traffic). To have the same data on both database servers, I was thinking of mirroring one to another (Master - Master connection). I found a Xeround database cloud, and I was thinking of creating two database instances there and accesing them from Rackspace. (Server A -> Database server A; Server B -> Database server B). And Database server A <-> Database server B would have Master - Master connection (so both servers will have the same data periodically updated).
Is this a possible and effective solution ? Or is there a better solution?