海量数据库(Vastbase G100)集成说明
HAP 私有部署版默认使用的关系数据库是 MySQL,从 v7.5.4 开始已适配海量数据库,针对有信创要求的情况,用户可以选择使用此数据库替代 MySQL。
具体集成步骤如下:
-
部署海量数据库 G100 V2.2,要求:B 模式(MySQL 兼容模式),单机/主备模式
HAP 单机或精简集群 可选择 单机模式,标准或专业集群 可选择 主备模式
-
下载 HAP 数据库 初始化脚本
-
数据初始化
可使用 vsql 客户端连接工具连接海量数据库(部署完成后即可使用 vsql 命令)
执行初始化脚本(vastdata 数据目录、sql文件路径根据实际情况修改),命令执行时需输入密码
以:
/data/vastdata数据目录为例vsql -h /data/vastdata -U vastbase -d postgres -f /usr/local/init_vastbase/1_Database.sqlvsql -h /data/vastdata -U vastbase -d mdproject -f /usr/local/init_vastbase/2_MDProject.sqlvsql -h /data/vastdata -U vastbase -d mdstructure -f /usr/local/init_vastbase/3_MDStructure.sqlvsql -h /data/vastdata -U vastbase -d mdapplication -f /usr/local/init_vastbase/4_MDApplication.sqlvsql -h /data/vastdata -U vastbase -d mdcalendar -f /usr/local/init_vastbase/5_MDCalendar.sqlvsql -h /data/vastdata -U vastbase -d mdlog -f /usr/local/init_vastbase/6_MDLog.sqlvsql -h /data/vastdata -U vastbase -d mdproject -f /usr/local/init_vastbase/7_Data_MDProject.sqlvsql -h /data/vastdata -U vastbase -d mdapplication -f /usr/local/init_vastbase/8_Data_MDApplication.sql -
创建业务账号
使用 vastbase 账号连接数据库:
vsql -h /data/vastdata -U vastbase -d postgres创建账号(如:hap),将密码占位符替换为实际密码:
CREATE USER hap WITH PASSWORD '<HAP_PASSWORD>';在 vsql 中执行,授予 5 个业务库的读写权限:
\c mdprojectGRANT 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 publicGRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA publicGRANT USAGE, SELECT ON SEQUENCES TO hap;\c mdstructureGRANT 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 publicGRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA publicGRANT USAGE, SELECT ON SEQUENCES TO hap;\c mdapplicationGRANT 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 publicGRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA publicGRANT USAGE, SELECT ON SEQUENCES TO hap;\c mdcalendarGRANT 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 publicGRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA publicGRANT USAGE, SELECT ON SEQUENCES TO hap;\c mdlogGRANT 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 publicGRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO hap;ALTER DEFAULT PRIVILEGES FOR ROLE vastbase IN SCHEMA publicGRANT 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 -
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" -
完成系统初始化相关步骤即可