Re: Active/Active configuration

Linchi, just make sure your application is active/active ready. Will
both nodes assign duplicate IDs such as customer or order numbers? Is
common application state stored in shared memory? Will a response get
returned to a wrong node?...and so on. www.availabilitydigest.com

On Jan 19, 3:38 pm, Linchi Shea <LinchiS...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
-Any articles on setting up a two nodeActive/Activeconfiguration (ideally
step by step)? Almost everything out there is onActive/Passive.Setting up another instance in a cluster is no different than setting up the
first instance. Books Online has detailed steps.

-Since there are at minimum 2 instances running at the same time on a two
nodeactive/activeconfiguration, is there still 1 virtual IP address? If so,
how does sql server knows which instance an application/user is refering to?You need a separate IP addresse for each clustered instance.

-On anactive/passive configuation, microsoft recommends two networks
(public/private) but it can be done with only 1 (not recommended but
possible). Does this also apply on anActive/Activeconfigurtion? We are
using blade servers and only 1 network can be configured so I want to make
sure thatActive/Activecan work with only 1 network.Still applies. But since the purpose of a failover cluster is to provide
high availability, you really shouldn't share a single network. That kind of
defeats the HA purpose.

-We have 2 main databases and we are planning to have one database on each
node. Would'nt this have a better performance instead of having both database
on one server (active/passive). I am aware that clustering is for
availability only but it seems like we could get a better performance in
active/active. Is this a valid assumption?You may get better performance by virute of running each database on its own
host, thus using separate processors, memory, network cards, HBA's, etc. That
is, if your database can take advantage of these separate hardware
components. So, if one of your databases is cpu bound, for instance, having
it on its own server would certainly help.

Linchi



"Sas" wrote:
Few questions onActive/Activeconfiguration (SQL 2000):
-Any articles on setting up a two nodeActive/Activeconfiguration (ideally
step by step)? Almost everything out there is onActive/Passive.
-Since there are at minimum 2 instances running at the same time on a two
nodeactive/activeconfiguration, is there still 1 virtual IP address? If so,
how does sql server knows which instance an application/user is refering to?
-On anactive/passive configuation, microsoft recommends two networks
(public/private) but it can be done with only 1 (not recommended but
possible). Does this also apply on anActive/Activeconfigurtion? We are
using blade servers and only 1 network can be configured so I want to make
sure thatActive/Activecan work with only 1 network.
-We have 2 main databases and we are planning to have one database on each
node. Would'nt this have a better performance instead of having both database
on one server (active/passive). I am aware that clustering is for
availability only but it seems like we could get a better performance in
active/active. Is this a valid assumption?

Thank you all
--
--

System Eng.
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
"I saw it work in a cartoon once so I am pretty sure I can do it."- Hide quoted text -- Show quoted text -

.

Relevant Pages

  • Re: Remote data entry solution needed for Access 2007
    ... Users open the database remotely and use its forms to enter data. ... Why it doesn't work: network lag time. ... our network admin says our Citrix server is 2000 and ... HTML-based form working with an ASP file to send data to the database. ...
    (microsoft.public.access.externaldata)
  • Re: dataset safety?
    ... In my idea is the transport on the network (even more on ethernet because of ... posible collisions) that makes a network slow, not the times you use it. ... client has to send the update to the server. ... so the server can go to the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Winsock rate of sending data
    ... The database only has 1 table with 3 columns: ... my machine with less power then the server, ... compress when I am sending the data, ... >network and reducing the server's workload, ...
    (microsoft.public.vb.general.discussion)
  • Re: Suggestions Please !!!
    ... The P2P network itself uses a central ... server for holding all the relevent information. ... so setting up a database for them is too much trouble. ... maintenance requirements are too much trouble? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: db corruption
    ... > posts just to help someone. ... See http://www.QBuilt.com for all your database needs. ... Very solid and fast network connectivity, ... > The server is hundreds of GB's with many many users. ...
    (microsoft.public.access.setupconfig)
Loading