Methods and system for optimal multi-environment data synchronization/replication

A method comprising:

• establishing out-of-band (OOB) connections to a plurality of databases;
• receiving a query that is being executed on a first data database over a first OOB connection;
• determining that the query changes data on a synchronized and replicated table appearing on a second database;
• requesting the first database to process the query and provide metadata associated with processing the query over a first-database in-band connection to the first database:
• determining based on the synchronized and replicated table, the data that is changed in the synchronized and replicated table by the first database, and the metadata a synchronization and replication process for the second database to process;
• obtaining locks on the synchronized and replicated table from the first database and the second database;
• instructing the second database to process the synchronization and replication process over a second-database in-band connection to the second database.

A system, comprising:

• a synchronization server;
• and
• a plurality of database systems;
• wherein the synchronization server is configured to:
• establish out-of-band (OOB) connections with each of the database systems using message passing;
• identify queries executed on an originating database system over a first OOB connection of the OOB connections and determine when a given query that is processed on the originating database system requires changes to replicated source objects in remaining ones of the database systems;
• execute the given query on a selected database system from the remaining ones of the database systems;
• use metadata returned from the selected database system to select a synchronization and replication process;
• instruct the remaining ones of the database systems, excluding the selected database system, to process the synchronization and replication process to update the changes associated the replicated source objects.