Hello... thanks for reading, i hope you can help me...
I've just configured a load balancing scenario using Virtual Server 2005... i think i could use this (in a production enviroment) when i want to publish a transactional web site, where servers behind this load balancing scenario have locally the exact web site but pointing to another server (outside the load balancing scenario) which hosts the application database... here if my database server (or all load balanced servers) fail, everything will fail...
I've also configured microsoft cluster services... and a sql 2005 2-node cluster scenario, but Active/Pasive... here my scenario will fail only if both servers fail but i have one useless server, waiting for the other one to fail so it can work... am i right??? if so, it's a very expensive solution...
my question is... if i install an Active/Active sql 2005 cluster scenario... will both servers work with the same database? i don't understand A/A very much... i've read that with A/A you take full advantage of both servers resources... but that you can't serve the same database in multiple sql instances... is this correct?
what should i do then?
sorry, i'm not an english native speaker...
thanks in advance...
I've just configured a load balancing scenario using Virtual Server 2005... i think i could use this (in a production enviroment) when i want to publish a transactional web site, where servers behind this load balancing scenario have locally the exact web site but pointing to another server (outside the load balancing scenario) which hosts the application database... here if my database server (or all load balanced servers) fail, everything will fail...
I've also configured microsoft cluster services... and a sql 2005 2-node cluster scenario, but Active/Pasive... here my scenario will fail only if both servers fail but i have one useless server, waiting for the other one to fail so it can work... am i right??? if so, it's a very expensive solution...
my question is... if i install an Active/Active sql 2005 cluster scenario... will both servers work with the same database? i don't understand A/A very much... i've read that with A/A you take full advantage of both servers resources... but that you can't serve the same database in multiple sql instances... is this correct?
what should i do then?
sorry, i'm not an english native speaker...
thanks in advance...