Presto-搭建

  |   0 评论   |   10 浏览

wget https://repo1.maven.org/maven2/com/facebook/presto/presto-server/0.234.1/presto-server-0.234.1.tar.gz

wget https://download.oracle.com/otn/java/jdk/8u241-b07/1f5b5a70bf22433b84d0e960903adac8/jdk-8u241-linux-x64.tar.gz?AuthParam=1587798445_31acf193dbabd103a2cf20fbefd7dacf

mv jdk-8u241-linux-x64.tar.gz?AuthParam=1587798445_31acf193dbabd103a2cf20fbefd7dacf jdk-8u241-linux-x64.tar.gz

mkdir -p /work/jdk && tar -zxvf jdk-8u241-linux-x64.tar.gz -C /work/jdk

mkdir -p /work/presto && tar -zxvf presto-server-0.234.1.tar.gz -C /work/presto

cd /work/presto

mkdir data

mkdir etc

vim etc/node.properties

node.environment=production
node.id=ffffffff-ffff-ffff-ffff-fffffffffffa
node.data-dir=/work/presto/data

vim etc/jvm.config

-server
-Xmx20G
-XX:+UseG1GC
-XX:G1HeapRegionSize=32M
-XX:+UseGCOverheadLimit
-XX:+ExplicitGCInvokesConcurrent
-XX:+HeapDumpOnOutOfMemoryError
-XX:+ExitOnOutOfMemoryError

vim etc/config.properties

coordinator=true
node-scheduler.include-coordinator=false
http-server.http.port=8080
query.max-memory=25GB
query.max-memory-per-node=1GB
query.max-total-memory-per-node=2GB
discovery-server.enabled=true
discovery.uri=http://ip:port
coordinator=false
http-server.http.port=8080
query.max-memory=50GB
query.max-memory-per-node=1GB
query.max-total-memory-per-node=2GB
discovery.uri=http://ip:port

vim etc/log.properties

com.facebook.presto=INFO

mkdir etc/catalog

vim etc/catalog/mongodb.properties

connector.name=mongodb
mongodb.seeds=ip:port,ip:port
mongodb.credentials=user:password

vim etc/catalog/mysql.properties

connector.name=mysql
connection-url=jdbc:mysql://ip:port
connection-user=user
connection-password=password

评论

发表评论