Routing functions v5

bdr.create_proxy

Create a proxy

Synopsis

bdr.create_proxy(proxy_name text, node_group text);

Parameters

  • proxy_name Name of the new proxy.
  • node_group Name of the group to be used by the proxy.

bdr.alter_proxy_option

Change a proxy

Synopsis

bdr.alter_proxy_option(proxy_name text, config_key text, config_value text);

Parameters

  • proxy_name Name of the proxy to be changed.
  • config_key Key of the option in the proxy to be changed.
  • config_value New value to be set for the given key.

bdr.drop_proxy

Drop a proxy

Synopsis

bdr.drop_proxy(proxy_name text);

Parameters

  • proxy_name Name of the proxy to be dropped.

bdr.routing_leadership_transfer

Changing the routing leader transfers the leadership of the node group to another node

Synopsis

bdr.routing_leadership_transfer(node_group_name text,
              leader_name text,
              transfer_method text DEFAULT 'strict',
              transfer_timeout interval DEFAULT '10s');

Parameters

  • node_group_name Name of group where the leadership transfer is requested.
  • leader_name Name of node that will become write leader.
  • transfer_method Type of the transfer, it can be "fast" or the default "strict" that checks the maximum lag.
  • transfer_timeout Timeout of the leadership transfer, default is 10 seconds.