Oceanbase新版本复合分区添加分区操作丨本际云推荐

Oceanbase新版本复合分区添加分区操作

Introduction

Hi there! I’m the editor of InterCloud Server Recommendation website. Today, I’m writing about the new version of Oceanbase, which includes the feature of adding partitions to range-based compound partitions.

Oceanbase新版本复合分区添加分区操作

Background Information

An important resource system has been migrated to OceanBase, which currently uses OceanBase version 2.2.76. However, the split partition function is not supported in this version, and only sequential add partition operations can be done. This method of adding partitions is not suitable for compound partitions, such as RANGE partitions made up of region and time. In such cases, multiple max partitions exist, and deleting them in the middle for add partition is not possible. To deal with this issue, Oracle databases were divided into partitions prior to the migration to OceanBase. However, now that it is approaching the end of 2022, it is necessary to add new partitions for the smooth operation of the business.

Testing Process

The new OceanBase version 2.2.77 and 3.2.3.2 support the add partition function for compound partitions. A testing environment was set up to verify this function. The steps involved in the testing process are as follows:

Check whether the parameter is enabled and whether there is data in the max partition
Change the parameter value to True
Check whether the parameter value has been successfully changed
Verify whether the max partition has data
Execute the add partition command
Check the indexes that have become invalid
Disable the parameter once all partitions have been added

With the compound partitions add partition function, it has now become possible to add partitions to the compound partitions where add partition wasn’t previously possible.

Conclusion

Oceanbase is a rapidly evolving technology with certain features still being developed. The compound partition add function is only an improvement in the absence of split partition function, and it’s important to note that there’s still some room for improvement. Also, it’s worth noting that OceanBase’s current inability to rebuild an index after it becomes invalid can cause some inconvenience during operations. Hopefully, these issues will be resolved in the future updates of OceanBase.

原创文章，作者：小编小本本，如若转载，请注明出处：https://www.benjiyun.com/yunzhujiyunwei/vps-yunwei/6600.html