Magna-sqlr Dialog

Description
Magna-sqlr Dialog The Magna-sqlr 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-sqlr Actions Menu

Description
Magna-sqlr Actions Menu On the right-hand side of the Magna-sqlr 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-sqlr module.
Copy ID item Stores the cluster ID in the clipboard.
Edit Cluster item Opens the Magna-sqlr 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-sqlr 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-sqlr 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-sqlr 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-sqlr 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