Delete statement removes a cluster specified with name. The cluster gets removed from all the nodes, but its indexes are left intact and become active local non-replicated indexes.
- SQL
- HTTP
- PHP
DELETE CLUSTER click_query
ALTER CLUSTER <cluster_name> ADD <index_name>
adds an existing local index to the cluster. The node which receives the ALTER query sends the index to the other nodes in the cluster. All the local indexes with the same name on the other nodes of the cluster get replaced with the new index.
- SQL
- HTTP
- PHP
ALTER CLUSTER click_query ADD clicks_daily_index
ALTER CLUSTER <cluster_name> DROP <index_name>
forgets about a local index, i.e., it doesn't remove the index files on the nodes but just makes it an active non-replicated index.
- SQL
- HTTP
- PHP
ALTER CLUSTER posts DROP weekly_index
ALTER CLUSTER <cluster_name> UPDATE <nodes>
statement updates node lists on each node of the cluster to include every active node in the cluster. See Joining a cluster for more info on node lists.
- SQL
- HTTP
- PHP
ALTER CLUSTER posts UPDATE nodes
For example, when the cluster was initially created, the list of nodes used for rejoining the cluster was 10.10.0.1:9312,10.10.1.1:9312
. Since then other nodes joined the cluster and now we have the following active nodes: 10.10.0.1:9312,10.10.1.1:9312,10.15.0.1:9312,10.15.0.3:9312
.
But the list of nodes used for rejoining the cluster is still the same. Running the ALTER CLUSTER ... UPDATE nodes
copies the list of active nodes to the list of nodes used to rejoin on restart. After this, the list of nodes used on restart includes all the active nodes in the cluster.
Both lists of nodes can be viewed using Cluster status statement (cluster_post_nodes_set
and cluster_post_nodes_view
).