If I have stolon cluster on let's say 3 hosts what is the right way to apply liquibase changes?
Should I always choose master-node host? And what will happen if I choose replica host instead of master?
What will happen if I try to run the same liquibase script on each node (e.g. I have all three nodes listed in my ansible scripts and don't know yet how to choose master stolon host by ansible scripts and decide run scrips on each host just in case).
Are there examples of ansible playbooks for this task?
Which jdbc url should I address?
jdbc:postgresql://{{postgres_host}}:{{stolon_postgres_port}}/{{postgres_database}}
or
jdbc:postgresql://{{postgres_host}}:{{stolon_proxy_port}}/{{postgres_database}}
Or where can I read anything about these issues?
P.S. It seems using proxy's port is the right way
P.S.S. The way is to execute migration on any host - proxy will transfer execution to master node any way. But do it only once - it can be done by run_once ansible key