Please forgive this ignorant question, but can someone tell
me how one would go about using multiple database servers?
Just as there comes a time where one would need more than
one web server and would need to use a load balancing
solution, what happens when one would need more than one
How does one go about implementing that solution?
Is there some way to have two database servers carrying the
same information with some kind of load balancing solution
in front of it(?) or does one place some tables on one
server, and other tables on the other database server?
(I have no clue as to how things would work.)
Microsoft SQL allows for clustering of SQL databases, so for
instance two servers connected to a fileshare and a virtual address
shared across the two physical boxes. Database connections are made
to the virtual addres which will then be handled by the active
node. Becuase a database is ultimately a file(s) on a disk it can
only be attached to one node at a time so you end up with an