Hi Jochus, continuing on Jagadees's Comment, I am running a master-master MySQL with LVS (HA) as in i have 3 machines : 2 Real Mysql Servers (Running in master-master mode), One Real HA server on which both MySQL servers are load balanced via a VIRTUAL IP Address.
My problem is when i try and connect to the MySQL database via a simple php script on the Drupal webserver i get a positive response, but when i add the virtual server's IP address with the db name /user/pass details of the mysql server in settings.php it does not work. How do i overcome this? does drupal support Master-Master MySQL @ all? If yes, then i my case how do i achieve that?
Hi Jochus, continuing on Jagadees's Comment, I am running a master-master MySQL with LVS (HA) as in i have 3 machines : 2 Real Mysql Servers (Running in master-master mode), One Real HA server on which both MySQL servers are load balanced via a VIRTUAL IP Address.
My problem is when i try and connect to the MySQL database via a simple php script on the Drupal webserver i get a positive response, but when i add the virtual server's IP address with the db name /user/pass details of the mysql server in settings.php it does not work. How do i overcome this? does drupal support Master-Master MySQL @ all? If yes, then i my case how do i achieve that?