Each Carbon-based product uses a database to store information such as user management details and registry data. All nodes in the cluster must use one central database for config and governance registry mounts. These instructions assume you are installing MySQL as your relational database management system (RDBMS), but you can install another supported RDBMS as needed. You can create the following databases and associated datasources.
Warning |
---|
The embedded H2 database is suitable for development. However, for most enterprise testing and production environments we recommend an industry-standard RDBMS such as Oracle, PostgreSQL, MySQL, MS SQL, etc. |
Database Name | Description |
---|---|
WSO2_USER_DB | JDBC user store and authorization manager |
REGISTRY_DB | Shared database for config and governance registry mounts in the product's nodes |
REGISTRY_LOCAL1 | Local registry space in the manager node |
REGISTRY_LOCAL2 | Local registry space in the worker node |
...
- The
dataSource
you specify under the<dbConfig name="sharedregistry">
tag must match thejndiConfig
name specified in the master-datasources.xml file of the manager and worker. - The registry
mount path
is used to identify the type of registry. For example, ”/_system/config
” refers to configuration registry, and "/_system/governance
" refers to the governance registry. - The
dbconfig
entry enables you to identify the datasource you configured in themaster-datasources.xml
file. We use the unique namesharedregistry
to refer to that datasource entry. - The
remoteInstance
section refers to an external registry mount. We can specify the read-only/read-write nature of this instance as well as caching configurations and the registry root location. In case of a worker node, thereadOnly
property should betrue
, and in case of a manager node, this property should be set tofalse
. - Additionally, we must specify
cacheId
, which enables caching to function properly in the clustered environment. Note thatcacheId
is the same as the JDBC connection URL of the registry database. This value is thecacheId
of the remote instance. Here thecacheId
should be in the format of$database_username@$database_url
, where$database_username
is the username of the remote instance database and$database_url
is the remote instance database URL. ThiscacheID
is used to identify the cache it should look for when caching is enabled. In this case, the database we should connect to isREGISTRY_DB
, which is the database shared across all the master/workers nodes. You can identify that by looking in the mounting configurations, where the same datasource is being used. - You must define a unique name “id” for each remote instance, which is then referred to from mount configurations. In the above example, the unique ID for the remote instance is
instanceId
. - In each of the mounting configurations, we specify the actual mount path and target mount path. The
targetPath
can be any meaningful name. In this instance, it is/_system/asNodes
.
...