Suppose you are expecting 10,000 clients.
1) Would you still recommend a database instance per client?
2) Suppose you have a couple of client database instances spread across a couple of servers. I am not very familiar with clustering capabilities in Win2K. Is providing a fault-tolerant solution still possible without much effort?
I think with a single database instance implementation, servers could be clustered in an active-to-active configuration providing a fault-tolerant and load-balanced solution in the ASP industry. When creating client database instances and spreading them across a couple of servers, providing a fault-tolerant solution may get more difficult because each server does not look identical. Is this true?