Re: HAProxy for MySQL Cluster

2012-03-18 Thread Cyril Bonté
Hi David, sorry to be so late to reply. Maybe you were able to fix the issue and your questions are outdade. Le 09/03/2012 12:24, David Seira a écrit : Hi again Cyril, I'm trying the option mysql-check as you comment me. I've found that I must create a user into the mysql server for permit

Re: HAProxy for MySQL Cluster

2012-03-09 Thread David Seira
Hi again Cyril, I'm trying the option mysql-check as you comment me. I've found that I must create a user into the mysql server for permit the haproxy access: insert into user (Host,User) values ('192.168.1.3','haproxy'); (The users table has the ndbcluster engine, for that the permissions are

HAProxy for MySQL Cluster

2012-03-08 Thread David Seira
Hi list, I'm trying to installing HAProxy for make load balancing between several MySQL Nodes in a MySQL Cluster. I've configured the haproxy.conf like this: listen mysql 0.0.0.0:3306 mode tcp balance roundrobin maxconn 4096 server mysqlnode1 192.168.1.1 check weight 50

Re: HAProxy for MySQL Cluster

2012-03-08 Thread Cyril Bonté
Hi David, Le 08/03/2012 20:37, David Seira a écrit : Hi list, I'm trying to installing HAProxy for make load balancing between several MySQL Nodes in a MySQL Cluster. I've configured the haproxy.conf like this: listen mysql 0.0.0.0:3306 mode tcp balance roundrobin maxconn 4096