#分布式集群配置文件

分布式集群配置文件列示YashanDB服务端数据库相关信息,以及由多实例所组成的逻辑集群架构信息。

其中,与参数相关的配置信息分为如下两部分:

  • 建库参数:这些参数用于控制创建数据库实例时的相关信息,在[[group]]实例组级别进行配置,即每个实例组内的多个实例创建一致的数据库。
  • 配置参数:每个数据库实例的配置参数信息,在[[group.node]]实例级别进行配置。

示例: (yashandb.toml)

# yashandb.toml文件,具体信息以实际展示结果为准

cluster = "yashandb"	# 安装后修改也不会生效,除非重新安装
create_simple_schema = false	# 为true部署完会执行示例的SQL,若改为true需要在deploy时指定sys-password参数
uuid = "64f1568f4f6b033e58a015a833f0ad9e"	# 系统自动生成,不建议修改
yas_type = "CE"	# 部署模式,安装后修改也不会生效,除非重新安装

[[group]]
  database_role = "primary"  # 集群组的类型,primary表示主集群
  disk_found_path = "/dev"  # 磁盘发现路径
  group_type = "ce" # 节点组类型,安装后修改也不会生效,除非重新安装
  name = "ceg1" # 节点组名称,安装后修改也不会生效,除非重新安装
  [group.config]    # 可配置所有建库参数,不配置时采用默认值
    CHARACTER_SET = "utf8"
    ISARCHIVELOG = true
    REDO_FILE_NUM = 4
    REDO_FILE_SIZE = "128M"

  [[group.diskgroup]]  # 数据盘的磁盘组配置
    au_size = "1M"     # 分配磁盘空间时的AU大小
    disk_size = ""     # 指定可以由diskgroup进行管理的disk大小,可省略,则默认为该disk的总大小
    name = "DG0"        # 磁盘组的名称
    redundancy = "EXTERNAL"  # 磁盘组的冗余度
    yfs_force_create = false # 是否强制格式化磁盘

    [[group.diskgroup.failgroup]]  # 数据盘故障组配置
      disk = ["host0001.data0", "host0002.data1", "host0003.data2"] 
      name = "DG0_0"

  [[group.node]]    # 节点配置
    data_path = "/data/yashan/yasdb_data"   # DATA目录,安装后修改也不会生效,除非重新安装
    hostid = "host0001" # 服务器标识,安装后修改也不会生效,除非重新安装
    role = 1    # 共享集群的实例没有主备概念,该参数无实际含义,不支持修改
    [group.node.config]  # 可配置所有数据库参数,不配置时采用默认值,安装后修改也不会生效,除非重新安装
      ARCH_CLEAN_IGNORE_MODE = "BACKUP"
      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]
      ARCH_CLEAN_IGNORE_MODE = "BACKUP"
      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.systemdiskgroup] # 系统盘组配置
    au_size = "1M"
    disk_size = ""
    name = "SYSTEM"
    redundancy = "NORMAL"  # 磁盘冗余度,根据指定的系统盘数量自动设置
    yfs_force_create = true

    [[group.systemdiskgroup.failgroup]]
      disk = ["host0001.sys0"]
      name = "SDG0_0"

    [[group.systemdiskgroup.failgroup]]
      disk = ["host0001.sys1"]
      name = "SDG0_1"

    [[group.systemdiskgroup.failgroup]]
      disk = ["host0001.sys2"]
      name = "SDG0_2"

  [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.yfsconfig]  # YFS配置参数,不配置时采用默认值
    SHM_POOL_SIZE = "2G"
    SYS_AREA_SIZE = "1G"
    YFS_PACKET_SIZE = "1M"
pdf-btn 下载文档 copy-btn 复制链接
edit-icon
反馈
coperate-icon
coperate
合作
communication-icon
communicate
交流