| Author |
Message |
ebferro
Guest
|
 Posted:
Thu Dec 30, 2004 6:49 am Post subject:
Pervasive SQL Clustering |
|
|
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 |
|
| Back to top |
|
 |
Shon Shah [MSFT]
Guest
|
| Posted:
Sat Jan 01, 2005 1:20 am Post subject:
Re: Pervasive SQL Clustering |
|
|
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...
| Quote: | 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 |
|
|
| Back to top |
|
|
ebferro
Guest
|
| Posted:
Mon Jan 03, 2005 6:23 pm Post subject:
Re: Pervasive SQL Clustering |
|
|
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:
| Quote: | 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
|
|
|
| Back to top |
|
|
Shon Shah [MSFT]
Guest
|
| Posted:
Tue Jan 04, 2005 3:53 am Post subject:
Re: Pervasive SQL Clustering |
|
|
Ernie,
1. Clustering simply controls the start and stop of the service on the node
which hosts the Generic Service resource created for that service. The
easiest way to see this is to take the Generic Service resource offline on a
node and query the status of the corresponding service using command "sc
query <service_name>" on that node. It will show the state as STOPPED. Now
bring the resource online and query the status again, it will show the state
as RUNNING. So you should not remove services from any node.
2. The setup program of the application needs to be cluster aware for this
to happen. And being cluster aware means that it should be able to determine
all the nodes in the cluster and then install the application binaries on
all the nodes of the cluster. Even in the case of SQL server setup on a
cluster, although you run the setup on a single node, it does install SQL
binaries on all the nodes of the cluster.
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:47FDDC79-6F16-40B4-A217-0F308F5F7FD2@microsoft.com...
| Quote: | 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
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in