【SequoiaDB】6 巨杉数据库SequoiaDB操作数据

最新推荐文章于 2021-07-17 16:53:09 发布

Alen_Liu_SZ

最新推荐文章于 2021-07-17 16:53:09 发布

阅读量1.1k

点赞数

分类专栏：巨杉数据库文章标签： SequoiaDB存储引擎操作 MySQL实例操作

本文链接：https://blog.csdn.net/Alen_Liu_SZ/article/details/105233343

版权

Sequoia DB巨杉数据库作为分布式数据库，由数据库存储引擎与数据库实例两大模块组成。本篇分别从存储引擎和实例层面分别演示对数据的操作。

1 存储引擎上的数据操作

1.1 查看节点启动列表

[sdbadmin@sdbserver1 ~]$ sdblist -l -m local

Name SvcName Role PID GID NID PRY GroupName StartTime DBPath

sequoiadb 11810 coord 2294 2 2 Y SYSCoord 2020-03-31-20.11.27 /opt/sequoiadb/database/coord/11810/

sequoiadb 11830 data 2300 1001 1001 Y group2 2020-03-31-20.11.27 /opt/sequoiadb/database/data/11830/

sequoiadb 11820 data 2288 1000 1000 Y group1 2020-03-31-20.11.27 /opt/sequoiadb/database/data/11820/

sequoiadb 11800 catalog 2291 1 1 Y SYSCatalogGroup 2020-03-31-20.11.27 /opt/sequoiadb/database/catalog/11800/

sequoiadb 11840 data 2297 1002 1002 Y group3 2020-03-31-20.11.27 /opt/sequoiadb/database/data/11840/

Total: 5

1.2 查看集群拓扑结构

[sdbadmin@sdbserver1 ~]$ sdb

Welcome to SequoiaDB shell!

help() for help, Ctrl+c or quit to exit

> var db=new Sdb('localhost',11810)

Takes 0.006729s.

> db.list(SDB_LIST_GROUPS)

{

"Group": [

{

"dbpath": "/opt/sequoiadb/database/catalog/11800",

"HostName": "sdbserver1",

"Service": [

{

"Type": 0,

"Name": "11800"

},

{

"Type": 1,

"Name": "11801"

},

{

"Type": 2,

"Name": "11802"

},

{

"Type": 3,

"Name": "11803"

}

],

"NodeID": 1,

"Status": 1

}

],

"GroupID": 1,

"GroupName": "SYSCatalogGroup",

"PrimaryNode": 1,

"Role": 2,

"SecretID": 1732453446,

"Status": 1,

"Version": 1,

"_id": {

"$oid": "5e7eb555890e5fae02e44942"

}

}

{

"Group": [

{

"HostName": "sdbserver1",

"Status": 1,

"dbpath": "/opt/sequoiadb/database/coord/11810/",

"Service": [

{

"Type": 0,

"Name": "11810"

},

{

"Type": 1,

"Name": "11811"

},

{

"Type": 2,

"Name": "11812"

}

],

"NodeID": 2

}

],

"GroupID": 2,

"GroupName": "SYSCoord",

"Role": 1,

"SecretID": 73712140,

"Status": 1,

"Version": 2,

"_id": {

"$oid": "5e7eb55b890e5fae02e44946"

}

}

{

"Group": [

{

"HostName": "sdbserver1",

"Status": 1,

"dbpath": "/opt/sequoiadb/database/data/11820/",

"Service": [

{

"Type": 0,

"Name": "11820"

},

{

"Type": 1,

"Name": "11821"

},

{

"Type": 2,

"Name": "11822"

}

],

"NodeID": 1000

}

],

"GroupID": 1000,

"GroupName": "group1",

"PrimaryNode": 1000,

"Role": 0,

"SecretID": 875250555,

"Status": 1,

"Version": 3,

"_id": {

"$oid": "5e7eb55e890e5fae02e44947"

}

}

{

"Group": [

{

"HostName": "sdbserver1",

"Status": 1,

"dbpa