Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: https://github.com/wso2/product-apim/issues/5042

...

  • User Manager database - Stores information related to users and user roles. This information is shared among the Key Manager Server, Store, and Publisher. Users can access the Publisher for API creation and the Store for consuming the APIs. The User Manager database is also referred to as WSO2UM_DB and userdb.
  • API Manager database - Stores information related to the APIs along with the API subscription details. The Key Manager Server uses this database to store user access tokens that are used for verification of API calls. The API Manager database is also referred to as WSO2_AM_DB and apimgtdb.
  • Registry database - Shares information between the Publisher and Store. When an API is published through the Publisher, it is made available in the Store via the shared registry database. Although you would normally share information between the Publisher and Store components only, if you are planning to create this setup for a multi-tenanted environment (create and work with tenants), it is required to share the information in this database between the Gateway and Key Manager components as well. The Registry database is also referred to as WSO2REG_DB and regdb.
  • Statistics database - Stores information related to API statistics. After you configure API-M analytics, it writes summarized data to this database. The Publisher and Store will use a REST endpoint to connect to WSO2 API-M Analytics which in-turn will fetch data from the database. The Statistics database is also referred to as WSO2_STAT_DB and statdb.
  • Message Broker database - Traffic Manager uses this database as the message store for broker when advanced throttling is used. The Message Broker DB is also referred to as WSO2_MB_STORE_DB and  mbstoredb.

...


 

API Manager
database

apimgtdb

WSO2_AM_DB

User Manager
Database

userdb

WSO2UM_DB

Registry Database


regdb

WSO2REG_DB

Statistics
Database


statdb

WSO2_STAT_DB

Message Broker
Database

mbstoredb

WSO2_MB_STORE_DB

Publisher

Used

Used

Used

Not usedNot used

Store

Used

Used

Used

Not usedNot used

Key Manager

Used

Used

Used (in multi-tenancy mode)

Not usedNot used

Gateway

Not used

Used (in multi-tenancy mode)

Used (in multi-tenancy mode/ in multiple gateway mode when Google Analytics is used)

Not usedNot used
Traffic ManagerNot usedNot usedNot usedNot usedUsed
Multiexcerpt
MultiExcerptNameGatewayDBconfig
Notes
  • Although the Gateway does not use the WSO2 API Manager database , this connection is and the WSO2 Message Broker database, the default connections are required; therefore, do not remove the default configuration configurations in the <API-M_HOME>/repository/conf/datasources/master-datasources.xml file. This connection These connections should be your default database (H2 database).
  • The Gateway node creates a connection at the startup start-up with the WSO2 API Manager database, but this connection will not be used later on.
  • If you have more than one Traffic Manager node, each Traffic Manager node must have its own Message Broker database (WSO2_MB_STORE_DB).

...