confused on clustering 
Author Message
 confused on clustering

Hi all,

My situation:  We have 2 database(DB1 and DB2)servers running on W2K advance
server.  Currently the database servers have transaction replication
running.

Want I want to do:
        I want to setup an environment where the webserver/application
server when it queries the database server (DB1) and realized it is not
responding and will automatically switch over the DB2 for database queries.

Questions:

Is it a good idea to implement W2K clustering in this situation?.(I am not
setting up an external share drive)

Does SQL7 or SQL2000's clustering work in this situation or is it better to
use replication?

Is it better to get a third party clustering software and have it installed
on the web/application server and let it do the detection (failover of the
database server).

Any help will be appreciated.

Thanks.



Fri, 04 Apr 2003 03:00:00 GMT
 confused on clustering

Clustering is not what you need for this.  Clustering will simply keep one
server up and running, and if it dies, restart it or fail it over to another
computer.

If you want to keep two databases completely in sync and switch between them
your best bet is to look at Network Load Balancing, and then replicate data
between the machines (but watch out for latency issues).

--
Richard Waymire, MCDBA, MCSE, MCSD


Quote:
> Hi all,

> My situation:  We have 2 database(DB1 and DB2)servers running on W2K
advance
> server.  Currently the database servers have transaction replication
> running.

> Want I want to do:
>         I want to setup an environment where the webserver/application
> server when it queries the database server (DB1) and realized it is not
> responding and will automatically switch over the DB2 for database
queries.

> Questions:

> Is it a good idea to implement W2K clustering in this situation?.(I am not
> setting up an external share drive)

> Does SQL7 or SQL2000's clustering work in this situation or is it better
to
> use replication?

> Is it better to get a third party clustering software and have it
installed
> on the web/application server and let it do the detection (failover of the
> database server).

> Any help will be appreciated.

> Thanks.



Fri, 04 Apr 2003 03:00:00 GMT
 confused on clustering

Thanks Richard,

Due to certain circumstance, we prefer not  to use load balancing.  Is there
another method of configuring the Web/Applicaiton server or database server
so it would allow the Web/Application server to detect that the database is
not reponding on DB1 and will automatically switch over to DB2?

Currently I am running transaction replication between DB1 and DB2.

Web/Application server are running W2K server.

Thanks again.


Quote:
> Clustering is not what you need for this.  Clustering will simply keep one
> server up and running, and if it dies, restart it or fail it over to
another
> computer.

> If you want to keep two databases completely in sync and switch between
them
> your best bet is to look at Network Load Balancing, and then replicate
data
> between the machines (but watch out for latency issues).

> --
> Richard Waymire, MCDBA, MCSE, MCSD



> > Hi all,

> > My situation:  We have 2 database(DB1 and DB2)servers running on W2K
> advance
> > server.  Currently the database servers have transaction replication
> > running.

> > Want I want to do:
> >         I want to setup an environment where the webserver/application
> > server when it queries the database server (DB1) and realized it is not
> > responding and will automatically switch over the DB2 for database
> queries.

> > Questions:

> > Is it a good idea to implement W2K clustering in this situation?.(I am
not
> > setting up an external share drive)

> > Does SQL7 or SQL2000's clustering work in this situation or is it better
> to
> > use replication?

> > Is it better to get a third party clustering software and have it
> installed
> > on the web/application server and let it do the detection (failover of
the
> > database server).

> > Any help will be appreciated.

> > Thanks.



Fri, 04 Apr 2003 03:00:00 GMT
 confused on clustering

That's the only one I know of...

--
Richard Waymire, MCDBA, MCSE, MCSD


Quote:
> Thanks Richard,

> Due to certain circumstance, we prefer not  to use load balancing.  Is
there
> another method of configuring the Web/Applicaiton server or database
server
> so it would allow the Web/Application server to detect that the database
is
> not reponding on DB1 and will automatically switch over to DB2?

> Currently I am running transaction replication between DB1 and DB2.

> Web/Application server are running W2K server.

> Thanks again.



> > Clustering is not what you need for this.  Clustering will simply keep
one
> > server up and running, and if it dies, restart it or fail it over to
> another
> > computer.

> > If you want to keep two databases completely in sync and switch between
> them
> > your best bet is to look at Network Load Balancing, and then replicate
> data
> > between the machines (but watch out for latency issues).

> > --
> > Richard Waymire, MCDBA, MCSE, MCSD



> > > Hi all,

> > > My situation:  We have 2 database(DB1 and DB2)servers running on W2K
> > advance
> > > server.  Currently the database servers have transaction replication
> > > running.

> > > Want I want to do:
> > >         I want to setup an environment where the webserver/application
> > > server when it queries the database server (DB1) and realized it is
not
> > > responding and will automatically switch over the DB2 for database
> > queries.

> > > Questions:

> > > Is it a good idea to implement W2K clustering in this situation?.(I am
> not
> > > setting up an external share drive)

> > > Does SQL7 or SQL2000's clustering work in this situation or is it
better
> > to
> > > use replication?

> > > Is it better to get a third party clustering software and have it
> > installed
> > > on the web/application server and let it do the detection (failover of
> the
> > > database server).

> > > Any help will be appreciated.

> > > Thanks.



Fri, 04 Apr 2003 03:00:00 GMT
 confused on clustering

Why don't you use a middle tier application server.  Then your app won't care
about which server is up or down
-Alex

Quote:

> Hi all,

> My situation:  We have 2 database(DB1 and DB2)servers running on W2K advance
> server.  Currently the database servers have transaction replication
> running.

> Want I want to do:
>         I want to setup an environment where the webserver/application
> server when it queries the database server (DB1) and realized it is not
> responding and will automatically switch over the DB2 for database queries.

> Questions:

> Is it a good idea to implement W2K clustering in this situation?.(I am not
> setting up an external share drive)

> Does SQL7 or SQL2000's clustering work in this situation or is it better to
> use replication?

> Is it better to get a third party clustering software and have it installed
> on the web/application server and let it do the detection (failover of the
> database server).

> Any help will be appreciated.

> Thanks.



Sat, 05 Apr 2003 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Confused about Microsoft Clustering !!!!

2. (design question) non-unique clustered index confuses optimizer

3. Bit confused about location of DTC resource for clustered SQL 7

4. VAX clusters, INGRES licensing...Now I am confused!

5. create clustered / non-clustered index

6. Clustered Primary Key vs Non clustered PK

7. Win clustering / MS-SQL clustering

8. SQL Cluster working/MS Cluster not working

9. SQL clustering and Exchange 2000 clustering

10. What is Remote clustering and Streaming clustering?

11. cluster on cluster

12. SQL Clustering over other NT clustering?


 
Powered by phpBB® Forum Software