SQL Federation

Background

This function is an experimental one and is currently not suitable for use in core system production environments. When multiple tables in a join query are distributed across different database instances, enabling federated query allows for cross-database join queries, as well as subqueries.

Parameters

  1. sqlFederation:
  2.   sqlFederationEnabled: # SQL federation enabled configuration
  3.   allQueryUseSQLFederation: # all query use SQL federation configuration
  4.   executionPlanCache: # execution plan cache configuration
  5.     initialCapacity: 2000 # execution plan local cache initial capacity
  6.     maximumSize: 65535 # execution plan local cache maximum size

Sample

  1. sqlFederation:
  2.   sqlFederationEnabled: true
  3.   allQueryUseSQLFederation: false
  4.   executionPlanCache:
  5.     initialCapacity: 2000
  6.     maximumSize: 65535