Control Web Panel

WebPanel => MySQL => Topic started by: bughatti on January 09, 2020, 03:57:03 PM

Title: CWP7 Pro remote db behind haproxy
Post by: bughatti on January 09, 2020, 03:57:03 PM
Hello all, new to CWP and the forums.  First I would like to say, I have read and looked for articles on accomplishing what I want to do.  I have not found any straight forward answers.  We are currently using cpanel and I am migrating all the cpanel servers to cwp7pro.  I have a galera cluster setup behind an haproxy server that has been running fine for a few months and works with 2 of the cpanel servers.  So far I have gone in and created a global user for 1 of the cwp servers, opened up the firewall for that ip in cwp and validated I can access the galera cluster through haproxy from cwp.  What I am not really able to wrap my head around is how do I set that as the default database connection in cwp.  DO I nee to add lines in MySQL configuration in the web panel of cwp and if so what exact lines need to be in there?  Or do i need to do something in cli through ssh on the server?

Any help would be greatly appreciated.