Jump to content

Muthoot Cluster: Difference between revisions

From TetraWiki
Abhinav (talk | contribs)
Created page with "--~~~~category:Postgresql Cluster Muthoot '''Cluster Of Muthoot''' == Postgresql Cluster == ==IP Details:== ..."
 
Abhinav (talk | contribs)
No edit summary
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
--[[User:Abhinav|Abhinav]] 15:20, 4 July 2013 (IST)[[category:Postgresql Cluster Muthoot]]
--[[User:Abhinav|Abhinav]] 15:20, 4 July 2013 (IST)[[category:Muthoot group]]
                                                           '''Cluster Of Muthoot'''
                                                           '''Cluster Of Muthoot'''
== Postgresql Cluster ==
== Postgresql Cluster ==
Line 29: Line 29:
  Give  10.0.0.1 ip in eth1 in liveserver And 10.0.0.2 ip in eth1 in secondary server.
  Give  10.0.0.1 ip in eth1 in liveserver And 10.0.0.2 ip in eth1 in secondary server.


==Note== : Give Ip to Management port Steps are follow:
Note : Give Ip to Management port Steps are follow:
   
   
  Step1: On boot Time go to bios
  Step1: On boot Time go to bios
Line 57: Line 57:
  Port: 11111
  Port: 11111
  Same Do for node 2
  Same Do for node 2
  Then Go To Fence Device Tab:
   
==Then Go To Fence Device Tab:==
  Press Add
  Press Add
  Fence Type: IPMI LAN
  Fence Type: IPMI LAN
Line 66: Line 67:
  Authentication Type: None
  Authentication Type: None
  Privileges Level: default
  Privileges Level: default


==Then Again Press add==
==Then Again Press add==

Latest revision as of 11:46, 19 November 2013

--Abhinav 15:20, 4 July 2013 (IST)

                                                          Cluster Of Muthoot

Postgresql Cluster[edit]

IP Details:[edit]

1.	Live Server ip: 192.168.1.133
2.	Secondary Server ip: 192.168.1.132
3.	Cluster Ip: 192.168.1.140
4.	Mgmt port ip: 192.168.1.126 (liveserver)
5.	Mgmt port ip: 192.168.1.127( Secondary)
6.	Ip for heartbeat : 10.0.0.1 (node1)
7.	Node 2: 10.0.0.2


Configuration:[edit]

133# vim /etc/hosts
192.168.1.133	liveserver.muthootco.com	liveserver
192.168.1.132	liveserver1.muthootco.com	liveserver1
10.0.0.1	node1.muthootco.com		node1
10.0.0.2	node2.muthootco.com		node2
192.168.1.127	node2-imm.muthootco.com		node2-imm
192.168.1.126	node1-imm.muthootco.com		node1-imm
Give  10.0.0.1 ip in eth1 in liveserver And 10.0.0.2 ip in eth1 in secondary server.
Note : Give Ip to Management port Steps are follow:

Step1: On boot Time go to bios
Step2: System Settings-->Integrated Management Module -->  Network-->Give Ip

133#  yum install cman rgmanager ricci luci
Note: luci package is only on one system 

Then open web interface :
https://192.168.1.133:8084
User: Same as system root details
Then Go to Service Group Tab 
Then Press add button 
Service Name : Cluster-Service
Failover Domain: None
Recovery Policy : relocate
IP Address: 192.168.1.140                \\ don’t give netmask for this IP

133# yum remove libvirt           \\ Due to this package node can’t be add it’s give error

Then Go To Node Tab[edit]

Add-->
Node Name: node1
Password: same as system
Port: 11111
Same Do for node 2

Then Go To Fence Device Tab:[edit]

Press Add
Fence Type: IPMI LAN
Name : node2-imm
Ip add- 192.168.1.127
Login: USERID
Password:xyz
Authentication Type: None
Privileges Level: default

Then Again Press add[edit]

Configure same 
Name – node1-imm
Ip – 192.168.1.126
Apply

Then Go To node TAB[edit]

Click on node 1--> Add fence method-->Fence_Method-->then Add fence instance -->node1-imm(IPMI LAN)-->Submit 
Same do with node 2 configuration and add node2-imm

Then Go To Service Group TAB[edit]

Failover Domain: Failover
Apply
Note: Make two LVM Volumes 
Vol Name: DB ,   Logical Vol : test
Vol Name: LogsSpace  , Logical Vol : LogSystem
Then Go To Resources Tab:
Add--> HA LVM-->
Name : HA
VG Name : DB
Add-->Filesystem-->
Name: DB File
File System Type: ext4
Mount point: /home/pgsql/data/base           \\path must be exist
Device Name: /dev/mapper/DB-test
Force Unmount : check mark
Apply

Add -->HA LVM[edit]

Name : Logs
Vol Grp Name: LogsSpace

Add--> Filesystem[edit]

Name: Logs_Details
File System Type: ext4
Mount point: /Logs
Device Name:  /dev/mapper/LogsSpace-logSystem    
Add-->script
Name: Sql-Script
Full Path to script File: /etc/init.d/postgresql 
Apply