N-way multimaster replication system and method thereof

A system, comprising:

• a memory storing a plurality of instructions;
• one or more communication interfaces;
• and
• one or more hardware processors coupled to the memory via the one or more communication interfaces, wherein the one or more hardware processors are configured by the instructions to:
• route at least one incoming transaction associated with an application to at least one corresponding database server (DBS) by implementing a logic that integrates a geographical proximity mean value (GPMV) and a sender internet protocol (IP) affinity value (SIPAV), wherein the at least one incoming transaction associated with the application corresponds to a sequence of operations performed on at least one corresponding DBS, wherein at least one incoming transaction associated with the application is routed to a failover database server determined by a predefined logic, if at least one corresponding DBS is unavailable to accept traffic, and wherein the sequence of operations corresponds to at least one of (i) a read operation, and (ii) a write operation;
• process the at least one incoming transaction to extract at least one data manipulation language (DML) operation written directly by the application using a change data capture mechanism from a database and replicated to each DBS other than a DBS on which the application is directly applying a data through one or more incoming transactions;
• generate a primary key by allocating at least one unique identifier if the at least one data manipulation language (DML) operation is inserted on an identified database server (DBS), wherein each primary key corresponds to a numeric value;
• update at least one primary key of a record from the at least one incoming transaction, wherein the record correspond to one or more attributes, and wherein the update corresponds to a change in the one or more attributes;
• and
• dynamically monitor if there is a conflict associated with a parent and a child association of at least one data manipulation language (DML) operation based on an integrity Foreign key Constraint error obtained by processing at least one inserted primary key on the record from the at least one incoming transaction.

One or more non-transitory machine-readable information storage mediums comprising one or more instructions which when executed by one or more hardware processors cause:

• routing at least one incoming transaction associated with an application to at least one corresponding database server (DBS) by implementing a logic that integrates a geographical proximity mean value (GPMV) and a sender internet protocol (IP) affinity value (SIPAV), wherein the at least one incoming transaction associated with the application corresponds to a sequence of operations performed on at least one corresponding DBS, wherein at least one incoming transaction associated with the application is routed to a failover database server determined by a predefined logic, if at least one corresponding DBS is unavailable to accept traffic, and wherein the sequence of operations corresponds to at least one of (i) a read operation, and (ii) a write operation;
• processing the at least one incoming transaction to extract at least one data manipulation language (DML) operation written directly by the application using a change data capture mechanism from a database and replicated to each DBS other than a DBS on which the application is directly applying a data through one or more incoming transactions;
• generating a primary key by allocating at least one unique identifier if the at least one data manipulation language (DML) operation is inserted on an identified database server (DBS), wherein each primary key corresponds to a numeric value;
• updating at least one primary key of a record from the at least one incoming transaction, wherein the record correspond to one or more attributes, and wherein the update corresponds to a change in the one or more attributes;
• and
• dynamically monitoring if there is a conflict associated with a parent and a child association of at least one data manipulation language (DML) operation based on an integrity Foreign key Constraint error obtained by processing at least one inserted primary key on the record from the at least one incoming transaction.