MDB Connectivity Scalability Tests r11 October 25th 2005 - PowerPoint PPT Presentation

1 / 39
About This Presentation
Title:

MDB Connectivity Scalability Tests r11 October 25th 2005

Description:

MDB Connectivity. Scalability Tests. r11. October 25th 2005 ... If the Inbound or Outbound limit is exhausted, the wv connection will fail with return code 28 ... – PowerPoint PPT presentation

Number of Views:82
Avg rating:3.0/5.0
Slides: 40
Provided by: yatind
Category:

less

Transcript and Presenter's Notes

Title: MDB Connectivity Scalability Tests r11 October 25th 2005


1
MDB Connectivity Scalability Testsr11 October
25th 2005

2
Objectives
  • The main objective is to determine the Maximum
    number of MDB connections that can accomplished
    in a Distributed Deployment. This is particularly
    important when large number of Distributed State
    Machines (dsm) are to be deployed
  • In addition, the test is also geared to determine
    the limit of maximum number Ingres Sessions
    based on memory constraints

3
Out-of-Box
  • Ingres has been configured for 500 Maximum
    connections
  • For Local MDB, Ingres Client is configured with
    InBound500 and OutBound500
  • For Ingres Client only setup, In Bound and Out
    Bound limits are configured as 64.

4
MDB Connection Limit
MDB Default Medium Size Configuration. The limit
will be different for other MDB configuration
5
Ingres Server
MDB default Medium Size Configuration
NSM r11 Install configures MDB with Medium size
settings
6
Ingres Client Only Configuration
7
Ingres Server SMALL MDB Setting
MDB small Size Configuration
NSM r11 Install Process configures MDB with
Medium size settings. Out-of-box NSM install
process will not permit MDB size customization
8
MDB Setup
HA Windows Cluster
Cluster Node 1
Cluster Node 2
Max Connection Limit 500
Local MDB exists but connects to Highly Available
remote MDB
I14YCLUSTER
Ingres Client Only
Ingres Server
I14Y229
I14Y204
In and Out bound Limit 64
In and Out bound Limit 500
9
Server Specification
MDB Server
Ingres Client
10
Test 1
  • Distributed DSM

11
Objective
  • The main objective is to determine in a
    distributed deployment, the number of distributed
    DSMs (agent technology) with key components
    installed, can connect to a Central MDB.
  • The test is performed with out-of-box Ingres
    Configuration.

12
MDB Setup
HA Windows Cluster
Cluster Node 1
Cluster Node 2
Max Connection Limit 500
I14YCLUSTER
In and Out bound Limit 64
13
MDB Active Sessions at Start
Client Host No of Active Sessions
Internal 22
Ingres Client 8
Local server 32
14
Remote Client - Installed Components
15
Remote Client - Installed Components
16
Ingres Client Session Breakdown
  • There are 8 permanent sessions from the Ingres
    Client.

Application Number of Sessions
aws_wvgate 2
Continues Discovery Manager 2
aws_dsm 2
ca-notify 1
Worldview Agent 1
   
Total Sessions at Start 8
17
Client Connections
  • If the continuous discovery manager is not
    installed, this will reduce the number of
    connections by 2, bringing the permanent
    connections to 6.
  • Allow for 4 additional dynamic connections. This
    will bring the average number of connections to
    10. These dynamic connections may be classic
    2dmap gui, worldview command line utilities, etc
  • MDB internally takes up 22 connections. In
    additional local MDB application takes up 32. The
    bulk of these are taken up by SevPropCom and
    Enterprise Management (JMO)
  • In a typical setup, after 475 connections ,
    out-of-memory condition may be experienced on
    the local MDB. So the architecture should be
    designed around 475 max connections

18
Distributed Agent Technology DSMs
     
Maximum number of Active Connections 475
     
Permanent Connections    
Local MDB 32  
Internal 22  
     
Number of Connection Available for Remote Clients   421
     
Number of Permanent Connections    
aws_wvgate 2  
aws_dsm 2  
Worlview Agent 1  
CA-Notify 1  
     
Additional dynamic Connections 4  
     
Total likely Connections per DSM Setup 10  
Max number of DSM per MDB   42
19
Conclusion
  • Without any Ingres configuration customization,
    approximately 42 Agent Technology DSMs can
    connect to one MDB.
  • If more than 42 dsms need to be deployed then
    federated MDB concept should be reviewed

20
Test 2
21
Objectives
  • Analyze the impact if the inbound or outbound
    limit is exhausted
  • Out-of-box, the Inbound and Outbound limits are
    set to 64. If this limit is exhausted, it will
    not be able to connect to the MDB until some
    connections are released

22
Test 2
  • Connect to Highly Available remote MDB from
    Ingres Client setup
  • Setup a Loop to connect remote CORE (mdb) until
    it fails to connect
  • Review Ingres Connections
  • Out-of-box Inbound an Out bound limit set to
    64.It cannot exceed this limit

23
MDB Setup
HA Windows Cluster
Cluster Node 1
Cluster Node 2
Max Connection Limit 500
I14YCLUSTER
In and Out bound Limit 64
24
MDB Active Sessions at Start
Client Host No of Active Sessions
Internal 22
Ingres Client 8
Local server 32
25
Generate Additional Connections from Ingres
Client Setup
Fails to connect after 56 connections as expected.
26
Aws_dsm fails with rc28
27
Ingres Sessions Review on Local MDB
Confirms failure due to In/Out Bound Limit
28
Connection breakdown by Applications
Application Average Number of Sessions
JMO (WLM) 8
SevProp 5
StartBPV 2
rmi_Server 4
setdsmname 2
Component Security 3
aws_dsm 2
aws_wvgate 2
wvobjectcell 1
Ingres (Internal) 22
wv Tools  
objbrows 1
catng2d 1
managobj 1
ca-notify 1
   
Total 54
This is not a comprehensive list. Shows
breakdown of Ingres Sessions for key applications
running on the HA Server connecting to the local
HA MDB
29
Conclusion
  • If the Inbound or Outbound limit is exhausted,
    the wv connection will fail with return code 28
  • aws_dsm may loose a connection but will reconnect
    when MDB connection is available

30
Test 3
  • Out-of-Memory Test

31
Objectives
  • The main objective is to exhaust the Ingres
    Connections until out-of-memory condition is
    experienced. Then ascertain the maximum number of
    active connections.

32
Fails to Connect after 415 additional
connections
33
Out-of-Memory
  • Attempt to launch SQL from local MDB server fails
    due to out-of-memory condition

34
Ingres Sessions Review on Local MDB
  • Stop awservices to release 4 sessions.
  • This shows Ingres Sessions after stopping
    awservices

Confirms failure due to out-of-memory
35
Conclusions
  • After connection of approximately 475 sessions,
    no more connections will be possible to the MDB
    due to out of memory condition.

36
Test 4
  • DSM Session Breakdown

37
Test 4
  • The main objective is to provide breakdown by
    process of DSM mdb sessions.
  • The test was performed with not much activity
    except one DSMExplorer was launched.

38
Domain Management Component
Database Communication
39
DSM MDB Connection Breakdown
MDB User Group Process Count
ca_itrm ca_itrm_group amobjectmanager.exe 3
ca_itrm regadmin amobjectmanager.exe 1
ca_itrm ca_itrm_group cmEngine.exe 3
ca_itrm ca_itrm_group egc30n.exe 3
ca_itrm ca_itrm_group sd_taskm.exe 3
ca_itrm ca_itrm_group cmobjectmanager.exe 1
ca_itrm ca_itrm_group dmdeploy.exe 1
ca_itrm ca_itrm_group sd_apisrv.exe 1
ca_itrm ca_itrm_group sd_dialog_m.exe 1
ca_itrm ca_itrm_group tngdtdtos.exe 1
Total     18
40
DSM
  • In summary, DSM will take approx 18 connection
    when Asset Domain Manager and Software delivery.
  • This is connecting a remote MDB
Write a Comment
User Comments (0)
About PowerShow.com