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...
后台执行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...
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...
公司主数据最大连通图分析
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...
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...
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...
基金产品名称索引设计
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...
122 post articles, 16 pages.