RE: Please help regarding the architecuture I am Planning for.

Tech-Archive recommends: Fix windows errors by optimizing your registry

What is the rationale for having a six-node cluster with only three SQL
instances? You may be better off with three two-node clusters, and that would
give you better isolation. But you have a specific reason for your current
configuration.

Linchi

"Shamshad Ali" wrote:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/7f0bc946-c9a4-48f9-a668-d14de245e267


We have clusterA with 6 Nodes, 3 active and 3 Passive, all passive will be
available for any active nodez for Failover. All online database activity
will be done on this clusterA, then we have one another clusterB with 4
nodes, the database on ClusterA will setup merge replication with ClusterB.
My question is:
1- Is Merge replication available on Cluster environment?
2- Is Table Partitioning possible on Cluster environment?
3- All three technologies can be gathered in to give High Performance and
High Availability?
4- Also could you please tell me what is the advantage of using windows
server 2008 cluster over windows server 2003


We will be doing some data level maintenance and updates (fixing data
changes from other database) on ClusterB and also the reports will be served
from ClusterB. This will automatically give a Load Balancing environment.

Please help me if this can be achieved or it might has any flaws. We will
distribute Database level activity Load among two Clusters via replication
and to face large tables we may us benefit from table partitioning. How it
would look like?

We have 100000 users online at a time and we have 0 downtime with max.
performance is target to achieve. Also the maintenance cost should be
considere3e as much we can reduced as possible.


You can find my designed architecture here:


http://www.geocities.com/shamshad_ali74/SQLCluster.jpg

------------------------------------------------------------------------------------
http://www.geocities.com/shamshad_ali74/SQLClusterMReplication.jpg

Please give your suggestion and thoughts ...

Shamshad Ali.

.

Relevant Pages

  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Third party Windows App to NFS map OpenVMS to Windows Server
    ... How to Setup an NFS Server Using TCPIP ... or as an option of the database to be installed on ... The site which was working correctly had configured their Rdb DB system ... as a member of a larger OpenVMS cluster, and the site with the problems ...
    (comp.os.vms)
  • Re: Cluster will not fail over.
    ... Below is the response from Microsoft as promised. ... They think a cluster does all the ... Database operations isn't magic, we need to quit treating it ...
    (microsoft.public.sqlserver.clustering)
  • SUMMARY: SC 3.1 U4 on Sol 10 x86 + Ora 10g
    ... Oracle can be started manually, but not with the cluster ... root cannot connect the database server using ... There's a script in the Oracle install directory (don't know the exact ... It seems that I can connect the listener, but the listener can't connect the ...
    (SunManagers)
  • Re: Cluster will not fail over.
    ... Senior Database Administrator ... >> As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... >> able to restore the master database. ... >> a cluster installation you'll have to revisit. ...
    (microsoft.public.sqlserver.clustering)