Using SQL Server 2005 with SharePoint Services V3 to Load Balance the Database requests
- From: spconsultant <gfpilot2002@xxxxxxxxx>
- Date: Mon, 14 Jan 2008 13:05:53 -0800 (PST)
I have not seen a definitive answer on the net anywhere about this
specific question. If you can give a clear and in-production example,
it would help many people. I have read some philosophical debate about
the definition of active/active and an answer to another post on the
topic that essentially said "why would anyone do that."
I have a client with an office in the USA and one in China. They are
interested in Windows SharePoint Services version 3.0 (Not MOSS), to
actively post in both locations. They are concerned with the response
times of an application hosted at either site, and used to update
content universally. They would like to have the SQL Server and WFE
roles located at BOTH locations ACTIVELY updating to their local
databases, and having the data available in BOTH locations. They have
termed this an Active/Active database configuration, because they are
actively updating both databases. The purpose of this is NOT disaster
recovery or failover, although it makes since that if both have the
same content, it could be used that way. I have read the microsoft
whitepapers on Mirroring and Log-shipping with SharePoint, and they
are very clear about the implications and requirements for failover
(automatic or manual High availability/ High Performance configs,
etc).
It appears that this configuration is not possible with standard
product features (of SQL Server 2005 or SharePoint Services 3), and I
have not found anyone say that they have successfully accomplished
this in a production environment. (I did read one post about someone
who was going to try it, but no follow up about success or failure). I
also read a post that mirroring or log shipping should not be used
for a MOSS SSP DB.
I have implemented a failover cluster in a SAN environment
successfully, but that is not what the requirement is in this case. I
have also implemented load balanced WFEs. This question is
specifically about load balancing the requests against the DB server,
and being certain that all data is on both servers. I also suggested
that each location could have its local DB with update access to local
information, and read access to remote information, but that does not
meet their needs since employees at both locations work together on
projects that are owned by either location.
.
- Follow-Ups:
- Prev by Date: Re: No virtual server on installation of WSS 2
- Next by Date: Best way to temporarily take server offline for maintenance??
- Previous by thread: Windows API to return port numbers on which services/processes are running?
- Next by thread: Re: Using SQL Server 2005 with SharePoint Services V3 to Load Balance the Database requests
- Index(es):
Relevant Pages
|
