是否建议对身份、共享、bps、同意和同意使用不同的数据库?wsois 5.9.0 中的度量数据库? [英] Is it advised to use different database for identity,shared,bps,consent & metric db in wsois 5.9.0?

问题描述

是否建议对身份、共享、bps、同意和同意使用不同的数据库?wsois 5.9.0 中的度量数据库?如何配置同意和指标数据库?

Is it advised to use different database for identity,shared,bps,consent & metric db in wsois 5.9.0? how to configure consent and metric db?

我正在尝试这个配置:

[user_store]
type = "database"
TenantManager="org.wso2.carbon.user.core.tenant.JDBCTenantManager"
ReadOnly=false
ReadGroups=true
WriteGroups=true
scim_enabled = true                                                             #enabling scim apis

[database.user]
url = "jdbc:mysql://localhost:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"
driver = "com.mysql.jdbc.Driver"

[realm_manager]
data_source = "WSO2USER_DB"

[database.identity_db]
type = "mysql"
url= "jdbc:mysql://127.0.0.1:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"

[database.shared_db]
type = "mysql"
url= "jdbc:mysql://127.0.0.1:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"

[bps_database.config]
url = "jdbc:mysql://localhost:3306/bepl_db?useSSL=false"
username = "regadmin"
password = "regadmin"
driver = "com.mysql.jdbc.Driver"

[[datasource]]
id="WSO2CONSENT_DB"
url = "jdbc:mysql://localhost:3306/bepl_db?useSSL=false"
username = "regadmin"
password = "regadmin"
driver = "com.mysql.jdbc.Driver"
jmx_enable=false

[carbon_health_check]
enable= true

[keystore.primary]
name = "wso2carbon.jks"
password = "wso2carbon"

什么是正确的dbscripts导入顺序以及它们是否可以在不同的数据库中?

What is the correct dbscripts import order and whether they can be in different databases?

推荐答案

默认情况下，身份服务器带有嵌入式 H2 数据库.但 WSO2 建议将其更改为任何生产级数据库.通过参考您的配置，我可以看到您正在尝试将其更改为一个mysql数据库.

By default Identity server comes with an embedded H2 database. But WSO2 recommends changing this to any production level database. By refering to your configuration i can see that you are trying to change it to a mysql database.

您正在使用一个名为 regdb 的数据库作为身份和共享数据库.对于同意管理和 bps 数据库，您正在使用名为 bepl_db 的不同数据库.

You are using a database called regdb for identity and shared database. and for consent management and bps database you are using a different database called bepl_db.

因此，您必须按照 regdb 的文档执行以下数据库脚本.

Hence you will have to execute the following DB scrips as per the documentation for regdb.

     - <IS-HOME>/dbscripts/identity/mysql.sql
     - <IS-HOME>/dbscripts/identity/uma/mysql.sql
     - <IS-HOME>/dbscripts/mysql.sql

您必须按照 bepl_db 的文档执行以下数据库脚本.

you will have to execute the following DB scrips as per the documentation for bepl_db.

    - <IS-HOME>/dbscripts/consent/mysql.sql
    - <IS-HOME>/dbscripts/bps/bpel/create/mysql.sql

请注意，如果您没有集群环境，您也可以选择将同意数据存储在 IDENTITY_DB 中

Please note that if you do not have a clustered enviroment you also have the option of storing the consent data in IDENTITY_DB

如果是这样，您可以执行

If so you can execute the

    - <IS-HOME>/dbscripts/consent/mysql.sql 

脚本针对 regdb 而不是针对 bepl_db.并从 deployment.toml 中删除以下配置

script against the regdb not against the bepl_db. and remove the below config from deployment.toml

    [[datasource]]
    id="WSO2CONSENT_DB"
    url = "jdbc:mysql://localhost:3306/bepl_db?useSSL=false"
    username = "regadmin"
    password = "regadmin"
    driver = "com.mysql.jdbc.Driver"
    jmx_enable=false

此外，如果您需要使用工作流功能，则只需参考此文档.
https://is.docs.wso2.com/zh/5.9.0/setup/changeing-datasource-bpsds/

Also, you only need to refer this documentation if you have a requirement of using the workflow feature.
https://is.docs.wso2.com/en/5.9.0/setup/changing-datasource-bpsds/

如果你有集群设置，你只需要参考这个文档https://is.docs.wso2.com/en/5.9.0/setup/changeing-datasource-consent-management/

And you only need to refer this documentation if you have a clustered setup https://is.docs.wso2.com/en/5.9.0/setup/changing-datasource-consent-management/

否则只关注 https://is.docs.wso2.com/en/5.9.0/setup/changeing-to-mysql/文档，这就足够了.

Otherwise only follow https://is.docs.wso2.com/en/5.9.0/setup/changing-to-mysql/ documentation and that will be perfectly enough.

此外，metric db 自 5.9 起已弃用，因此不必担心将其数据指向不同的数据库.

Also, metric db is deprecating since 5.9 hence do not worry about pointing its data to a different database.

这篇关于是否建议对身份、共享、bps、同意和同意使用不同的数据库?wsois 5.9.0 中的度量数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！