ALTER TENANT · k8s原理与实践

[TOC] # ALTER TENANT ## 描述该语句用来修改租户信息。 ## 格式 ~~~ ALTER TENANT {tenant_name | ALL} [SET] [tenant_option_list] [opt_global_sys_vars_set] tenant_option_list: tenant_option [, tenant_option ...] tenant_option: COMMENT [=]'string' |{CHARACTER SET | CHARSET} [=] charsetname |COLLATE [=] collationname |REPLICA_NUM [=] num |ZONE_LIST [=] (zone [, zone…]) |PRIMARY_ZONE [=] zone |RESOURCE_POOL_LIST [=](poolname [, poolname…]) |DEFAULT TABLEGROUP [=] {NULL | tablegroupname} |{READ ONLY | READ WRITE} |LOGONLY_REPLICA_NUM [=] num |LOCALITY [=] 'locality description' |LOCK|UNLOCK; opt_global_sys_vars_set: VARIABLES system_var_name = expr [,system_var_name = expr] ... ~~~ ## 参数解释 <table data-tag="table" id="table-no5-mh9-xpp" class="table"><colgroup width="296" span="1" data-tag="col" id="col-pd4-hsn-7rp" colwidth="1*" colnum="1" colname="col1" style="width:50%" class="col"></colgroup><colgroup width="427" span="1" data-tag="col" id="col-m1g-la9-ah8" colwidth="1*" colnum="2" colname="col2" style="width:50%" class="col"></colgroup><thead id="thead-zk1-wa8-lxn" class="thead"><tr id="tr-rqi-ozh-eva"><th id="td-vwi-y19-n8d">参数</th><th id="td-vfe-3cn-6ug">描述</th></tr></thead><tbody data-tag="tbody" id="tbody-qqv-63g-1ni" class="tbody"><tr data-tag="tr" id="tr-aac-0x3-y23" class="tr"><td data-tag="td" id="td-jjp-utq-o24" class="td">tenant_name</td><td data-tag="td" id="td-9sh-egh-9j2" class="td">指定要修改的租户名。</td></tr><tr data-tag="tr" id="tr-5wp-ohq-ylt" class="tr"><td data-tag="td" id="td-doj-xgc-6m7" class="td">ALTER TENANT ALL</td><td data-tag="td" id="td-8on-ag9-rac" class="td">同时修改所有租户。</td></tr><tr data-tag="tr" id="tr-icc-hua-ew6" class="tr"><td data-tag="td" id="td-fp1-tk4-blc" class="td">RESOURCE_POOL_LIST</td><td data-tag="td" id="td-mvl-2ha-u9q" class="td">资源池列表，为创建租户时的必填项，暂时只支持一个 RESOURCE POOL。</td></tr><tr data-tag="tr" id="tr-yad-ayb-vof" class="tr"><td data-tag="td" id="td-p1n-m9m-oo9" class="td">DEFAULT TABLEGROUP</td><td data-tag="td" id="td-0l5-6h2-uvc" class="td">设置租户默认表组信息，NULL 表示取消ovtn库默认表组。</td></tr><tr data-tag="tr" id="tr-yml-m6f-4qc" class="tr"><td data-tag="td" id="td-cvz-mfb-peq" class="td">LOCK|UNLOCK</td><td data-tag="td" id="td-3xk-ljs-ui6" class="td">租户锁定和解锁。对租户进行锁定后，不能在该租户上创建新的连接，已有连接保持不变。通常在客户费用到期未续费的场景下使用，客户费用到期后对租户进行锁定，客户续费后再进行解锁。</td></tr><tr data-tag="tr" id="tr-54y-tmh-mve" class="tr"><td data-tag="td" id="td-02a-wqg-4hp" class="td">COMMENT</td><td data-tag="td" id="td-dtm-bph-j4a" class="td">修改注释。</td></tr><tr data-tag="tr" id="tr-h0c-39p-7j0" class="tr"><td data-tag="td" id="td-k00-sq5-ng9" class="td">CHARACTER SET | CHARSET</td><td data-tag="td" id="td-ey7-f7x-1k2" class="td">修改租户的字符集。</td></tr><tr data-tag="tr" id="tr-26e-ck6-3yn" class="tr"><td data-tag="td" id="td-5bn-6me-350" class="td">COLLATE</td><td data-tag="td" id="td-m3n-rp0-6id" class="td">指定校对规则。</td></tr><tr data-tag="tr" id="tr-9hg-ih8-ytp" class="tr"><td data-tag="td" id="td-r95-4dw-1ri" class="td">REPLICA_NUM</td><td data-tag="td" id="td-uci-1m8-h3h" class="td">指定副本数。</td></tr><tr data-tag="tr" id="tr-1jv-j1t-ifk" class="tr"><td data-tag="td" id="td-1v7-ksk-yeh" class="td">ZONE_LIST</td><td data-tag="td" id="td-a26-2y2-md7" class="td">指定要修改的Zone列表。</td></tr><tr data-tag="tr" id="tr-bz3-jrf-2ta" class="tr"><td data-tag="td" id="td-m6u-3np-p9p" class="td">PRIMARY_ZONE</td><td data-tag="td" id="td-cqk-50x-wfg" class="td">指定主Zone。</td></tr><tr data-tag="tr" id="tr-mu1-hsw-01v" class="tr"><td data-tag="td" id="td-ccn-s3v-sau" class="td">READ ONLY | READ WRITE</td><td data-tag="td" id="td-fy7-ov5-7d3" class="td">指定租户的只读或读写属性。</td></tr><tr data-tag="tr" id="tr-ns4-45v-12b" class="tr"><td data-tag="td" id="td-buk-fa8-jtl" class="td">LOGONLY_REPLICA_NUM</td><td data-tag="td" id="td-5hv-rv3-e02" class="td">指定日志副本数。</td></tr><tr data-tag="tr" id="tr-f1r-r67-5q2" class="tr"><td data-tag="td" id="td-au8-zf7-zrv" class="td">LOCALITY</td><td data-tag="td" id="td-c8j-k1x-zzj" class="td">描述副本在Zone间的分布情况，如：F@z1,F@z2,F@z3,R@z4 表示z1, z2, z3为全功能副本，z4为只读副本。</td></tr><tr data-tag="tr" id="tr-oxo-w2m-ilj" class="tr"><td data-tag="td" id="td-i8y-sey-xdx" class="td">system_var_name</td><td data-tag="td" id="td-ydk-pvh-r09" class="td">修改租户的系统变量值。</td></tr></tbody></table> ## 示例 * 锁定租户TENANT1。 ~~~ ALTER TENANT TENANT1 LOCK; ~~~ ## 注意事项 ALTER TENANT语句系统租户有权限执行，同时本租户的管理员能执行。