Magna-sqld Dialog

Description
Magna-sqld Dialog The Magna-sqld dialog is used to provision a new cluster.
Name field Specifies the cluster name, which can be any desired name.
Service Port field Specifies the service port for the cluster, which is automatically load balanced across the Magna nodes.
Create button Saves the cluster configuration and provisions it.
Cancel button Abort and close the dialog.

Magna-sqld Actions Menu

Description
Magna-sqld Actions Menu On the right-hand side of the Magna-sqld list view, you will find the "Actions" menu that displays shortcut icons and the dropdown menu icon. Below, we have listed the actions for the Magna-sqld module.
Copy ID item Stores the cluster ID in the clipboard.
Edit Cluster item Opens the Magna-sqld dialog in edit mode, allowing you to change the name of the cluster.
Member Join item Opens the Member Join dialog that lists available Magna-nodes that can be added to the cluster.
Member Leave item Opens the Member Leave dialog that lists Magna-nodes in the cluster that can be removed.
CQL Windows item Opens the SQL Window, enabling you to run queries and statements against databases on the cluster.
Delete Cluster item Opens a confirmation dialog that, if confirmed, deletes the cluster.

Member Join Dialog

Description
Magna-sqld Member Join Dialog The Member Join dialog is used to list available Magna-nodes and add them to the cluster.
Magna-node field List of available Magna-nodes.
Join button Adds the selected Magna-node to the cluster.
Cancel button Abort and close the dialog.

Member Leave Dialog

Description
Magna-sqld Member Leave Dialog The Member Leave dialog is used to list Magna-nodes currently in the cluster and remove a node from the cluster.
Magna-node field List of Magna-nodes currently in the cluster.
Leave button Removes the selected Magna-node from the cluster.
Cancel button Abort and close the dialog.

SQL Window

Description
Magna-sqld SQL Window The SQL Window provides an interface for executing statements and querying tables within the cluster.
Script area A text editor for entering SQL statements.
RUN button Executes the specified statement or query.
Result area Displays the result of an executed statement or query.
Close button Close the window.


The magna-sqld Policy


The following is a list of policy grants that define and regulate access permissions for both users and the API. To manage these policies, please use the Roles dialog.

Grants

Description

API Command
full Grants full access ALL
delete Permits the deletion of the item. delete
edit Permits access to the "Edit" dialog.  
join Permits access to the "Join" dialog.  
leave Permits access to the "Leave" dialog.  
list Permits listing in the List View area or as JSON objects. list
member-join Permits the join operation to add a node to the cluster. member-join
member-leave Permits the leave operation to remove a node from the cluster. member-leave
new Permits access to the new "Provisioning" dialog.  
save Permits execution of the provisioning process. create, update
sql Permits access to the new "SQL" dialog.  
sql-run Permits the execution of SQL statements. sql-run
status Permits the retrieval of the cluster status. status