#共享集群配置文件
共享集群配置文件列示YashanDB服务端数据库相关信息，以及由多实例所组成的逻辑集群架构信息。
其中，与参数相关的配置信息分为如下两部分：
- 建库参数：这些参数用于控制创建数据库实例时的相关信息，在[[group]]实例组级别进行配置，即每个实例组内的多个实例创建一致的数据库。
- 配置参数：每个数据库实例的配置参数信息，在[[group.node]]实例级别进行配置。
# 单集群（redundancy为external）
示例： （yashandb.toml）
# 以下内容以实际展示结果为准
cluster = "yashandb" #安装后修改也不会生效，除非重新安装
create_simple_schema = false #为true部署完会执行示例的sql
sys_password = "encrypt_sys_password" # 加密后的超级管理员SYS用户的密码，不支持手动修改，若需重新指定密码，请在部署时指定--sys-password参数
uuid = "64f1568f4f6b033e58a015a833f0ad9e" #系统自动生成，不建议修改
mode = "YASHAN" # 语法模式，仅适用于单机部署
yas_type = "CE" #部署模式，安装后修改也不会生效，除非重新安装
[[group]]
group_type = "ce" #节点组类型，安装后修改也不会生效，除非重新安装
database_role = "primary" #数据库角色，主备集群专用，安装后修改也不会生效，除非重新安装
disk_found_path = "/dev/yfs" #磁盘发现路径，安装后修改也不会生效，除非重新安装
name = "ceg1" #节点组名称，安装后修改也不会生效，除非重新安装
[group.config] #可配置所有建库参数，不配置时采用默认值
CHARACTER_SET = "utf8"
ISARCHIVELOG = true
REDO_FILE_NUM = 4
REDO_FILE_SIZE = "128M"
[group.yfsconfig] #YFS配置参数，不配置时采用默认值
SHM_POOL_SIZE = "2G"
SYS_AREA_SIZE = "1G"
YFS_PACKET_SIZE = "1M"
[group.ycsconfig] # YCS配置参数，不配置时使用默认值
DISK_HB_KEEP_ALIVE = 60
LOG_LEVEL = "DEBUG"
LOG_NUMBER = 10
LOG_SIZE = "20M"
NETWORK_HB_TIMEOUT = 30
RESTART_INTERVAL = 30
RESTART_TIMES = 3
VOTING_FILE_NAME = "+SYSTEM/voting"
WAIT_STOP_FIN_TIME = 90
YCR_FILE_NAME = "+SYSTEM/ycr"
[[group.diskgroup]] # 数据盘组信息
au_size = "1M" # 分配磁盘空间时的AU大小
disk_size = "" # 指定可以由diskgroup进行管理的disk大小，可省略，则默认为该disk的总大小
name = "DG0" # 磁盘组的名称
redundancy = "EXTERNAL" # 磁盘组的冗余度
yfs_force_create = false # 强制格式化磁盘
[[group.diskgroup.failgroup]]
name = "DG0_0"
disk = ["/dev/yfs/data1", "/dev/yfs/data2"]
[[group.systemdiskgroup]] # 系统盘组信息，配置信息同diskgroup
au_size = "1M"
disk_size = ""
name = "SYSTEM"
redundancy = "EXTERNAL"
yfs_force_create = false
[[group.systemdiskgroup.failgroup]]
name = "SDG0_0"
disk = ["/dev/yfs/sys0"]
[[group.node]] #节点配置
data_path = "/data/yashan/yasdb_data" #为DATA目录，安装后修改也不会生效，除非重新安装
hostid = "host0001" #实例所在服务器标识，安装后修改也不会生效，除非重新安装
role = 1 #数据库主备角色，共享集群的实例没有主备概念，不支持修改
[group.node.config] #可配置所有数据库参数，不配置时采用默认值，安装后修改也不会生效，除非重新安装
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.1.2:1689"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.1.2:1788"
LISTEN_ADDR = "192.168.1.2:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
[[group.node]]
data_path = "/data/yashan/yasdb_data"
hostid = "host0002"
role = 2
[group.node.config]
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.1.3:1691"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.1.3:1788"
LISTEN_ADDR = "192.168.1.3:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
# 单集群（redundancy为normal）
示例： （yashandb.toml）
# 以下内容以实际展示结果为准
cluster = "yashandb" #安装后修改也不会生效，除非重新安装
create_simple_schema = false #为true部署完会执行示例的sql
sys_password = "encrypt_sys_password" # 加密后的超级管理员SYS用户的密码，不支持手动修改，若需重新指定密码，请在[deploy](../yasboot命令介绍/yasboot cluster.md#deploy)时指定--sys-password参数
uuid = "64f1568f4f6b033e58a015a833f0ad9e" #系统自动生成，不建议修改
mode = "YASHANDB" # 语法模式，仅适用于单机部署
yas_type = "CE" #部署模式，安装后修改也不会生效，除非重新安装
[[group]]
group_type = "ce" #节点组类型，安装后修改也不会生效，除非重新安装
database_role = "primary" #数据库角色，主备集群专用，安装后修改也不会生效，除非重新安装
disk_found_path = "/dev/yfs" #磁盘发现路径，安装后修改也不会生效，除非重新安装
name = "ceg1" #节点组名称，安装后修改也不会生效，除非重新安装
[group.config] #可配置所有建库参数，不配置时采用默认值
CHARACTER_SET = "utf8"
ISARCHIVELOG = true
REDO_FILE_NUM = 4
REDO_FILE_SIZE = "128M"
[group.yfsconfig] #YFS配置参数，不配置时采用默认值
SHM_POOL_SIZE = "2G"
SYS_AREA_SIZE = "1G"
YFS_PACKET_SIZE = "1M"
[group.ycsconfig] # YCS配置参数，不配置时使用默认值
DISK_HB_KEEP_ALIVE = 60
LOG_LEVEL = "DEBUG"
LOG_NUMBER = 10
LOG_SIZE = "20M"
NETWORK_HB_TIMEOUT = 30
RESTART_INTERVAL = 30
RESTART_TIMES = 3
VOTING_FILE_NAME = "+SYSTEM/voting"
WAIT_STOP_FIN_TIME = 90
YCR_FILE_NAME = "+SYSTEM/ycr"
[[group.diskgroup]] # 磁盘组信息
au_size = "1M" # 分配磁盘空间时的AU大小
disk_size = "" # 指定可以由diskgroup进行管理的disk大小，可省略，则默认为该disk的总大小
name = "DG0" # 磁盘组的名称
redundancy = "NORMAL" # 磁盘组的冗余度
yfs_force_create = false # 强制格式化磁盘
[[group.diskgroup.failgroup]]
name = "DG0_0"
disk = ["/dev/yfs/data0","/dev/yfs/data1"]
[[group.diskgroup.failgroup]]
name = "DG0_1"
disk = ["/dev/yfs/data2","/dev/yfs/data3"]
[[group.systemdiskgroup]] # 系统磁盘组信息，配置信息同diskgroup
au_size = "1M"
disk_size = ""
name = "SYSTEM"
redundancy = "NORMAL"
yfs_force_create = false
[[group.systemdiskgroup.failgroup]]
name = "SDG0_0"
disk = ["/dev/yfs/sys0"]
[[group.systemdiskgroup.failgroup]]
name = "SDG0_1"
disk = ["/dev/yfs/sys1"]
[[group.systemdiskgroup.failgroup]]
name = "SDG0_1"
disk = ["/dev/yfs/sys2"]
[[group.node]] #节点配置
data_path = "/data/yashan/yasdb_data" #为DATA目录，安装后修改也不会生效，除非重新安装
hostid = "host0001" #实例所在服务器标识，安装后修改也不会生效，除非重新安装
role = 1 #数据库主备角色，共享集群的实例没有主备概念，不支持修改
[group.node.config] #可配置所有数据库参数，不配置时采用默认值，安装后修改也不会生效，除非重新安装
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.1.2:1689"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.1.2:1788"
LISTEN_ADDR = "192.168.1.2:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
[[group.node]]
data_path = "/data/yashan/yasdb_data"
hostid = "host0002"
role = 2
[group.node.config]
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.1.3:1691"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.1.3:1788"
LISTEN_ADDR = "192.168.1.3:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
# 单集群（diskgroup的redundancy为high）
示例： （yashandb.toml）
# 以下内容以实际展示结果为准
cluster = "yashandb" #安装后修改也不会生效，除非重新安装
create_simple_schema = false #为true部署完会执行示例的sql
sys_password = "encrypt_sys_password" # 加密后的超级管理员SYS用户的密码，不支持手动修改，若需重新指定密码，请在[deploy](../yasboot命令介绍/yasboot cluster.md#deploy)时指定--sys-password参数
uuid = "64f1568f4f6b033e58a015a833f0ad9e" #系统自动生成，不建议修改
mode = "YASHANDB" # 语法模式，仅适用于单机部署
yas_type = "CE" #部署模式，安装后修改也不会生效，除非重新安装
[[group]]
group_type = "ce" #节点组类型，安装后修改也不会生效，除非重新安装
database_role = "primary" #数据库角色，主备集群专用，安装后修改也不会生效，除非重新安装
disk_found_path = "/dev/yfs" #磁盘发现路径，安装后修改也不会生效，除非重新安装
name = "ceg1" #节点组名称，安装后修改也不会生效，除非重新安装
[group.config] #可配置所有建库参数，不配置时采用默认值
CHARACTER_SET = "utf8"
ISARCHIVELOG = true
REDO_FILE_NUM = 4
REDO_FILE_SIZE = "128M"
[group.yfsconfig] #YFS配置参数，不配置时采用默认值
SHM_POOL_SIZE = "2G"
SYS_AREA_SIZE = "1G"
YFS_PACKET_SIZE = "1M"
[group.ycsconfig] # YCS配置参数，不配置时使用默认值
DISK_HB_KEEP_ALIVE = 60
LOG_LEVEL = "DEBUG"
LOG_NUMBER = 10
LOG_SIZE = "20M"
NETWORK_HB_TIMEOUT = 30
RESTART_INTERVAL = 30
RESTART_TIMES = 3
VOTING_FILE_NAME = "+SYSTEM/voting"
WAIT_STOP_FIN_TIME = 90
YCR_FILE_NAME = "+SYSTEM/ycr"
[[group.diskgroup]] # 磁盘组信息
au_size = "1M" # 分配磁盘空间时的AU大小
disk_size = "" # 指定可以由diskgroup进行管理的disk大小，可省略，则默认为该disk的总大小
name = "DG0" # 磁盘组的名称
redundancy = "HIGH" # 磁盘组的冗余度
yfs_force_create = false # 强制格式化磁盘
[[group.diskgroup.failgroup]]
name = "DG0_0"
disk = ["/dev/yfs/data0","/dev/yfs/data1"]
[[group.diskgroup.failgroup]]
name = "DG0_1"
disk = ["/dev/yfs/data2","/dev/yfs/data3"]
[[group.diskgroup.failgroup]]
name = "DG0_2"
disk = ["/dev/yfs/data4","/dev/yfs/data5"]
[[group.systemdiskgroup]] # 系统磁盘组信息，配置信息同diskgroup
au_size = "1M"
disk_size = ""
name = "SYSTEM"
redundancy = "HIGH"
yfs_force_create = false
[[group.systemdiskgroup.failgroup]]
name = "SDG0_0"
disk = ["/dev/yfs/sys0"]
[[group.systemdiskgroup.failgroup]]
name = "SDG0_1"
disk = ["/dev/yfs/sys1"]
[[group.systemdiskgroup.failgroup]]
name = "SDG0_2"
disk = ["/dev/yfs/sys2"]
[[group.systemdiskgroup.failgroup]]
name = "SDG0_3"
disk = ["/dev/yfs/sys3"]
[[group.systemdiskgroup.failgroup]]
name = "SDG0_4"
disk = ["/dev/yfs/sys4"]
[[group.node]] #节点配置
data_path = "/data/yashan/yasdb_data" #为DATA目录，安装后修改也不会生效，除非重新安装
hostid = "host0001" #实例所在服务器标识，安装后修改也不会生效，除非重新安装
role = 1 #数据库主备角色，共享集群的实例没有主备概念，不支持修改
[group.node.config] #可配置所有数据库参数，不配置时采用默认值，安装后修改也不会生效，除非重新安装
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.1.2:1689"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.1.2:1788"
LISTEN_ADDR = "192.168.1.2:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
[[group.node]]
data_path = "/data/yashan/yasdb_data"
hostid = "host0002"
role = 2
[group.node.config]
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.1.3:1691"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.1.3:1788"
LISTEN_ADDR = "192.168.1.3:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
# 主备集群（1主1备）
示例： （yashandb.toml）
# 以下内容以实际展示结果为准
cluster = "yashandb" # 安装后修改也不会生效，除非重新安装
create_simple_schema = false # 为true部署完会执行示例的SQL，若改为true需要在deploy时指定sys-password参数
uuid = "64f1568f4f6b033e58a015a833f0ad9e" # 系统自动生成，不建议修改
yas_type = "CE" # 部署模式，安装后修改也不会生效，除非重新安装
[[group]]
group_type = "ce" # 节点组类型，安装后修改也不会生效，除非重新安装
name = "ceg1" # 节点组名称，安装后修改也不会生效，除非重新安装
database_role = "primary" # 集群组的类型，primary表示主集群，standby表示备集群
disk_found_path = "/dev/yfs" # 磁盘发现路径
[group.config] # 可配置所有建库参数，不配置时采用默认值
CHARACTER_SET = "utf8"
ISARCHIVELOG = true
REDO_FILE_NUM = 4
REDO_FILE_SIZE = "128M"
[[group.diskgroup]]
au_size = "1M"
disk_size = ""
name = "DG0"
redundancy = "EXTERNAL"
yfs_force_create = false
[[group.diskgroup.failgroup]]
disk = ["/dev/yfs/data0"]
name = "DG0_0"
[[group.node]] # 节点配置
data_path = "/data/yashan/yasdb_data" # 为DATA目录，安装后修改也不会生效，除非重新安装
hostid = "host0001" # 服务器标识，安装后修改也不会生效，除非重新安装
role = 1 # 数据库主备角色，共享集群的实例没有主备概念，不支持修改
[group.node.config] # 可配置所有数据库参数，不配置时采用默认值，安装后修改也不会生效，除非重新安装
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.1.2:1689"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.1.2:1788"
LISTEN_ADDR = "192.168.1.2:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
[[group.node]]
data_path = "/data/yashan/yasdb_data"
hostid = "host0002"
role = 2
[group.node.config]
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.1.3:1689"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.1.3:1788"
LISTEN_ADDR = "192.168.1.3:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
[group.ycsconfig]
DISK_HB_KEEP_ALIVE = 60
LOG_LEVEL = "DEBUG"
LOG_NUMBER = 10
LOG_SIZE = "20M"
NETWORK_HB_TIMEOUT = 30
RESTART_INTERVAL = 30
RESTART_TIMES = 3
VOTING_FILE_NAME = "+SYSTEM/voting"
WAIT_STOP_FIN_TIME = 90
YCR_FILE_NAME = "+SYSTEM/ycr"
[group.yfsconfig]
FILE_SIZE = "100M"
SHM_POOL_SIZE = "2G"
SYS_AREA_SIZE = "1G"
[group.systemdiskgroup]
au_size = "1M"
disk_size = ""
name = "SYSTEM"
redundancy = "NORMAL"
yfs_force_create = true
[[group.systemdiskgroup.failgroup]]
disk = ["/dev/yfs/sys0"]
name = "SDG0_0"
[[group.systemdiskgroup.failgroup]]
disk = ["/dev/yfs/sys1"]
name = "SDG0_1"
[[group.systemdiskgroup.failgroup]]
disk = ["/dev/yfs/sys2"]
name = "SDG0_2"
[[group]]
group_type = "ce" # 节点组类型，安装后修改也不会生效，除非重新安装
name = "ceg2" # 节点组名称，安装后修改也不会生效，除非重新安装
database_role = "standby" # 集群组的类型，primary表示主集群，standby表示备集群
disk_found_path = "/dev/yfs2" # 磁盘发现路径
[group.config] # 可配置所有建库参数，不配置时采用默认值
CHARACTER_SET = "utf8"
ISARCHIVELOG = true
REDO_FILE_NUM = 4
REDO_FILE_SIZE = "128M"
[[group.diskgroup]]
au_size = "1M"
disk_size = ""
name = "DG0"
redundancy = "EXTERNAL"
yfs_force_create = false
[[group.diskgroup.failgroup]]
disk = ["/dev/yfs2/data0"]
name = "DG0_0"
[[group.node]] # 节点配置
data_path = "/data/yashan/yasdb_data" # 为DATA目录，安装后修改也不会生效，除非重新安装
hostid = "host0001" # 服务器标识，安装后修改也不会生效，除非重新安装
role = 1 # 数据库主备角色，共享集群的实例没有主备概念，不支持修改
[group.node.config] # 可配置所有数据库参数，不配置时采用默认值，安装后修改也不会生效，除非重新安装
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.10.4:1689"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.10.4:1788"
LISTEN_ADDR = "192.168.10.4:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
[[group.node]]
data_path = "/data/yashan/yasdb_data"
hostid = "host0002"
role = 2
[group.node.config]
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.10.5:1689"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.10.5:1788"
LISTEN_ADDR = "192.168.10.5:1688"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/data/yashan/log"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/data/yashan/log"
SQL_POOL_PARTS = 8
[group.ycsconfig]
DISK_HB_KEEP_ALIVE = 60
LOG_LEVEL = "DEBUG"
LOG_NUMBER = 10
LOG_SIZE = "20M"
NETWORK_HB_TIMEOUT = 30
RESTART_INTERVAL = 30
RESTART_TIMES = 3
VOTING_FILE_NAME = "+SYSTEM/voting"
WAIT_STOP_FIN_TIME = 90
YCR_FILE_NAME = "+SYSTEM/ycr"
[group.yfsconfig]
FILE_SIZE = "100M"
SHM_POOL_SIZE = "2G"
SYS_AREA_SIZE = "1G"
[group.systemdiskgroup]
au_size = "1M"
disk_size = ""
name = "SYSTEM"
redundancy = "NORMAL"
yfs_force_create = true
[[group.systemdiskgroup.failgroup]]
disk = ["/dev/yfs2/sys0"]
name = "SDG0_0"
[[group.systemdiskgroup.failgroup]]
disk = ["/dev/yfs2/sys1"]
name = "SDG0_1"
[[group.systemdiskgroup.failgroup]]
disk = ["/dev/yfs2/sys2"]
name = "SDG0_2"
下载文档
复制链接
