Multi-Cluster Environment Considerations
- Loader Nodes send data to all Foundations Nodes in the System.
- The distribution of data loaded to each cluster is proportional to its total capacity.
- Every Loader Node loads to every cluster that belongs to the storage space of the target tables. Depending on the location of the tables, the database or schema could contain multiple storage spaces.
- A storage cluster can only belong to one storage space.
Dropping a cluster is not supported in an Ocient System that contains multiple storage clusters. However, you can drop a cluster in a system that contains only one cluster.
Troubleshooting Considerations
- If a cluster shuts down, the load stops and provides results after the cluster is available again.
- The load is tolerant of Loader Node failures as the load can make progress when at least one Loader Node is still available.
- Before adding or removing a node, storage drive, or cluster, you must stop the load. Stop the LAT and any
CREATE TABLE AS SELECTorINSERT INTO SELECTSQL statements. Otherwise, the load fails.
Contact Ocient Support for help with a complex multiple storage cluster setup.

