Re: Pervasive MS Cluster Active-Active-Passive works!

The cluster contains 2 resource groups, each containing (besides Pervasive,
ip, share, name) it's own shared disk on which both the data files and
transactionlog directory is placed. So both running instances, on different
servers, use a different drive (letter) for the transactionlog directory.

Assumption was that it will not be possible to have 2 instances of Pervasive
running on one node at the same time (partly because of the single
configurable location for the transaction logs). So this 3-node cluster will
only provide full (Pervasive) access, as long as no more than 1 node is
down.

So I have this (test(ed)) environment up-and-running, but are wondering if
anyone has done this before, in a real production environment, and if
Pervasive knows this is possible (since I can't find any mention at all on
3-node, or more, clustering of Pervasive).

"Leonard" <lharvey@xxxxxxxxxxxxx> wrote in message
news:kafc4219c5ldc47k06kincrnfhij8lh0qg@xxxxxxxxxx
It is probably not supported by Pervasive but does depend on specific
configuration.

The Pervasive.SQL database engine does not know how to "share" data
files between multiple engines, so multiple database engines can not
access the same data file at the same time.

If the different nodes are supporting different databases / sets of
data then it may be ok, but it brings up the transaction logs the
engine uses. Again the transaction logs are exclusive to a single
engine. The transaction log file location is configurable and if it
is put on the same volume as the data that would be fine, but, if both
nodes failed over at the same time, there is only one transaction log
location so you would still be out of luck.

If you turn off transaction logging and each node is working on its
own data files then you should be fine, otherwise I would expect to
have problems.

Loenard

On Wed, 19 Apr 2006 14:16:24 +0200, "Bob"
<google--no-spam--@...ad.heuvel.nu> wrote:

According to the Pervasive site and docs an Active-Passive (only?) MS
Cluster works and is supported. Nothing on 3-node (or more) clusters
there.

It took some creative configuration, but I managed to build an
Active-Active-Passive cluster. Fail-over and all working fine.

We would like to use this for a customer, but does anybody know if this is
supported by Pervasive? Anyone had actual experience with 3-node (or more)
Pervasive clusters?





.

Relevant Pages

  • Re: Advantages of an SQL 2005 cluster from transaction point of view
    ... Clustering will not effect the transaction count which your SQL Server ... Cluster service is designed as a high availability solution. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Does rolling a cluster create down time?
    ... What the clients see or how it affects their transactions depends solely on ... It must be cluster aware. ... be able to resubmit the current transaction as it will be rolled back on the ... When I roll the cluster from one node to ...
    (microsoft.public.sqlserver.clustering)
  • Re: Does rolling a cluster create down time?
    ... A cluster host transition is exactly like a SQL server stop-start. ... > clients mid transaction on the web pages need to restart their transaction ...
    (microsoft.public.sqlserver.clustering)
  • Re: adding product qty fields from multiple records to transaction record
    ... a second table for transaction details. ... I think I have a typical set of data files generated by my shopping ... transaction and a second file with one record per product code ... know that I need to set a flag to show that an order is new, ...
    (microsoft.public.access.queries)
  • Re: Creating an operating system
    ... the cluster should detect a ... >>failure and redirect that person's connection to another node. ... For example, given a cluster of "N+K" machines, ... a transaction once some failure has occurred. ...
    (comp.programming)