We have one server (Server A) running a Web-based application with PostgreSQL right now. What we want to do is to set up another instance of the application to run at another server (Server B), and we want both database A and B to be synchronized.
Users of the application will use Server B, but in case of a failure of Server B (such as system crash), we want the users to still be able to access the application from Server A. When Server B is back online, we want the databases synchronized.
We have full access to Server A (we can install/configure) but we don't have an actual machine for Server B yet. We want you to suggest a solution (such as a hosting package) that will be able to meet the mentioned requirements.
Your job is to implement your suggestion to meet the above requirements, which includes:
- Setting up and configuration Server A/B and the relevant software required
- Deployment of the application from A to B without interrupting the use of application on Server A. Application must actually work on Server B.
- Setup a test environment so that you can simulate the failure of Server B to demonstrate to us that the database synchronization actually works.
When you bid, please briefly describe in PM what you're going to do. If there's other costs such as the cost for hosting package or a commercial software package, please don't include them in your bid but do mention them in PM.