METHOD FOR OPTIMIZING INDEX, MASTER DATABASE NODE AND SUBSCRIBER DATABASE NODE

摘要

A method for optimizing index, a master database node and a subscriber database node. The method for optimizing index includes: checking, by a master database node, if role information of an index matches role information of the master database node, when the index is added into the master database node; updating database information by using the index when the role information of the index matches the role information of the master database node. Therefore, unnecessary indexes in the master database node and the subscriber database node are reduced while keeping the schema the same. Furthermore, unnecessary logs transmitted from the master database node to the subscriber database node are reduced.