Node Configuration with the Administrator Role

nodes with the admin role have the additional responsibiltiy to store important metadata for compression and system configuration in most cases, an {{ocienthyperscaledatawarehouse}} system should have the majority of sql nodes assigned to the admin role administrator node redundancy to ensure high availability and consistency, an {{ocient}} system must always have a minimum number of operational nodes with admin privileges redundancy for the system configuration and dictionary compression operates using a majority present model in a system with n nodes configured with the admin role, at least n / 2 + 1 must be present and active for the system to function correctly, where n is the total number of nodes, and n / 2 denotes the division floor (i e , rounded down to the nearest integer) this table shows the number of nodes with admin privileges that can fail before the system experiences problems both columns comprise only nodes assigned the admin role, not the entire system node count number of nodes node failures tolerated 1 0 2 0 3 1 4 1 5 2 6 2 7 3 various core system functions risk failure if the number of nodes running the admin role falls below the tolerance threshold operations that could fail include s ystem startup system c onfiguration q uery execution data loading the majority present model for nodes with the admin role is different than parity encoding used for foundation nodes for more information on parity width for foundation nodes, see docid\ vepqy7er3ewghfze1bvoa administrator node metadata this table describes additional metadata files stored by nodes running the admin role if you remove the admin role from a node, the system removes these files file path description /var/opt/ocient/metadatastorage raft definitions for users, network configuration, and database objects /var/opt/ocient/globaldatastorage raft compression dictionaries for the compression gdc columns configure nodes with the admin istrator role to configure a node to run the admin role, execute this sql statement alter node nodename add role admin; it is generally a good practice to have all sql nodes in your system assigned to run the admin role you can configure additional nodes with the admin role to adjust the level of redundancy to your chosen level related links docid\ xga0pas8wadtq33 a x7v docid\ vepqy7er3ewghfze1bvoa docid\ r7mqd0slg1oiuksmraupo