DataSophon组件之Doris升级

1.安装包准备

1>.安装包下载

链接：https://pan.baidu.com/s/1Bso4lLHVqPf1NNC7sjTiGg 
提取码：yyds 

2>.安装包上传

cd  /opt/datasophon/DDP/packages

    doris-2.0.1.tar.gz

    doris-2.0.1.tar.gz.md5

2.删除已装的组件包Doris(ALL)

rm -rf  /opt/datasophon/doris*

rm -rf /data/be/storage

目录配置如下:

3.修改service_ddl.json

cd   /opt/datasophon/DDP/packages/datasophon-manager-1.1.3/conf/meta/DDP-1.1.3/

vi   /opt/datasophon/DDP/packages/datasophon-manager-1.1.3/conf/meta/DDP-1.1.3/DORIS/service_ddl.json

注意:datasophon-manager-1.1.3 为当前的datasohon安装版本 

4.重启manager服务

1>重启服务

rm -rf   /opt/datasophon/DDP/packages/datasophon-manager-1.1.3/logs/*

/opt/datasophon/DDP/packages/datasophon-manager-1.1.3/bin/datasophon-api.sh restart api

cd /opt/datasophon/DDP/packages/datasophon-manager-1.1.3/logs

  

2>查看相应的表配置数据

   select * from t_ddh_frame_service;

   select * from t_ddh_frame_service_role;

5.重新安装服务

安装注意:

1>先设置max_map_count(ALL)

     sysctl -w vm.max_map_count=2000000

 2>注意FE和BE优先网段修改

     

3>异常处理

如果报上述错误，需要删除/opt/datasophon/doris-2.0.1/fe/doris-meta下面的数据

cd /opt/datasophon/doris-2.0.1/fe/doris-meta

rm -rf  /opt/datasophon/doris-2.0.1/fe/doris-meta/*

6.测试验证

1>用mysql客户端连接doris

mysql -h cdh02 -P 9030 -uroot -p

2>增加BACKEND

ALTER SYSTEM ADD BACKEND "cdh01:9050"

ALTER SYSTEM ADD BACKEND "cdh02:9050"

ALTER SYSTEM ADD BACKEND "cdh03:9050"

3>查看backend

SHOW PROC '/backends';

show proc '/frontends'; #查看FE节点状态

show proc '/backends'; #查看BE节点状态

show proc '/brokers'; #查看Broker节点状态

4>删除BACKEND

ALTER SYSTEM DECOMMISSION BACKEND  "chd02:9050";

   

5>创建 test 用户

create user 'test' identified by 'test';

6>创建数据库

create database test_db;

7>用户授权

grant all on test_db to test;

8>选择数据库

use test_db;

 

9>新建测试表

CREATE TABLE `ads_index_table` (

  `index_name` varchar(1024) NOT NULL,

  `index_time` varchar(8) NOT NULL,

  `index_value` double NULL,

  `update_time` varchar(32) NULL

) ENGINE=OLAP

UNIQUE KEY(`index_name`, `index_time`)

COMMENT 'OLAP'

DISTRIBUTED BY HASH(`index_time`) BUCKETS 32

PROPERTIES (

"replication_allocation" = "tag.location.default: 3",

"in_memory" = "false",

"storage_format" = "V2",

"enable_unique_key_merge_on_write" = "true",

"disable_auto_compaction" = "false"

);

10>插入表数据

insert into  ads_index_table  values (1,1,1,1);

11>查询表数据

select * from ads_index_table ;

12>退出终端

  quit