Index update method and system, and related apparatus

An index update apparatus, comprising:

• a communication interface configured to receive an index update request from a tenant in a multi-tenant architecture, wherein the index update request instructs the index update apparatus to create or delete a target index that is associated with a field in a logic table of the tenant;
• a processor coupled to the communication interface;
• and
• a memory configured to store program instruction executable by the processor to:
• update metadata information of the logic table in a database in response to receiving the index update request, wherein the database comprises updated metadata information of the logic table after the index update apparatus updates the metadata information;
• send a notification to notify a coordination service that the metadata information of the logic table is changed, wherein the coordination service is configured to notify a second data access node to perform a second local synchronization update on second metadata information corresponding to the metadata information of the logic table in the database, and wherein the second metadata information is locally cached in the second data access node;
• perform a first local synchronization update on first metadata information corresponding to the metadata information of the logic table in the database, wherein the first metadata information is locally cached in the index update apparatus;
• perform a data asynchronization update after the second data access node finishes the second local synchronization update;
• seta status of the target index in the database to a normal state when the index update ret rest instructs creating the target index;
• and
• notify the coordination service after metadata version numbers in all target tenant data records are updated.