Method and device for ensuring atomicity of DDL statements of distributed database

Abstract

The invention relates to a method and device for guaranteeing atomicity of DDL statements of a distributed database, and the method comprises the steps: determining a DDL execution plan of the DDL statements if a calculation node receives the DDL statements from a client, and the DDL execution plan comprises one or more DDL execution states; the data node determines a target resource involved in execution of the DDL statement; and in the process that the computational node executes the DDL statement according to the DDL execution plan, if the current execution state is a pre-locking state, the data node performs pre-locking processing on the target resource. According to the embodiment of the invention, the DDL execution plan is divided into a plurality of states, the target resource is pre-locked through the pre-locking state in the plurality of states, the target resource is locked in advance, errors are avoided in advance, the success rate of the DDL is improved, the atomicity of the DDL is ensured, and scenes needing manual intervention are reduced.

Images