Learning and Operating Presto

Chapter 6. Presto Administration

Presto administration is the set of tools, behaviors, and strategies that enable you to maintain your Presto cluster. The flow to administer Presto comprises three steps: configuration, monitoring, and management. Configuration defines how to set up your Presto cluster before deploying it. Monitoring enables you to control the behavior of your Presto cluster while it is deployed. Finally, management permits you to adapt the behavior of your Presto cluster to the runtime conditions.

The chapter is organized into three parts. In the first part, you’ll learn how to configure Presto through the configuration file, session properties, and the Java Virtual Machine (JVM). In the second part, you’ll learn Presto’s tools to monitor the Presto cluster: Presto console, REST API, and evaluation metrics. In the third part, you’ll learn how to manage Presto, with a focus on resources, sessions, and namespaces.

Introducing Presto Administration

Administration in Presto refers to the tasks and responsibilities involved in configuring, managing, and maintaining a Presto deployment.

As a database administrator, your role will be to ensure that the Presto system operates efficiently and effectively and handles the workload of running complex queries on large datasets. Administration may involve monitoring the system’s performance, optimizing configuration parameters, and managing the data stored in the system.

Figure 6-1 shows the steps involved in the Presto administration. ...