[ClusterLabs] Fwd: need some advise on pacemaker cluster setup with oracle db

[emmanuel segura]

you can have 4 configured in pacemaker 4 oracle instance(failover
mode), using 4 resource group in this way"

resourcegroup -> filesystem->vip->oracleinstance->oracle_listener

If you want to use lvm with your oracle instance for space management:

resourcegroup -> lvm_resource->filesystem->vip->oracleinstance->oracle_listener



2016-08-25 16:42 GMT+02:00 Tom Naorem <tom.sana at gmail.com>:
> hello experts,
>
> i need some advise in a pacemaker cluster setup.
> i have configured a pacemaker cluster with 2 x bl460c gen9 servers on a rhel
> 7.2 platform. cluster is configured and fencing is configured using
> fence_ipmilan agent and it is working.
>
> there are 16 luns from a 3par storage as a shared storage on both the nodes
> and i can see them in the os as mpatha, mpathb ...etc on both the nodes as
> it is through multipathing and i created lvms with vg and lv commands and i
> created 8 lvms on first node and 8 lvms on the 2nd node as per customer
> requirement and i have created 16 same mount points on both the nodes with
> the same path for mount points on both the nodes for failover.
> now when i run lvs command i can see the 16 lvms on both the nodes with same
> names.
> all the 16 lvms are ext4 filesystem as per customer requirement and i
> created the first 8 filesystem cluster resources on the first node and the
> remaining 8 filesystem cluster resources on the 2nd node and they are not
> cloned so that means it will run on 1 node at a time so now the first node
> has 2 resource group with 8 filesystem cluster resources and the 2nd node
> has 2 more resource group with 8 filesystem cluster resources.
> a/c to customer requirement i need to set 4 virtual ips (2 on each nodes) so
> i created 4 virtual ips and i alligned these virtual ips one for each
> resource group in the cluster so 4 virtuals ip for 4 resource group and 2 of
> them on each node. i tested the failover 2-3 times by rebooting each node
> and they are failing over the cluster resources with all the data in place
> on the mount points on both the nodes so i know the setup is working fine
> till here.
>
> now here comes my first doubt  >> do i need to create and run dlm and clvmd
> cluster resouce on both the nodes for this setup, i know we need to run
> those resources in gfs2 filesystem when cloned but i couldn't find a good
> document which talks about dlm and clvmd on a ext4 filesystem which are not
> cloned resource , or they are only necessary when it is a cloned filesystem
> resource or when they are running on both the nodes at the sametime, also
> note that i have not created lvm cluster resources for these filesystem
> cluster resources or do i need to make some changes in the current setup.
>
> my 2nd doubt >> do i really need to re-create the initramfs with dracut
> command or it is not needed as the cluster volumes are just fine on all the
> reboots during the failover test.
>
> and the 3rd one >> customer need to run 4 instances of oracle db (12c) , 2
> of them on each node according to the design doc. i found this article
> (https://access.redhat.com/solutions/25970) but this doesn't help much. this
> article talks about adding oracle resource in the pacemaker cluster but it
> doesn't talk about multiple instances though. is it really possible to run 4
> oracle db instances on a 2 node pacemaker ha cluster on rhel7.2 or oracle
> rac is the only way to do this ?
>
> would really appreciate any input on this ?
>
> thanks
> /tom
>
>
>
> _______________________________________________
> Users mailing list: Users at clusterlabs.org
> http://clusterlabs.org/mailman/listinfo/users
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://bugs.clusterlabs.org
>



-- 
  .~.
  /V\
 //  \\
/(   )\
^`~'^