1、软件需求
(1)JDK1.8.0;
(2)maven3.6.3;
(3)MySQL5.7.35;
(4)presto0.257。
2、配置
(1)etc目录:
(2)catalog目录下是mysql.properties;
(3)config.properties:
coordinator=true
node-scheduler.include-coordinator=true // 单机这里设置为true
http-server.http.port=9999
query.max-memory=50GB
query.max-memory-per-node=1GB
query.max-total-memory-per-node=2GB
discovery-server.enabled=true
discovery.uri=http://10.229.31.70:9999 // 服务器地址
(4)jvm.config:
-server
-Xmx4G
-XX:+UseG1GC
-XX:G1HeapRegionSize=32M
-XX:+UseGCOverheadLimit
(5)launcher:
export JAVA_HOME=/opt/jdk1.8.0 // JDK1.8目录
export PATH=$JAVA_HOME:$PATH
(6)log.properties:
com.facebook.presto=INFO
(7)node.properties:
node.environment=production
node.id=ffffffff-ffff-ffff-ffff-ffffffffffff
node.data-dir=/home/jiaojun/software/presto-server-0.257/data // 保存data的目录,随意
(8)catalog/mysql.properties:
connector.name=mysql
connection-url=jdbc:mysql://localhost:3306
connection-user=root
connection-password=709221jj