Re: Active/Passive to Active/Active

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


I did go through few docs in ms site and other forums, but got into
confusion when people say A/A is not recomended and most of them speak
only
abt SQL server which can run in multiple instances. Ours is an application
which can't run in multiple instances on same machine, So I was asking you
for every detail involved with A/A. Now I got into a conclusion that our
application may not work in A/A, hope I am correct?


If your application cannot run in multiple instances then you are limited to
"A/P" in a two node setup.
You can off-course do a 3 node "A/A/P" or "N+1" setup, and set the
"affinity". Setting the AntiAffinityClassNames ensures that no two the same
applications are running on the same node. See more about this here :
http://support.microsoft.com/kb/296799

For instance, Exchange is using this to ensure that no two Exchange virtual
servers are running on the same node:
http://technet.microsoft.com/en-us/library/bb124140.aspx

So, a 3 node "N+1" configuration or a more-node "N+1" or "N+2" might work
for your application.
(e.g the following could work A/A/A/P, A/A/A/A/P/P)

I realize that these are more advanced configurations, so get practice and
experience first.

Also, I find it always useful to have a "practice-cluster" in a Virtual
Machine, so build yourself a cluster using Microsoft Virtual Server or
VMWare Server, and you can practice away without doing "harm" to your
official production/test equipment/setup.

Good Luck with Clustering, and if you have a problem, post it here and we
will try to help you out.

Rgds,
Edwin.



.

Relevant Pages

  • Re: cluster nodes as AD or not?
    ... Clustering AD DCs is an unnecessary practice. ... MVP - Windows Server - Clustering ... >> The reason for my post is that I told my customer that this was nothing ... > This goes back to the original thinking behind building a cluster. ...
    (microsoft.public.windows.server.clustering)
  • Re: CreateObject, GetObject and COM instances - need help!
    ... COM servers can be classified as Multiuse or Single Use ... COM server, the server uses only one instance of the .exe file to create ... In the Single Use (Multiple Instances) ... The fact that you can launch multiple processes of your App ...
    (microsoft.public.vsnet.general)
  • Re: Running multiple instances in production environment. Good or bad?
    ... are severe memory limitations on the 32-bit platform. ... SQL Server Standard Edition can use up to 2 GB for the Buffer Pool. ... I have read some of the postings in this forum, and most of them seem to be negative to running multiple instances in a production environment, mainly due to the fact they will compete for system resources. ...
    (microsoft.public.sqlserver.server)
  • Re: Record source at runtime
    ... more than one query that is lacking the PK field. ... little with a small number of records, but best practice is best practice. ... The way Jet works is to go to the server, find the tableand pull the ... Limiting the fields doesn't matter much unless they are OLE ...
    (microsoft.public.access.formscoding)
  • RE: checking server status
    ... That is if you're talking aobut the Windows platform... ... Theory is just like Practice... ... Is anyone know about kit-tool to install on my server ... SurfControl E-mail Filter for SMTP & Exchange leverages multiple layers of ...
    (Focus-Microsoft)