You can configure an OceanBase cluster by setting cluster-level parameters to ensure that the behaviors of OceanBase Database meet your service requirements.
OceanBase Database supports cluster-level parameters that apply to the entire cluster. Some parameter settings take effect in real time and some take effect only after a restart. You can set cluster-level parameters to control the load balancing strategy, compaction time, compaction method, resource allocation, and module switches of a cluster.
The sys tenant can view and set cluster-level parameters. A user tenant can only view cluster-level parameters.
If you do not specify the parameters, the default values are used after an OBServer node is started. Upon the successful start of the OBServer node, the parameter values are permanently saved to the /home/admin/oceanbase/etc/observer.config.bin file. You can run the strings observer.config.bin command to view the file content.
Different cluster-level parameters are of different data types. The following table describes the data types of cluster-level parameters in OceanBase Database.
| Data type | Description |
|---|---|
| BOOL | The Boolean type. Valid values: true and false. |
| CAPACITY | The unit of capacity. Valid values: b (bytes), k (KB), m (MB), g (GB), t (TB), and p (PB). The unit is case-insensitive. Default value: m. |
| DOUBLE | The Double (double-precision floating-point) type. A value of this data type occupies a storage space of 64 bits, contains 16 valid digits, and is accurate to 15 digits after the decimal point. |
| INT | The Int64 type. A value of this data type can be a positive integer, negative integer, or 0. |
| MOMENT | The type that represents a moment in hh:mm format, such as 02:00. Special value: disable, which indicates that no time is specified. This data type applies only to the major_freeze_duty_time parameter. |
| STRING | Strings. The user-specified string value. |
| STRING_LIST | The type that represents a list of strings separated with semicolons (;). |
| TIME | The time type. The following time units are supported: μs (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), and d (days). If no suffix is added to a value of this data type, the unit s is used by default. The unit is case-insensitive. |
More information
For more information about how to view and set tenant parameters, see the following topics:
For more information about the system parameters of OceanBase Database, see Overview of configuration management.