How Do I Access Presto from an MRS Cluster Through a Public Network?

Question

How do I access Presto from an MRS cluster through a public network by commissioning Presto JDBC sample code?

Fault Locating

Log in to MRS Manager and check all Presto configurations and Coordinator role configurations.

PRESTO_COORDINATOR_FLOAT_IP = Private IP address

Log in to the active node where the Coordinator role is located and check whether the IP address is eth0:PRESTO.

Presto service port: 7520 for a non-security cluster and 7521 for a security cluster.

To access Presto through a public network, bind a public network address to the corresponding floating NIC and enter the correct JDBC URL.

URL format:

jdbc:presto://example_ip:7520/Catalog/schema

jdbc:presto://example_ip:7521/Catalog/schema

Troubleshooting

1. On MRS Manager, locate the Presto component and record its internal floating IP address.
2. On the VPC console, create an EIP, locate the subnet of the MRS cluster, locate the floating IP address of Presto, and bind the EIP to the floating IP address.

3. In the security group of the MRS cluster, allow the access from the source address to the Presto port of MRS and test the access. (The following uses a non-security cluster as an example. The catalog is hive.)