跳到主要内容

海量数据库(Vastbase G100)集成说明

HAP 私有部署版默认使用的关系数据库是 MySQL,从 v7.5.4 开始已适配海量数据库,针对有信创要求的情况,用户可以选择使用此数据库替代 MySQL。

具体集成步骤如下:

  1. 部署海量数据库 G100 V2.2,要求:B 模式(MySQL 兼容模式),单机/主备模式

    HAP 单机或精简集群 可选择 单机模式,标准或专业集群 可选择 主备模式

  2. 下载 HAP 数据库 初始化脚本

  3. 数据初始化

    可使用 vsql 客户端连接工具连接海量数据库(部署完成后即可使用 vsql 命令)

    执行初始化脚本(vastdata 数据目录、sql文件路径根据实际情况修改),命令执行时需输入密码

    以:/data/vastdata 数据目录为例

    vsql -h /data/vastdata -U vastbase -d postgres -f /usr/local/init_vastbase/1_Database.sql
    vsql -h /data/vastdata -U vastbase -d mdproject -f /usr/local/init_vastbase/2_MDProject.sql
    vsql -h /data/vastdata -U vastbase -d mdstructure -f /usr/local/init_vastbase/3_MDStructure.sql
    vsql -h /data/vastdata -U vastbase -d mdapplication -f /usr/local/init_vastbase/4_MDApplication.sql
    vsql -h /data/vastdata -U vastbase -d mdcalendar -f /usr/local/init_vastbase/5_MDCalendar.sql
    vsql -h /data/vastdata -U vastbase -d mdlog -f /usr/local/init_vastbase/6_MDLog.sql
    vsql -h /data/vastdata -U vastbase -d mdproject -f /usr/local/init_vastbase/7_Data_MDProject.sql
    vsql -h /data/vastdata -U vastbase -d mdapplication -f /usr/local/init_vastbase/8_Data_MDApplication.sql
  4. 创建业务账号

    使用 vastbase 账号连接数据库:

    vsql -h /data/vastdata -U vastbase -d postgres

    创建账号(如:hap),将密码占位符替换为实际密码:

    CREATE USER hap WITH PASSWORD '<HAP_PASSWORD>';

    在 vsql 中执行,授予 5 个业务库的读写权限:

    \c mdproject
    GRANT CONNECT ON DATABASE mdproject TO hap;
    GRANT USAGE ON SCHEMA public TO hap;
    GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO hap;
    GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO hap;

    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;
    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT USAGE, SELECT ON SEQUENCES TO hap;

    \c mdstructure
    GRANT CONNECT ON DATABASE mdstructure TO hap;
    GRANT USAGE ON SCHEMA public TO hap;
    GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO hap;
    GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO hap;

    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;
    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT USAGE, SELECT ON SEQUENCES TO hap;

    \c mdapplication
    GRANT CONNECT ON DATABASE mdapplication TO hap;
    GRANT USAGE ON SCHEMA public TO hap;
    GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO hap;
    GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO hap;

    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;
    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT USAGE, SELECT ON SEQUENCES TO hap;

    \c mdcalendar
    GRANT CONNECT ON DATABASE mdcalendar TO hap;
    GRANT USAGE ON SCHEMA public TO hap;
    GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO hap;
    GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO hap;

    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;
    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT USAGE, SELECT ON SEQUENCES TO hap;

    \c mdlog
    GRANT CONNECT ON DATABASE mdlog TO hap;
    GRANT USAGE ON SCHEMA public TO hap;
    GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO hap;
    GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO hap;

    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;
    ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA public
    GRANT USAGE, SELECT ON SEQUENCES TO hap;

    \q

    允许远程连接 编辑服务器上的 /data/vastdata/pg_hba.conf,在现有 reject 规则之前添加:

    hostssl mdproject,mdstructure,mdapplication,mdcalendar,mdlog hap <客户端或应用服务器来源IP>/32 sha256

    将 <客户端或应用服务器来源IP> 替换为连接数据库时使用的实际来源 IP。/32 表示只允许这一个 IP。

    使用 vastbase 系统用户重新加载配置,无需重启:

    vb_ctl -D /data/vastdata reload
  5. HAP 服务初始化

    在服务初始化之前需要先添加以下环境变量(连接参数值根据实际值修改):

    ENV_RDB_TYPE: "12"
    ENV_RDB_URI_MDPROJECT: "Host=127.0.0.1;Port=5432;Username=hap;Password=******;Database=mdproject"
    ENV_RDB_URI_MDLOG: "Host=127.0.0.1;Port=5432;Username=hap;Password=******;Database=mdlog"
    ENV_RDB_URI_MDSTRUCTURE: "Host=127.0.0.1;Port=5432;Username=hap;Password=******;Database=mdstructure"
    ENV_RDB_URI_MDCALENDAR: "Host=127.0.0.1;Port=5432;Username=hap;Password=******;Database=mdcalendar"
    ENV_RDB_URI_MDAPPLICATION: "Host=127.0.0.1;Port=5432;Username=hap;Password=******;Database=mdapplication"
    ENV_STANDALONE_DISABLE_SERVICES: "mysql"
  6. 完成系统初始化相关步骤即可