About WSO2 API Manager data sources

3
votes

I'm performing WSO2 API manager + Analytics 2.0 POC now. When i change datasource from H2 to Oracle, in wso2am-2.0.1-SNAPSHOT, there are 2 data source config files: master-datasources.xml & metrics-datasources.xml, according Installing and configuring the databases, there should be WSO2AM_DB, WSO2UM_DB and the WSO2REG_DB datasource configurations, but i just find WSO2_CARBON_DB & WSO2AM_DB, so my questions are

  1. Is WSO2_CARBON_DB = WSO2UM_DB + WSO2REG_DB?
  2. for WSO2_METRICS_DB, according Enabling Metrics and Storage Types, if we enable JDBC storage, can we store all components metrics information in one shared db or it needs one db per component(local)?
  3. What's WSO2_MB_STORE_DB used for? from the scripts, it's for Message Store and Andes Context Store. Can we keep to use H2 in prod. cluster env.?

When i config wso2am-analytics-2.0.0-SNAPSHOT, i have below questions:

  1. Can we share WSO2_CARBON_DB setting for both APIMGRT related components and analytics? or it's better to not share?
  2. For WSO2AM_STATS_DB, is analytics resposible to aggregate and write to it, APIMGRT responsible to read? Which APIMGRT components need to read it?
  3. For analytics related store, it supports RDBMS, Cassandra, HBase, but it does not support mongodb, right?
  4. for GEO_LOCATION_DATA, What's this used for? Can we just use H2 in prod. env.?
1
wso2wso2-am
For one question you asked, it is not recommended to use H2 in prod environment. - lakshman

1 Answers

2
votes

APIM:

1) In default pack, yes. But in a production environment, it is recommended to separate them as WSO2_CARBON_DB, WSO2UM_DB and WSO2REG_DB (Please note you need WSO2_CARBON_DB too, to store local data. And this can be an h2 database)

2) You can have a shared DB

3) WSO2_MB_STORE_DB is required only if you use Advanced Throttling. Tables for this are created by APIM itself. So you don't need to run any scripts on it.

APIM Analytics:

1) You can share WSO2UM_DB and WSO2REG_DB. But don't share (local) WSO2_CARBON_DB.

2) Store and Publisher

3) See WSO2 DAS with MongoDB

4) GEO_LOCATION_DATA is used for Geolocation Based Statistics. H2 is not recommended.