I'm trying to install a wordpress installation where the DB will sit on a MySQL cluster (Galera/Percona XtraDB Cluster) and connected through HAProxy.
Everything outside of the Wordpress install seems to work fine. Using the mysql client to connect to the database with a username and password works just fine. The Wordpress install is on the same server as the HAProxy. That works fine from command line when I do this:
mysql -u wordpress -p<password> -h <haproxy ip> -D wordpress
However, from the install GUI page, it constantly takes me to the "DB connection failed" page.
Can anyone shed some light on where the issue might be? Here is what I'm attempting to use in the install from:
database name: wordpress username: wordpress password: <password> database host: <ip of haproxy server> table prefix: wp_
Thanks for any suggestions!