We need to be able to work on the Trino cluster without causing issues for things that use it.
There should be separate procedures for coordinator vs worker, since we have enough workers to be able to work on them individually while the rest of the cluster keeps chugging along. To that end:
- Script to poll what each worker is doing, to determine when a worker is busy vs idle. Is there anything off the shelf for this? We're doing this manually now via query in trino-cli.
- Script (same script?) to trigger a graceful shutdown on a Trino worker.