Just to say I know some about servers and databases but not enough to achieve what has been asked so I just need some advice to set me straight :)
Okay so we have two dedicated servers running windows server 2008 standard sp2, due to cost limitations I will only have two servers any nothing else.
The services hosted on these boxes will be IIS7, Apache2, SQL Server and MySQL until I have the funds to scale out.
I have no load balancer nor can I alter the IP configuration of the servers, so as far as balancing/clustering goes the only real thing I can do is round robin dns with a low TTL, would this be right?
As for IIS and apache I have a domain share setup with DFS that both web servers use for there files, again is this an acceptable way to do it?
So far I think it will work aslong as I find someway of updating the dns servers to send the traffic a working server.
I have been struggling with the databases, so far I have them setup as a mirror and I can fail over from one to the other and this is working okay for SQL as I can specifiy a partner server in the connection string but thats not ideal as it's also per database and I dont want to have to modify the applications.
I'm not aware of a partner server in a mysql connection string.
Can anyone shed some light on this? I've been tearing my hair out for days now!