写点什么

【YashanDB 知识库】ycm 托管数据库时,数据库非 OM 安装无法托管

作者:YashanDB
  • 2024-07-31
    广东
  • 本文字数:3473 字

    阅读完需:约 11 分钟

问题现象

ps -ef | grep yas 查看无 yasom 和 yasagent 进程,且在{数据库安装目录}/om/{数据库名称}的目录下没有 conf、data、log 等目录,确定数据库不是用 yasboot 安装,是用脚本安装的

问题的风险及影响

非 yasboot 安装,ycm 无法完成托管,无法监控

问题影响的版本

不涉及 ycm 的版本问题

问题发生原因

数据库版本太旧或安装数据库的人没有按照规范使用 yasboot 安装

解决方法及规避方式

将数据库先托管到 yasom 中,再托管到 ycm 中

问题分析和处理过程

(1)生成配置文件-- ip必须是本机ip,install-path不能和安装的数据库path重重复./bin/yasboot package config gen --cluster yasdb -u yashan -p Cod-2024 --ip 192.168.39.70 --install-path /home/yashan/yashandb/yasdb_yasom -t se  [yashan@KylinV10 yasdb_yasom]$ ./bin/yasboot package config gen --cluster yasdb -u yashan -p Cod-2024 --ip 192.168.39.70 --install-path /home/yashan/yashandb/yasdb_yasom -t se192.168.39.70  192.168.39.70:1688 is already used hostid   | group | node_type | node_name | listen_addr        | din_addr           | replication_addr   | data_path                                  -------------------------------------------------------------------------------------------------------------------------------------------------------- host0001 | dbg1  | db        | 1-1       | 192.168.39.70:1688 | 192.168.39.70:1689 | 192.168.39.70:1690 | /home/yashan/yashandb/yasdb_yasom/data/yasdb----------+-------+-----------+-----------+--------------------+--------------------+--------------------+----------------------------------------------  Generate config success    (2)安装yasom和yasagent./bin/yasboot package install -i yashandb-22.2.3.0-linux-aarch64.tar.gz -t hosts.toml    [yashan@KylinV10 yasdb_yasom]$ ./bin/yasboot package install -i yashandb-22.2.3.0-linux-aarch64.tar.gz -t hosts.tomlchecking install profile.toml...install version: yashandb 22.2.3.0update host to yasom...[yashan@KylinV10 yasdb_yasom]$ ps -ef | grep yasyashan   3945392       1  0 15:04 ?        00:00:25 yasdb open -D /home/yashan/yashandb/yasdb_dataroot     3950422 3950243  0 15:37 pts/1    00:00:00 su - yashanyashan   3950423 3950422  0 15:37 pts/1    00:00:00 -bashroot     3953443 3952376  0 15:49 pts/2    00:00:00 su - yashanyashan   3953444 3953443  0 15:49 pts/2    00:00:00 -bashyashan   3955488       1  0 16:05 ?        00:00:00 /home/yashan/yashandb/yasdb_yasom/bin/yasagent --init -c yasdb -l 192.168.39.70:1676 --host-id host0001 -k 564e9e581348c9ae -dyashan   3955503       1  0 16:06 ?        00:00:00 /home/yashan/yashandb/yasdb_yasom/bin/yasom --init -c yasdb -l 192.168.39.70:1675 -k 564e9e581348c9ae -dyashan   3955542 3950423  0 16:06 pts/1    00:00:00 ps -efyashan   3955543 3950423  0 16:06 pts/1    00:00:00 grep yas  (3)生成托管配置模版./bin/yasboot package config join-demo -t SE  [yashan@KylinV10 yasdb_yasom]$ ./bin/yasboot package config join-demo -t SE[yashan@KylinV10 yasdb_yasom]$ ll总用量 221716drwxrwxr-x 6 yashan yashan        70  5月  4  2023 admindrwxrwxr-x 3 yashan yashan       220  5月  4  2023 bindrwxrwxr-x 2 yashan yashan        30  4月 17 16:05 clientdrwxrwxr-x 3 yashan yashan       126  4月 17 16:06 conf-rw-rw-r-- 1 yashan yashan     10974  5月  4  2023 gitmoduleversion.dat-rw------- 1 yashan yashan       386  4月 17 16:05 hosts.tomldrwxrwxr-x 2 yashan yashan        65  5月  4  2023 includedrwxrwxr-x 3 yashan yashan        17  5月  4  2023 java-rw-r--r-- 1 yashan yashan       527  4月 17 16:15 join_demo.tomldrwxr-xr-x 2 yashan yashan      4096  5月  4  2023 libdrwxrwxr-x 2 yashan yashan         6  4月 17 16:06 logdrwxrwxr-x 3 yashan yashan        38  4月 17 15:50 omdrwxrwxr-x 2 yashan yashan       115  5月  4  2023 scripts-rw------- 1 yashan yashan       549  4月 17 16:05 yasdb.tomldrwxrwxr-x 3 yashan yashan        22  4月 17 15:48 yashandb-rw-r--r-- 1 yashan yashan 227004643  4月 17 15:46 yashandb-22.2.3.0-linux-aarch64.tar.gz  (4)修改托管配置模版[yashan@KylinV10 yasdb_yasom]$ cat join_demo.tomlcluster = "tt"sys_password = "yasdb_123"yas_type = "SE"  [primary_config]  manage_ip = "127.0.0.1"  yasdb_home = "/opt/yasom/yashandb/tt"  node_path = "/opt/yasom/yashandb/data/tt/db-1-1"  node_id = "1-1:1"  [[standby_config]]  manage_ip = "127.0.0.1"  yasdb_home = "/opt/yasom/yashandb/tt"  node_path = "/opt/yasom/yashandb/data/tt/db-1-2"  node_id = "1-2:1"  [[standby_config]]  manage_ip = "127.0.0.1"  yasdb_home = "/opt/yasom/yashandb/tt"  node_path = "/opt/yasom/yashandb/data/tt/db-1-3"  node_id = "1-3:1"  修改后:  [yashan@KylinV10 yasdb_yasom]$ cat join_demo.tomlcluster = "yasdb"sys_password = "yasdb_123"yas_type = "SE"  [primary_config]  manage_ip = "192.168.39.70"  yasdb_home = "/home/yashan/yashandb/yasdb_home"  node_path = "/home/yashan/yashandb/yasdb_data"  node_id = "1-1:1"    (5)执行托管./bin/yasboot cluster join -t SE --config join_demo.toml  [yashan@KylinV10 yasdb_yasom]$ ./bin/yasboot cluster join -t SE --config join_demo.tomlthe cluster status is as follow:|key         |value|------------+------|clusterName |yasdb|version     |22.2.3.0  the cluster status is as follow: hostid   | node_type | nodeid | pid     | instance_status | database_status | database_role | listen_address | data_path                      ------------------------------------------------------------------------------------------------------------------------------------------------- host0001 | db        | 1-1:1  | 3945392 | open            | normal          | primary       | 0.0.0.0:1688   | /home/yashan/yashandb/yasdb_data----------+-----------+--------+---------+-----------------+-----------------+---------------+----------------+----------------------------------Check successAre you sure you to add yasdb yasdb to yasom[yes/no]: yes type | uuid             | name             | hostid | index | status  | return_code | progress | cost------------------------------------------------------------------------------------------------------- task | eb0ecf155a0db5e6 | JoinYasdbCluster | -      | yasdb | SUCCESS | 0           | 100      | -  ------+------------------+------------------+--------+-------+---------+-------------+----------+------task completed, status: SUCCESS  (6)查看状态yashan@KylinV10 ~]$ yasboot cluster status -c yasdb -d hostid   | node_type | nodeid | pid     | instance_status | database_status | database_role | listen_address | data_path                             -------------------------------------------------------------------------------------------------------------------------------------------------------- host0001 | db        | 1-1:1  | 3945392 | open            | normal          | primary       | 0.0.0.0:1688   | /home/yashan/yashandb/data/yasdb/db-1-1----------+-----------+--------+---------+-----------------+-----------------+---------------+----------------+-----------------------------------------
复制代码


托管至 yasom 完成后,再按照流程托管至 ycm 即可

经验总结

安装数据库要按照规范安装,非规范安装会导致一系列问题

用户头像

YashanDB

关注

全自研国产新型大数据管理系统 2022-02-15 加入

还未添加个人简介

评论

发布
暂无评论
【YashanDB知识库】ycm托管数据库时,数据库非OM安装无法托管_yashandb_YashanDB_InfoQ写作社区