I'm in the process of configuring a LAMP server but want to make sure it'll be ready for expansion for the future.
Here's my current setup..
Two physical windows servers clustered with Hyper-V
Two virtual machines, one for Apache and another for MySQL
Two Synology ISCSI luns configured as a RAID5, one for Apache and another for MySQL
Each virtual machine is setup to use their respective ISCSI as the data folder
(website data for apache and database data for mysql)
Here's what I want to do..
Here's where I need help..
My thinking was to use a virtual ip address, which would be assigned to one of the two apache servers configured as a master. If the master dies, I want the secondary slave server to claim that virtual ip and act as the master until the original master comes back online. I don't have to worry about syncing data between the two apache servers since the data is being stored in the ISCSI. I don't have to worry about "file-access-conflict" since only one of the servers will access the server at a time. This same concept applies to the MySQL servers.
The question is.. Do you think this setup stands good for now and the future. The next question is.. What should I use for the active-passive failover handling. I was looking into ucarp, which seems pretty easy to use. What do you guys think?