# HAPROXY solution with same device

**URL:** <https://discourse.haproxy.org/t/haproxy-solution-with-same-device/1746>\
**Category:** Help!\
**Created:** [November 8, 2017, 6:20am UTC](https://discourse.haproxy.org/t/haproxy-solution-with-same-device/1746 "2017-11-08T06:20:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![badhonsoam](https://avatars.discourse-cdn.com/v4/letter/b/779978/32.png) [@badhonsoam](https://discourse.haproxy.org/u/badhonsoam)\
**Post date:** [November 8, 2017, 6:20am UTC](https://discourse.haproxy.org/t/haproxy-solution-with-same-device/1746/1 "2017-11-08T06:20:12Z")

</div>

dear all,  
i am configuring haproxy and keeplived and mysql server on same physical machine. but my load balancing is not working. request getting on mysql 1 server only. i am using the keeplived ip for requesting.  
 ![image](https://us1.discourse-cdn.com/flex016/uploads/haproxy/original/1X/317b376e3e18daa03653736fe6d161878fd13270.png)

---

<div class="post-metadata">

**Author:** ![ask](https://sea2.discourse-cdn.com/flex016/user_avatar/discourse.haproxy.org/ask/32/131_2.png) [@ask](https://discourse.haproxy.org/u/ask)\
**Post date:** [November 8, 2017, 7:17am UTC](https://discourse.haproxy.org/t/haproxy-solution-with-same-device/1746/2 "2017-11-08T07:17:46Z")

</div>

Can you show your haproxy configuration? That’ll make it easier to give specific help!

---

<div class="post-metadata">

**Author:** ![badhonsoam](https://avatars.discourse-cdn.com/v4/letter/b/779978/32.png) [@badhonsoam](https://discourse.haproxy.org/u/badhonsoam)\
**Post date:** [November 8, 2017, 7:37am UTC](https://discourse.haproxy.org/t/haproxy-solution-with-same-device/1746/3 "2017-11-08T07:37:01Z")

</div>

25 add-apt-repository ppa:vbernat/haproxy-1.6  
26 apt-get update  
27 apt-get install haproxy -y  
28 cp /etc/haproxy/haproxy.cfg /etc/haproxy/haproxy.cfg.original  
30 /etc/init.d/haproxy start  
31 vim /etc/default/haproxy  
32 vim /etc/haproxy/haproxy.cfg  
global  
log /dev/log local0  
log /dev/log local1 notice  
chroot /var/lib/haproxy  
stats socket /run/haproxy/admin.sock mode 660 level admin  
stats timeout 30s  
user haproxy  
group haproxy  
daemon

```
    # Default SSL material locations
    ca-base /etc/ssl/certs
    crt-base /etc/ssl/private

    # Default ciphers to use on SSL-enabled listening sockets.
    # For more information, see ciphers(1SSL). This list is from:
    # https://hynek.me/articles/hardening-your-web-servers-ssl-ciphers/
    ssl-default-bind-ciphers ECDH+AESGCM:DH+AESGCM:ECDH+AES256:DH+AES256:ECDH+AES128:DH+AES:ECDH+3DES:DH+3DES:RSA+AESGCM:RSA+AES:RSA+3DES:!aNULL:!MD5:!DSS
    ssl-default-bind-options no-sslv3

```

defaults  
log global  
mode http  
option httplog  
option dontlognull  
timeout connect 5000  
timeout client 50000  
timeout server 50000  
errorfile 400 /etc/haproxy/errors/400.http  
errorfile 403 /etc/haproxy/errors/403.http  
errorfile 408 /etc/haproxy/errors/408.http  
errorfile 500 /etc/haproxy/errors/500.http  
errorfile 502 /etc/haproxy/errors/502.http  
errorfile 503 /etc/haproxy/errors/503.http  
errorfile 504 /etc/haproxy/errors/504.http

listen mysql-galera-cluster 0.0.0.0:3307  
#balance roundrobin  
balance leastconn  
mode tcp  
option tcpka  
option tcplog  
option mysql-check user haproxy  
server [mdb1.example.com](http://mdb1.example.com) 192.168.25.87:3306 check weight 1  
server [mdb2.example.com](http://mdb2.example.com) 192.168.25.88:3306 check weight 1

---

<div class="post-metadata">

**Author:** ![lukastribus](https://avatars.discourse-cdn.com/v4/letter/l/7ea924/32.png) [@lukastribus](https://discourse.haproxy.org/u/lukastribus)\
**Post date:** [November 8, 2017, 11:27am UTC](https://discourse.haproxy.org/t/haproxy-solution-with-same-device/1746/4 "2017-11-08T11:27:48Z")

</div>

On the client, are you connecting towards the default mysql port 3306 or the TCP port you configured the load-balancer on, which is 3307?