Configuring pgd-proxy v23
TPA will install and configure pgd-proxy for the PGD-Always-ON
architecture with PGD 5 on any instance with
pgd-proxy in its
(By default, the PGD-Always-ON architecture
pgd-proxy on all the data nodes in every location, but you
can instead create any number of additional proxy instances with
pgd-proxy is configured at PGD level via SQL functions.
|pgd-proxy configuration, e.g. port
|configuration for the proxy's node group, e.g.
|routing configuration for individual PGD nodes
See the PGD documentation for more details.
Group-level options related to pgd-proxy can be set under
bdr_node_groups along with other node group options:
enable_proxy_routing must be explicitly set to
true for pgd-proxy to be enabled for the group.
Node-level options related to pgd-proxy can be set under
bdr_node_options on any PGD instance:
Options for a pgd-proxy instance itself, rather than the group or nodes
it is attached to, can be set under
cluster_vars (which applies to all proxies), or under
pgd_proxy_options on any pgd-proxy instance:
In this case, while other instances will get their
listen_port setting from
someproxy overrides that default setting and configures its
listen_port in the instances'
You can enable and configure the http(s) service for PGD proxy that will provide api endpoints to monitor the proxy's health.
cluster_vars or instance
vars will store
all the settings that defines the http(s) api which live under the
subsection of the
proxy top section of
The variable can contain these keys:
key_file keys are both required if you use
and are willing to use your own certificate and key.
You must ensure that both certificate and key are available at the given
location on the target node before running
key_file empty if you want TPA to generate a
certificate and key for you using a cluster specific CA certificate.
TPA CA certificate won't be 'well known', you will need to add this certificate
to the trust store of each machine that will probe the endpoints.
The CA certificate can be found on the cluster directory on the TPA node at:
see pgd-proxy documentation for more information on the available api endpoints.
- On this page