Accessing Presto from an MRS Cluster Through a Public Network

Issue

To debug the Presto JDBC sample code, the user needs to use the public network to access Presto.

Cause Analysis

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

PRESTO_COORDINATOR_FLOAT_IP = Internal IP address

Log in to the active node with the Coordinator role and check whether the IP address is provided by 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 floating NIC and enter the correct JDBC URL.

URL format:

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

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

Procedure

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 an 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.)