Re: Building high available and high performance web sites with MS

that article has some details on "scalable shared databases",
this is how you set that up:
http://support.microsoft.com/default.aspx?scid=kb;en-us;910378

obviously scalable shared databases dissadvantage is that the "update
frequency" is very low (it is as far from live/realtime as you can imagine)

HTH,
Edwin.

"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:ub$pxqcCHHA.1300@xxxxxxxxxxxxxxxxxxxxxxx
There are some thoughts on scaleout options for SQL Server here:
http://msdn2.microsoft.com/en-us/library/aa479364.aspx

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Flaxen" <Flaxen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C29A1C86-1103-4983-BDB6-77C2740EDA1C@xxxxxxxxxxxxxxxx
What is the purpose of adding extra nodes past the 2 node cluster if
clustering is just for failover? I read about adding extra nodes when
researching and didnt see why that would be advantageous? In case
multiple
servers malfunction at the same time?

Ok, now that I know Clustering wont solve my problem, is there another
method of doing database load balancing? Would have lets say 3 servers,
each
acting as a publisher/subscriber and then a 2-node cluster acting as a
distributer work well in this situation? I feel in this solution, i
would
have 3 sql servers with the same info and then a high available
distributer.

Then I assume I would need a way to make the 3 sql servers appear as one
server somehow so the code only has to reference one sql server. Maybe
round
robin dns?

Am i making this too difficult? Is there an easier solution? I cant
imagine I am the only one who needs a solution where you can scale
Microsoft
SQL servers effectively.

Thanks in advance.
"Geoff N. Hiten" wrote:

You are asking about two goals. First let me addres the availability
issue.
Microsoft clustering is a failover technology where a SQL instance can
move
between host computers in case of hardware or systems failure. The
basic
single-instance, two-node cluster (sometimes incorrectly called
Active/Passive) uses only one host at a time. You can add additional
nodes
(host computers) and instances, but the instances do not share
information
and are not "brick-type" scalable.

Right now, the way to scale SQL is to replace the host computer with a
larger one. With failover clustering, you can do this with minimal
downtime
by replacing one node at a time.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Flaxen" <Flaxen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7A300D7D-7E43-49DF-A3A7-9A134C55AA22@xxxxxxxxxxxxxxxx
Hi all. My first time posting to this newsgroup, but I think I am in
the
right place. I am in the discovery stage of building a web site that
we
anticipate will have a large amount of traffic. Our design platform
is
Windows and Microsoft SQL and the goal is to have web sites and
database
servers that are not only high available but also scalable that I can
put
in
a new server as needed to increase performance.

For the web sites, I know that I can use the NLB services of Windows
2003
standard edition. My lack of knowledge, though, is on the MS SQL
side.
I
have been reading a lot of info on Microsoft SQL server failover, but
from
what I have read this tyipcally entails having two MS SQL servers
running
in
an active/passive mode.

Does Microsoft SQL Server support the ability to have multiple MS SQL
servers using the same database and appearing as one physically
database?
If
one fails, the other servers pick up the load, and if we need to add
a
new
server we simply install it into the cluster?

I understand that I will need enterprise edition to accomplish the
goals
above, but are these goals even doable?

I know I can setup a bunch of SQL servers all doing transaction
replication, but that makes each server appear as its own database
server
and
I feel is not the proper solution for this.

Hope my questions make sense and looking forward to the answers.







.

Relevant Pages

  • Re: Building high available and high performance web sites with MS
    ... clustering is just for failover? ... Would have lets say 3 servers, ... have 3 sql servers with the same info and then a high available distributer. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Synchronization
    ... i need to install the database servers in two different sites (different ... physical location connection via the internet VPN) and i need both servers ... work on a local database instead of connecting to one ... can we configure the SQL servers to be both pricipals and replicating their ...
    (microsoft.public.sqlserver.clustering)
  • RE: Permissions
    ... servers are available to service the logon request. ... - Make certain that WINS database replication is successful between WINS ... Domainregistrations that are not listed in the ... If you are logged on as an administrator at a Domain Controller, ...
    (microsoft.public.win2000.security)
  • RE: Permissions
    ... >servers are available to service the logon request. ... >database does not have the proper domain registrations ... >If you are logged on as an administrator at a Domain ...
    (microsoft.public.win2000.security)
  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... database 9.2.0 enterprise edition. ...
    (comp.databases.oracle.server)