We have a PHP / MySQL application. We also have three (but could be more) VPSes all set-up as Ubuntu 10.04 servers. We need someone to architect together, using freely available or open source tools, load balancing, failover, and monitoring for our PHP application. In particular, it needs the following: 1. Ability to load balance the database requests since our application is database heavy. However, inserts / updates happen on every request (in some form), so updates need to be seamless. 2. Failover if one part of the system goes down. 3. Easily ability to monitor all systems thru a web-based interface, and SOME automatic restarting of services if necessary (like thru Monit). 4. Ability to configure alerts if there is an issue. 5. Easy ability to add new servers as necessary to spread out load. In your bid give a brief overview of how you will build (or how you will build this) and/or statements that you have built such a system. We will give access to the winning programmer to our clean VPSes to set-up the system but basic instructions on replicating the tasks is also required.
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
Linux Ubuntu 10.04