Presto 安装配置

https://prestodb.io/docs/current/installation/deployment.html

https://www.jianshu.com/p/520722be209e
image.png

  1. [root@dev-presto2 /etc/presto/presto-server/etc ]# tree .
  2. .
  3. ├── catalog
  4. │   ├── mongodb.properties
  5. │   ├── mysql.properties
  6. │   └── mysql_3.properties
  7. ├── config.properties
  8. ├── jvm.config
  9. ├── log.properties
  10. └── node.properties
  1. ##cat jvm.config
  2. -server
  3. -Xmx16G
  4. -XX:+UseG1GC
  5. -XX:G1HeapRegionSize=32M
  6. -XX:+UseGCOverheadLimit
  7. -XX:+ExplicitGCInvokesConcurrent
  8. -XX:+HeapDumpOnOutOfMemoryError
  9. -XX:+ExitOnOutOfMemoryError
  10. -DHADOOP_USER_NAME=hdfs
  12. ## cat config.properties
  13. coordinator=true
  14. node-scheduler.include-coordinator=false
  15. http-server.http.port=10008
  16. query.max-memory=50GB
  17. query.max-memory-per-node=1GB
  18. query.max-total-memory-per-node=2GB
  19. discovery-server.enabled=true
  20. discovery.uri=http://192.168.1.151:10058
  22. ## cat log.properties
  23. com.facebook.presto=INFO
  25. ## cat node.properties
  26. node.environment=production
  27. node.id=master01
  28. node.data-dir=/home/presto/presto-datadir
  30. ## cat catalog/mysql.properties
  31. connector.name=mysql
  32. connection-url=jdbc:mysql://192.168.9.9:3306
  33. connection-user=root
  34. connection-password=123123

Presto安装及连接mysql

https://www.jianshu.com/p/1936d345abac