首页 > 数据库 > > griddb 4.5 体验
以下是griddb 4.5 的体验(基于虚拟机部署)
https://github.com/griddb/griddb/releases/download/v4.5.2/griddb-4.5.2-linux.x86_64.rpm
yum install -y griddb-4.5.2-linux.x86_64.rpm
默认在/var/lib/gridstore
export GS_HOME=$PWD
export GS_LOG=$PWD/log
gs_passwd admin
{ "dataStore":{"partitionNum":128,
"storeBlockSize":"64KB"
},
"cluster":{"clusterName":"defaultCluster",
"replicationNum":2,
"notificationInterval":"5s",
"heartbeatInterval":"5s",
"loadbalanceCheckInterval":"180s",
"notificationMember": [
{ "cluster": {"address":"xxxx", "port":10010}, "sync": {"address":"xxxx", "port":10020}, "system": {"address":"xxxxx", "port":10040}, "transaction": {"address":"xxxxx", "port":10001}, "sql": {"address":"xxxxx", "port":20001}}
]
},
"sync":{"timeoutInterval":"30s"
}
}
需要切换用户gsadm
su gsadm
gs_startnode -u admin/admin -w
gs_joincluster -u admin/admin –w -c defaultCluster
gs_stat -u admin/admin | grep Status
如果看到以下信息就是成功的
"clusterStatus": "MASTER",
"nodeStatus": "ACTIVE",
"partitionStatus": "NORMAL"
https://search.maven.org/artifact/com.github.griddb/gridstore-jdbc/4.5.0.1/jar
使用dbeaver 
CREATE TABLE users (
username STRING(131072),
userage INTEGER
);
INSERT INTO users
(username, userage)
VALUES('dalong', 1111);SELECT * from users

关于griddb sql 驱动链接的说明,可以参考源码的demo,或者官方文档
https://griddb.org/docs-en/manuals/GridDB_QuickStartGuide.html#Introduction
https://griddb.org/docs-en/manuals/GridDB_SQL_Reference.html
https://griddb.org/docs-en/manuals/GridDB_FeaturesReference.html
https://github.com/griddb/jdbc
https://griddb.org/docs-en/manuals/GridDB_JDBC_Driver_UserGuide.html
来源 https://www.cnblogs.com/rongfengliang/p/14072682.html
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69999831/viewspace-3156065/ ,如需转载,请注明出处,否则将追究法律责任。