Yup, as the post title says I am currently undertaking a project to provide a “hot spare” web application server using MySQL replication. The solution will use the hot spare (or “passive” server) for scale-out of certain classes of read-writes from the “active” server. Replication is being done from the “active” to “passive” and vice-versa. […]