Re: Clustering Question

wow, such a system would take a lot of postings to work out here in a
discussion group.

Surely you need an internet connection, but surely the SLA you get on "Cable
modem" and "DSL" connections is far from what you need for hosting a site.
But lets leave this asside for the moment.

Re-read the posts already in this thread, there is a lot of info already
given on clustering and SQL.

Re-read the post from Mathieu CHATEAU, which clearly lists all components
(times two) to do a very simple web hosting app in HA setup.
2 x server with Microsoft 2003 Web Edition (for NLB your website)
2 x server with Microsoft 2003 Entierprise Edition (for MSCS)
2 x SQL 2005 standard Edtion licenses
And your network gear : 2 routers, 2 switches, 2 Firewalls
and then 2 different ISP's for your connection
-> and this list is a very minimum list of equipment for hosting a website.

Lets start with Basic Inventory, for just one component of Mathieu's post,
the SQL cluster :

Do you want to cluster SQL ?
- then you need to get MS Windows 2003 Server Enterprise Edition, to start
with. 2 licenses one for each node in the cluster.
- NO small business editions

What version of SQL ? 2000/2005 ?
- If the answer 2005 and you are only a 2 node cluster, then you can use SQL
2005 standard edition.
- If the answer is 2000 then you need Enterprise Edition.
- If you will go to more than 2 nodes in your cluster then the answer is
Enterprise Edition for both 2000 and 2005.
- NO small business editions

Do you have Hardware which is on the Windows Catalog ?
You need a full cluster solution which is on the Windows catalog in order to
build a supported cluster, this means all hardware, servers, switches, HBA
and your shared storage is on the Catalog as one qualified solution. If it
is not, it might work, but don't call in for support when things go hairy. I
suggest to talk to your hardware vendor to get quotations.

So, now we have nothing done yet, just listed an inventory.
None of the above is really cheap, so you really need to ask yourself if you
are moving in the right path here.

Clustering is not as simple as "I have two boxes, lets slap them together"
And definitely not done (=impossible) with Small Business Edition.

It seems to me that you are quiet new to this, which is OK, I remember how I
struggled when trying to design the first web app I put on the wire.
I would advice you to hire a company with a proven track record in building
this type of setup, and get them to give you assistance.

Rgds,
Edwin.






"Bryan Krossley" <krossley@xxxxxxxxxxxxxx> wrote in message
news:B64780D6-6FFA-43D5-8A38-7799CFE37DCF@xxxxxxxxxxxxxxxx
What we are developing is an online auction site. (Hence high reliability)
Would we not need an internet connection?

Thanks,

Bryan

"Edwin vMierlo [MVP]" <EdwinvMierlo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:#6FuX0gIIHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
Bryan,

you cannot install Cluster (MSCS) on a Small Business Edition, you need
Enterprise Edition or Datacenter.

And what are you doing with Cable connections and DSL connections ?
If you are clustering an SQL server (as per all posts in this thread)
surely
you want to do this behind a firewall, not connected to the internet.

Rgds,
Edwin.

"Bryan Krossley" <krossley@xxxxxxxxxxxxxx> wrote in message
news:%23Hx4KsgIIHA.6068@xxxxxxxxxxxxxxxxxxxxxxx
So let me see if I have this right. Here is what my situation is.

I will have two computer (nodes)
One computer will have Window Server Small Business Edition with Cable
Internet
The Other computer will have Window Server Small Business Edition With
DSL
Internet And 1 Instance of SQL Server Edition deployed to both
machines.

Is this correct?

Thanks,

Bryan


"Russ Kaufmann [MVP]" <russ@xxxxxxxxxxxxxxx> wrote in message
news:363DBB7D-2DF9-4485-831E-3E53DB004A32@xxxxxxxxxxxxxxxx
"Bryan Krossley" <krossley@xxxxxxxxxxxxxx> wrote in message
news:OSIqHu8FIHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for all the replies. But I am a little confused. If both
machine
don't have Sql installed and running how would they be redundant?
Would
you not need at least two machine running the same software?

When you install an instance on a cluster, you install the instance
(the
install of SQL) to all nodes if you want to allow it to run on all
nodes.
When you install a second instance (another installation of SQL in a
different location), then you install it to all nodes if you want it
to
be
able to run on all nodes.

Then, to make it active/active, you run one instance on one node and
run
the other instance on the other node.

Thus, instance1, if it fails on its active node, it will failover to
the
other node because all of the installation files are there for that
instance. If instance2 fails on its active node, it will failover to
the
other node because all of the installation files are there for that
instance, too.

Refer to the books online for more information about instances and
how
to
install SQL on a cluster.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York





.

Relevant Pages

  • Re: Connection issues between .Net framwok and SQl Express 2005
    ... You will no longer need the database MDF file name in the connection string. ... simply attach the ASPNETDB.mdf to SQL Server permenantly, ... as USER INSTANCE on existing SQL Server Express, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)
  • Re: Performance of ODBC
    ... if you have a software firewall; forward 1433/1434 to your server ... I've now created my own server with SQL Server 2005 Express, ... glitch concerns the Upsizing Wizard. ... I originally set up my ODBC connection via ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Clustering Question
    ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... Do you want to cluster SQL? ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Question
    ... The SQL Cluster would need to be ... SQL will need to Enterprise as well. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.clustering)
Loading