Default value of dynamic_node_detection is true
If we don't put dynamic_node_detection=false for the xpandmon monitor in
MaxScale config then the login attempts using proxy fails.
Backend issue appears to be that dynamically detected nodes are having
proxy_protocol off so users are getting access denied.
Below example is where karma075 is MaxScale and user1@clientIP, user2@clientIP
are Xpand users.
If our MaxScale understanding is right that one need atleast 1 bootstrap server
configuration to be defined by customer for “dynamic_node_detection”
feature to work and If the customer define "proxy_protocol=on" under server definition (in MaxScale
config) then any dynamic detection for that server nodes should have
if customer Do Not put "proxy_protocol=on" then dynamic detection for that
server nodes should have proxy_protocol=off.
This way its conditional, more safe and will not effect non proxy environments.
After checking traces from Maxscale and Xpand sides, its revealed that there is
no "proxy" packet.
When checked through maxctrl cmd, found that dynamically detected servers as
shown below have "proxy_protocol" set to off/false .
[root@karma075 ~]# maxctrl show servers | grep 'Server|proxy_protocol'
Since these server entries are detected at the runtime, there is no way
customer can manually change this parameter's value. We tried with maxctrl and