Home

ONgDB集群数据增量备份方案

Here’s the table of contents: 修改集群配置 远程全量热备命令 远程增量热备命令 数据恢复脚本 参考文档 修改集群配置 # Enable online backups to be taken from this database. dbms.backup.enabled=true # By default the backup service will only listen on localhost. # To enable remote backups you will have to bind to an external # network interface (e.g. 0.0.0.0 for all interfaces...

Read more

后台执行CQL脚本

Here’s the table of contents: 执行单条CQL test.sh批量执行脚本 执行单条CQL cat /ongdb_data/ongdb-enterprise-3.5.22/test.cql | nohup /ongdb_data/ongdb-enterprise-3.5.22/bin/cypher-shell -a bolt://10.20.7.181:7687 -u ongdb -p testlab%pro >>console.log 2>&1 & test.sh批量执行脚本 #!/bin/bash # 定义CQL文件名称 array=(test1 test2 test3 test4 test5 test6...

Read more

ONgDB批量导入CSV文件

Here’s the table of contents: 版本 cypher-shell执行批量提交的脚本 browser中执行批量提交的CYPHER 版本 ongdb-enterprise-3.5.22 cypher-shell执行批量提交的脚本 USING PERIODIC COMMIT 10000 LOAD CSV FROM 'file:/xbe' AS line WITH TOINT(line[1]) AS ybId,TOINT(line[2]) AS kwId,apoc.convert.toFloat(line[3]) AS weight MATCH (yb:研报)-[r:包含]->(kw:关键词) WHERE ID(yb)=ybId AND I...

Read more

Linux文件切分

Here’s the table of contents: 切分【分割】【文件】 切分【分割】【文件】 查看文件行数 wc -l filename split -l 5000(行数) -a 5(增加文件名上限) /file /new_file_prefix split -6 README #将README文件每六行分割成一个文件

Read more

公司主数据最大连通图分析

Here’s the table of contents: 数据量统计 最大连通图分析脚本 数据量统计 MATCH (n:PREPCODE) RETURN COUNT(*) 465927292 MATCH (n:PREPCODE)-->() RETURN COUNT(*) 965345392 最大连通图分析脚本 CALL algo.unionFind.stream('PREPCODE',NULL,{concurrency:8}) YIELD nodeId,setId WITH nodeId,setId WITH COLLECT(nodeId) AS nodeIdList,setId WITH SIZE(nodeIdList) AS size,nodeIdLis...

Read more

Python发起HTTP请求

Here’s the table of contents: Python - Requests Python - Requests import requests url = "http://10.20.13.200/db/data/transaction/commit" payload="{\r\n \"statements\": [\r\n {\r\n \"statement\": \"CALL apoc.load.jdbc('jdbc:oracle:thin:nfdp/testlabgogo@nfdpdb-sync-prod.crkldnwly6ki.rds.cn-north-1.alibaba.com.cn:1521/OR...

Read more

Shell发起HTTP请求

Here’s the table of contents: Shell - Httppie Shell - wget Shell - curl Shell - Httppie printf '{ "statements": [ { "statement": "CALL apoc.load.jdbc('\''jdbc:oracle:thin:nfdp/testlabgogo@nfdpdb-sync-prod.crkldnwly6ki.rds.cn-north-1.alibaba.com.cn:1521/ORCL'\'', '\''SELECT FUND_HCODE AS \\"hcode\\",CNAME AS \\"cn...

Read more

基金产品名称索引设计

Here’s the table of contents: 设计索引 用CYPHER从MySQL拿数据写入ES 设计索引 { "settings": { "number_of_replicas": 1, "number_of_shards": 3, "refresh_interval": "60s", "translog": { "flush_threshold_size": "1.6gb" }, "merge": { "scheduler": { "max_thread_count": "1" } }, "index": { "routin...

Read more