| Jeff Turner 2006-03-15, 11:23 am |
| Howdy, I've got a question about load balancing & providing redundancy
for a group of Win2k3 servers that are NLB'd together.
is it possible to have SQL 2005 Std on each box, and transactionally
replicate to each other (maybe 3-4 servers tops) ?
the idea is NLB would provide the balancing/redundancy for IIS
visitors, and each server would access the data on it's local machine,
so if one machine went out, the others would keep everything up.
is it naive to think the replication would happen quickly enough so
that users aren't seeing data out-of-sync (inserts/updates/deletes at
maybe 10 per second tops) if they get bounced from one server to
another during a visit?
I realize that this doesn't protect me at the app level, but I can
manage that. I'm just trying to spread out the load, and guard against
any kind of hardware failures bringing everything down.
Thanks!
|