Re: Pervasive SQL Clustering

From: ebferro (ebferro_at_discussions.microsoft.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 04:23:04 -0800

Shon:
Thanks for the help. I think I have things set up as you suggested and it
appears that it's working. I do have a couple of questions, though.
1. I've installed Pervasive to both nodes. In addition to installing the
database maintenance applications to the C: drive on both nodes of the
cluster, it has also installed two services that run when the nodes start.
These are the services that I've clustered using your instructions below.
So, in effect, I've got services running on the cluster and both nodes. Is
it OK to remove the services from the nodes since they are installed on the
cluster or does the clustering software simply control the operation of the
services on the nodes depending on which node is running the cluster at the
time?
2. Is it possible to install and application to the cluster rather than the
nodes separately, similar to SQL Server, or do the applications need to be
cluster aware for this to happen?
Thanks in advance for the assistance.
Ernie
"Shon Shah [MSFT]" wrote:

> Ernie,
>
> I do not have any experience with Pervasive SQL but as for the steps for
> setting up a Generic Service resource, you might find this topic from Help
> topics of 'Cluster Administrator' useful - Checklist: Installing a Generic
> Service resource
>
> Here are some of the things one should keep in mind while making a service
> or application highly available using Generic Service or Generic Application
> resource types respectively:
>
> 1. Service/application binaries have to be installed on the local disk of
> each cluster node (preferably at the same location on each node). Clustering
> will NOT replicate these files for you.
> 2. The data needed by the service/application has to be on the shared disk
> and the service/application has to be configured accordingly.
> 3. If the service/application uses registry keys for storing data, these
> keys have to be specified for registry replication while creating the
> resource.
> 4. Most often you will start with a group containing IP address, Network
> Name and Physical Disk resources with Network Name dependent on IP Address
> resource and end up making the Generic Service/Generic Application resource
> dependent on Physical Disk and Network Name resources.
>
> Hope this helps.
>
> --
> Regards,
> Shon Shah
> Software Design Engineer/Test
> Microsoft Cluster Server
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples, if any, are subject to the terms specified
> at http://www.microsoft.com/info/cpyright.htm
>
> Please do not send email directly to this alias. This alias is for newsgroup
> purposes only.
>
> "ebferro" <ebferro@discussions.microsoft.com> wrote in message
> news:42FA0716-8CC4-4CCA-898E-4258661D6DE6@microsoft.com...
> > I'm trying to cluster Pervasive SQL on our cluster server and not having
> > much
> > luck with it. I need to use Pervasive for an old application that we run.
> > I've installed Pervasive on one of the nodes and it installs to the
> > c:\pvsw
> > subdirectory. It also looks like it installs a btrieve service and a
> > pervasive SQL service. I'm not exactly sure whether I should install it
> > as a
> > generic application or as a generic service. When I attempt to install
> > the
> > two services as a generic service, I get an error. It doesn't look like I
> > should install it as an application since it looks like all I really need
> > are
> > the services. I've several questions.
> > 1. Is there anyone who has clustered Pervasive SQL and if there is, can
> > you
> > tell me how to do it?
> > 2. Are there any resources available that would explain how to set up
> > applications using the generic application resource? If I want to install
> > as
> > a generic application, do I need to install to one of the clustered disks
> > or
> > will the cluster service replicate application installed to the c drive on
> > the c drives of the other nodes?
> > 3. Are there any resources available that would explain how to set up
> > services using the generic service resource?
> > TIA
> > Ernie
>
>
>
>

Relevant Pages

  • Re: How would you configure an N+1 cluster using MS Cluster Servic
    ... In case anyone else stumbles across this problem with the Generic Service ... It is possible to use both the Cluster Administrator and the APIs to ... The only way round this restriction seems to be to write a resource type DLL ... hence prevent multiple failovers to a passive node in an N+1 configuration. ...
    (microsoft.public.windows.server.clustering)
  • Re: Error installing SQL 2005 on a cluster
    ... even if you are trying to do a stand-alone install. ... I had created an "Unused Drives" resource group to keep my unused ... disk resources from becoming corrupted but hadn't brought them online. ... drive resource is online and functioning correctly inside cluster ...
    (microsoft.public.sqlserver.clustering)
  • Re: Pervasive SQL Clustering
    ... setting up a Generic Service resource, you might find this topic from Help ... or application highly available using Generic Service or Generic Application ... > I'm trying to cluster Pervasive SQL on our cluster server and not having ... I'm not exactly sure whether I should install it ...
    (microsoft.public.windows.server.clustering)
  • Re: Pervasive SQL Clustering
    ... which hosts the Generic Service resource created for that service. ... The setup program of the application needs to be cluster aware for this ... cluster, although you run the setup on a single node, it does install SQL ...
    (microsoft.public.windows.server.clustering)
  • Re: Error installing SQL 2005 on a cluster
    ... even if you are trying to do a stand-alone install. ... I had created an "Unused Drives" resource group to keep my unused ... disk resources from becoming corrupted but hadn't brought them online. ... drive resource is online and functioning correctly inside cluster ...
    (microsoft.public.sqlserver.clustering)