A method of removing metadata from a database in a multimode replication system includes establishing a metadata retention period for nodes in the system as well as associating changes with nodes on the system. The system responds to an expiration of the retention period for any one node by analyzing the associated changes and nodes and determining if the change affects data shared with other nodes. If the data is shared with other nodes then the expired retention period node metadata is removed from the system. If the expired metadata retention period node does not share the changes with other nodes, the metadata is not removed. This allows any unique changes to still be entered into the database without adversely affecting other nodes.