Step 1:安装JDK
1.1上传JDK安装包文件
/usr/local/src/ jdk-8u162-linux-x64.tar.gz
1.2.解压JDK安装包文件
tar -zxvf jdk-8u162-linux-x64.tar.gz
1.3.配置Java环境变量
[root@master jdk1.8.0_162]# vim /root/.bash_profile
JAVA_HOME=/usr/local/src/jdk1.8.0_162
export JAVA_HOME
PATH=$JAVA_HOME/bin:$JAVA_HOME/sbin:$PATH
export PATH
1.4.测试JDK是否安装成功
[root@master jdk1.8.0_162]# java -version
java version "1.8.0_162"
Java(TM) SE Runtime Environment (build 1.8.0_162-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.162-b12, mixed mode)
Step 2:安装MySQL
2.1安装mysql客户端: [root@bigdata ~]# yum -y install mysql
2.2安装mysql服务器端: [root@bigdata ~]# yum -y install mysql-server
如果安装mysql-server时提示“没有可用包”,解决办法:
2.2.1.下载mysql的repo源:
[root@localhost ~]# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2.2.2.安装mysql的repo源
[root@localhost ~]# rpm -ivh mysql-community-release-el7-5.noarch.rpm
2.2.3.查看找到的mysql安装源
[root@localhost ~]# ls -1 /etc/yum.repos.d/mysql-community*
/etc/yum.repos.d/mysql-community.repo
/etc/yum.repos.d/mysql-community-source.repo
2.2.4.重新安装mysql-server
[root@master ~]# yum install -y mysql-server
2.3启动mysql服务器:
[root@bigdata ~]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
根据提示也可以使用命令:systemctl start mysqld.service
2.4设置mysql管理员密码:
[root@master~]# mysqladmin -uroot password 123456
Warning: Using a password on the command line interface can be insecure.
2.5测试登录是否成功:
[root@bigdata ~]# mysql -uroot -p123456
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.39 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
2.6授权root用户:
mysql> grant all privileges on *.* to root@'%' identified by '123456' with grant option;
Query OK, 0 rows affected (0.06 sec)
mysql> grant all privileges on *.* to root@'主机名' identified by '123456' with grant option;
Query OK, 0 rows affected (0.06 sec)
mysql> grant all privileges on *.* to root@'localhost' identified by '123456' with grant option;
Query OK, 0 rows affected (0.06 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
*.*:指的是所有数据库
Step 3:StarRocks部署
1)下载安装包,并重命名
wget https://www.starrocks.com/zh-CN/download/request-download/4
mv 4 StarRocks-1.19.1.tar.gz
2)解压tar包
tar -zxvf StarRocks-1.19.1.tar.gz -C /usr/local/
3)部署FE,修改配置文件,添加jvm参数
cd /usr/local/StarRocks-1.19.1/fe/conf/
]# vim fe.conf
JAVA_OPTS = "-Xmx800m -XX:+UseMembar -XX:SurvivorRatio=8 -XX:MaxTenuringThreshold=7 -XX:+PrintGCDateStamps -XX:+PrintGCDetails -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled -XX:-CMSParallelRemarkEnabled -XX:CMSInitiatingOccupancyFraction=80 -XX:SoftRefLRUPolicyMSPerMB=0 -Xloggc:$STARROCKS_HOME/log/fe.gc.log"
4)创建元数据目录
]# cd ..
]# mkdir -p meta
5)分发给slave1,slave2
]# scp -P 9528 -rp StarRocks-1.19.1 root@172.16.0.6:/usr/local/
]# scp -P 9528 -rp StarRocks-1.19.1 root@172.16.0.7:/usr/local/
6)启动172.16.0.5 FE节点
]# bin/start_fe.sh --daemon
7)启动mysql客户端,访问FE,查看FE状况
]# mysql -h hadoop101 -uroot -P9030
mysql> SHOW PROC '/frontends'\G
*************************** 1\. row ***************************
Name: 172.16.0.5_9010_1644289106240
IP: 172.16.0.5
HostName: iZbp1etb69sqxcvg7mwz7tZ
EditLogPort: 9010
HttpPort: 8030
QueryPort: 9030
RpcPort: 9020
Role: FOLLOWER
IsMaster: true
ClusterId: 844004438
Join: true
Alive: true
ReplayedJournalId: 4451
LastHeartbeat: 2022-02-08 15:05:46
IsHelper: true
ErrMsg:
1 row in set (0.05 sec)
8)添加其他FE节点,角色也分为FOLLOWER,OBSERVER
mysql> alter system add follower "bigdata102:9010";
Query OK, 0 rows affected (0.02 sec)
mysql>alter system add observer "bigdata103:9010";
Query OK, 0 rows affected (0.01 sec)
9)启动172.16.0.6,172.16.0.7 FE节点,第一次启动需指定--helper参数,后续再启动无需指定此参数
]# ./bin/start_fe.sh --helper bigdata101:9010 --daemon
]# ./bin/start_fe.sh --helper bigdata101:9010 --daemon
10)全部启动完毕后,再使用mysql客户端查看FE的状况,alive全显示true则无问题
mysql> show proc '/frontends'\G
*************************** 1\. row ***************************
Name: 172.16.0.5_9010_1644289106240
IP: 172.16.0.5
HostName: iZbp1etb69sqxcvg7mwz7tZ
EditLogPort: 9010
HttpPort: 8030
QueryPort: 9030
RpcPort: 9020
Role: FOLLOWER
IsMaster: true
ClusterId: 844004438
Join: true
Alive: true
ReplayedJournalId: 4530
LastHeartbeat: 2022-02-08 15:10:02
IsHelper: true
ErrMsg:
*************************** 2\. row ***************************
Name: 172.16.0.7_9010_1644304020469
IP: 172.16.0.7
HostName: 172.16.0.7
EditLogPort: 9010
HttpPort: 8030
QueryPort: 9030
RpcPort: 9020
Role: OBSERVER
IsMaster: false
ClusterId: 844004438
Join: true
Alive: true
ReplayedJournalId: 4529
LastHeartbeat: 2022-02-08 15:10:02
IsHelper: false
ErrMsg:
*************************** 3\. row ***************************
Name: 172.16.0.6_9010_1644304006306
IP: 172.16.0.6
HostName: 172.16.0.6
EditLogPort: 9010
HttpPort: 8030
QueryPort: 9030
RpcPort: 9020
Role: FOLLOWER
IsMaster: false
ClusterId: 844004438
Join: true
Alive: true
ReplayedJournalId: 4529
LastHeartbeat: 2022-02-08 15:10:02
IsHelper: true
ErrMsg:
3 rows in set (0.05 sec)
11) 部署BE,用户可以使用命令直接将BE添加到集群中,一般至少布置3个BE,每个BE实例添加步骤相同
]# cd ../be/
[root@HZ-2H0-BI-DEV-5 be]# mkdir -p storage
12)使用mysql客户端添加172.16.0.5对应be节点
mysql> ALTER SYSTEM ADD BACKEND "bigdata101:9050";
13)添加完毕后,启动172.16.0.5 BE节点
]# bin/start_be.sh --daemon
14)查看BE状况,也是同样alive为true是正常运行
mysql> show proc '/backends'\G
*************************** 1\. row ***************************
BackendId: 10003
Cluster: default_cluster
IP: 172.16.0.5
HostName: iZbp1etb69sqxcvg7mwz7tZ
HeartbeatPort: 9050
BePort: 9060
HttpPort: 8040
BrpcPort: 8060
LastStartTime: 2022-02-08 15:16:43
LastHeartbeat: 2022-02-08 15:17:48
Alive: true
SystemDecommissioned: false
ClusterDecommissioned: false
TabletNum: 10
DataUsedCapacity: .000
AvailCapacity: 50.842 GB
TotalCapacity: 58.933 GB
UsedPct: 13.73 %
MaxDiskUsedPct: 13.73 %
ErrMsg:
Version: 1.19.1-65e87c3
Status: {"lastSuccessReportTabletsTime":"2022-02-08 15:17:43"}
DataTotalCapacity: 50.842 GB
DataUsedPct: 0.00 %
1 row in set (0.00 sec)
15)同样步骤在hadoop102,hadoop103部署BE,并添加节点
]# mkdir -p storage
]# mkdir -p storage
mysql> alter system add backend "bigdata102:9050";
Query OK, 0 rows affected (0.00 sec)
mysql> alter system add backend "bigdata103:9050";
Query OK, 0 rows affected (0.01 sec)
6 be]# ./bin/start_be.sh --daemon
7 be]# ./bin/start_be.sh --daemon</pre>
16)部署Broker,此角色主要用于后续Broker load使用,启动安装目录的Broker服务
]# cd apache_hdfs_broker/
]# ./bin/start_broker.sh --daemon
]# cd apache_hdfs_broker/
]# ./bin/start_broker.sh --daemon
]# cd apache_hdfs_broker/
]# ./bin/start_broker.sh --daemon
17)使用mysql添加对应节点
mysql> alter system add broker broker1 "172.16.0.5:8000";
Query OK, 0 rows affected (0.01 sec)
mysql> alter system add broker broker2 "172.16.0.6:8000";
Query OK, 0 rows affected (0.01 sec)
mysql> alter system add broker broker3 "172.16.0.7:8000";
Query OK, 0 rows affected (0.01 sec)
18)查看状态
mysql> SHOW PROC "/brokers"\G
*************************** 1\. row ***************************
Name: broker2
IP: 172.16.0.6
Port: 8000
Alive: true
LastStartTime: 2022-02-08 16:02:15
LastUpdateTime: 2022-02-08 16:04:10
ErrMsg:
*************************** 2\. row ***************************
Name: broker1
IP: 172.16.0.5
Port: 8000
Alive: true
LastStartTime: 2022-02-08 16:01:24
LastUpdateTime: 2022-02-08 16:04:10
ErrMsg:
*************************** 3\. row ***************************
Name: broker3
IP: 172.16.0.7
Port: 8000
Alive: true
LastStartTime: 2022-02-08 16:02:35
LastUpdateTime: 2022-02-08 16:04:10
ErrMsg:
3 rows in set (0.00 sec)
虽然是alive正常状态,但是有时候创建表出现问题,如下图:
从图中可以看出102和103节点内存都是0,检查前端节点,发现101的节点ip并没有显示101,而是显示122,如下图:
这个是因为在虚拟化中有使用到libvirtd服务生成的,IP可以查看:
去掉方法:
1.查看网桥
[root@bigdata102 fe]# brctl show
bridge name bridge id STP enabled interfaces
virbr0 8000.5254007155ea yes virbr0-nic
2.删除网桥
[root@bigdata102 fe]# ifconfig virbr0 down
[root@bigdata102 fe]# brctl delbr virbr0
3.禁用开机服务
[root@bigdata102 fe]# systemctl disable libvirtd.service
Removed symlink /etc/systemd/system/multi-user.target.wants/libvirtd.service.
Removed symlink /etc/systemd/system/sockets.target.wants/virtlockd.socket.
Removed symlink /etc/systemd/system/sockets.target.wants/virtlogd.socket.
[root@bigdata102 fe]# systemctl mask libvirtd.service
Created symlink from /etc/systemd/system/libvirtd.service to /dev/null.
4.验证
[root@bigdata102 fe]# ifconfig
eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.52.102 netmask 255.255.255.0 broadcast 192.168.52.255
inet6 fe80::20c:29ff:fe0c:70c3 prefixlen 64 scopeid 0x20<link>
ether 00:0c:29:0c:70:c3 txqueuelen 1000 (Ethernet)
RX packets 3537713 bytes 2882108615 (2.6 GiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 2324374 bytes 539845246 (514.8 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10<host>
loop txqueuelen 1 (Local Loopback)
RX packets 146302 bytes 11556762 (11.0 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 146302 bytes 11556762 (11.0 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
再次重新部署BE节点,后查看前端节点IP显示正常,后端节点内存也不是0了:
建表也成功了:
mysql> use test;
Database changed
mysql> create table student_test(
-> name varchar(10),
-> age int
-> )ENGINE=OLAP
-> DISTRIBUTED BY HASH(`age`) BUCKETS 3
-> ;
Query OK, 0 rows affected (0.09 sec)
网友评论