Hi Maxim, We have adopted/forked the agent part of the https://github.com/k8ssandra/management-api-for-apache-cassandra project which aims to do similar things. I especially like how they have a local database socket where a sidecar can easily access cassandra and execute cql commands without the need of a service account like your example suggests.
The syntax they adopted (see for instance https://github.com/k8ssandra/management-api-for-apache-cassandra/blob/7cb367eac46a12947bb87486456d3f905f37628b/management-api-server/src/main/java/com/datastax/mgmtapi/resources/NodeOpsResources.java#L115) looks like `CALL NodeOps.decommission(?, ?)", force, false)` which is similar to your execute - just throwing this out as another example. I definitely like settling on the cql interface since that avoids having to load different jmx bindings for different Cassandra versions making things cleaner and more easily accessible. There is some security concern to mix data and control plane so I would liek to see some way to restrict access like the mgmt api does where the admin commands are only available on the socket. Maybe, have a special admin port or socket? I prefer making the agent part of the managment api become part of Cassandra either through your CEP or other means but I can also see this as an adjacent sub project - let's discuss 🙂 German ________________________________ From: Maxim Muzafarov <mmu...@apache.org> Sent: Monday, November 13, 2023 10:08 AM To: dev@cassandra.apache.org <dev@cassandra.apache.org> Subject: [EXTERNAL] [DISCUSSION] CEP-38: CQL Management API Hello everyone, While we are still waiting for the review to make the settings virtual table updatable (CASSANDRA-15254), which will improve the configuration management experience for users, I'd like to take another step forward and improve the C* management approach we have as a whole. This approach aims to make all Cassandra management commands accessible via CQL, but not only that. The problem of making commands accessible via CQL presents a complex challenge, especially if we aim to minimize code duplication across the implementation of management operations for different APIs and reduce the overall maintenance burden. The proposal's scope goes beyond simply introducing a new CQL syntax. It encompasses several key objectives for C* management operations, beyond their availability through CQL: - Ensure consistency across all public APIs we support, including JMX MBeans and the newly introduced CQL. Users should see consistent command specifications and arguments, irrespective of whether they're using an API or a CLI; - Reduce source code maintenance costs. With this new approach, when a new command is implemented, it should automatically become available across JMX MBeans, nodetool, CQL, and Cassandra Sidecar, eliminating the need for additional coding; - Maintain backward compatibility, ensuring that existing setups and workflows continue to work the same way as they do today; I would suggest discussing the overall design concept first, and then diving into the CQL command syntax and other details once we've found common ground on the community's vision. However, regardless of these details, I would appreciate any feedback on the design. I look forward to your comments! Please, see the design document: CEP-38: CQL Management API https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FCASSANDRA%2FCEP-38%253A%2BCQL%2BManagement%2BAPI&data=05%7C01%7CGerman.Eichberger%40microsoft.com%7C62051e1eb8964889962d08dbe473d482%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638354958369996874%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XT4LB1CopZy8qCUM6MnUfBhGFwKHmsUO%2B2AUpgv83zI%3D&reserved=0<https://cwiki.apache.org/confluence/display/CASSANDRA/CEP-38%3A+CQL+Management+API>