sdb-deploy setup-cluster 이용

license: <LICENSE> [Required to bootstrap Master Aggregator] high_availability: <true | false> memsql_server_version: <the version of memsql you want to install (7.8+)> memsql_server_file_path:<path to the downloaded memsql server file> package_type: <deb|rpm|tar> [Required if multiple package present] root_password: <default password to be used for all nodes> optimize: <true | false> optimize_config: memory_percentage: <percentage of memory you want memsql to use> no_numa: <true|false> hosts: - hostname: <host-name> [Required] localhost: <true | false> memsqlctl_path: <path to memsqlctl> [ADVANCED] memsqlctl_config_path:<path to memsqlctl config> [ADVANCED] tar_install_dir: <path to tar install dir> [ADVANCED] tar_install_state: <path to tar install state> [ADVANCED] ssh: [Required for remote Hosts] host: <ssh host name> port: <ssh port> user: <ssh user> private_key: <path to your identity key> nodes: - register: <true | false> role: <Unknown | Master | Leaf | Aggregator> (case sensitive) [Required] availability_group: <availability group> no_start: <true | false> variables: secure_file_priv: <location> config: auditlogsdir: <path to auditlogs directory> [ADVANCED] baseinstalldir: <path to base install directory> [ADVANCED] configpath: <path to configuration path> [ADVANCED][Required if register is true] datadir: <path to data directory> [ADVANCED] disable_auto_restart: <true | false> password: <password> plancachedir: <path to plancache directory> [ADVANCED] port: <port number> [Required for node creation] tracelogsdir: <path to tracelogs directory> [ADVANCED] bind_address: <bind address> [ADVANCED]

vi setup-cluster.yaml license: <license-key> package_type: rpm memsql_server_version:/home/memsql/singlestoredb-server7.8.2-8c7b918527.x86_64.rpm root_password: <dbpw> optimize: true hosts: - hostname: 10.41.8.45 localhost: true nodes: - role: Master config: port: 3306 auditlogsdir: /data/memsql/MA/auditlogs/ datadir: /data/memsql/MA/data plancachedir: /data/memsql/MA/plancache tracelogsdir: /data/memsql/MA/tracelogs - role: Leaf config: port: 3308 auditlogsdir: /data/memsql/LF1/auditlogs/ datadir: /data/memsql/LF1/data plancachedir: /data/memsql/LF1/plancache tracelogsdir: /data/memsql/LF1/tracelogs

vi setup-cluster.yaml license: <license-key> high_availability: true package_type: rpm memsql_server_file_path: <server 7.8.2 path> hosts: - hostname: <hostname1> localhost: true nodes: - role: Master config: password: <dbpw> port: 3306 - hostname: <CA host name or IP> ssh: host: <ssh host name or IP> private_key: /home/<user>/.ssh/id_rsa nodes: - role: Aggregator config: password: <dbpw> - hostname: <LF1 host name or IP> ssh: host: <ssh host name or IP> private_key: /home/<user>/.ssh/id_rsa nodes: - role: Leaf availability_group: 1 config: password: <dbpw> - hostname: <LF2 host name or IP> ssh: host: <ssh host name or IP> private_key: /home/<user>/.ssh/id_rsa nodes: - role: Leaf availability_group: 2 config: password: <dbpw> - hostname: <LF3 host name or IP> ssh: host: <ssh host name or IP> private_key: /home/<user>/.ssh/id_rsa nodes: - role: Leaf availability_group: 1 config: password: <dbpw> - hostname: <LF4 host name or IP> ssh: host: <ssh host name or IP> private_key: /home/<user>/.ssh/id_rsa nodes: - role: Leaf availability_group: 2 config: password: <dbpw>

sdb-deploy setup-cluster ./setup-cluster.yaml # 작성한 YAML 파일