've been taksed to convert our standalone DB server that runs the OSTicket database into a MariaDB Galera cluster to add a level of resiliency to the service, I've got the cluster and have set the MYSQL_HOST variable to one of the nodes which works fine, however I am unable to set it to 'speak' to the whole cluster so currently it's not really doing the job required.
We have a haproxy docker instance we call swarm-maria which does other bits for our application which we have tried to point OSTicket to use (swamr-maria_proxy in the MYSQL_HOST variable) on an unused port but no dice, we then tried to add a 'link' as mentioned in the docker page for OSTicket (swarm-maria_proxy:mysql) and comment out the MYSQL_HOST variable but then it has a problem that it doesn't have said variable...
Are there any 'standard practice' ways of doing this?