# Show real host IP/Hostname instead of HAProxy IP

**URL:** <https://forums.percona.com/t/show-real-host-ip-hostname-instead-of-haproxy-ip/4540>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [November 23, 2015, 1:14pm UTC](https://forums.percona.com/t/show-real-host-ip-hostname-instead-of-haproxy-ip/4540 "2015-11-23T13:14:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sanjay92](https://avatars.discourse-cdn.com/v4/letter/s/b9e5f3/32.png) [@sanjay92](https://forums.percona.com/u/sanjay92)\
**Post date:** [November 23, 2015, 1:14pm UTC](https://forums.percona.com/t/show-real-host-ip-hostname-instead-of-haproxy-ip/4540/1 "2015-11-23T13:14:38Z")

</div>

[url][Percona XtraDB Cluster](https://www.percona.com/doc/percona-xtradb-cluster/5.6/howtos/virt_sandbox.html%5B/url%5D)

When I do show processlist, I see host is showing haproxy server not the real host where connection is made. How do I fix it ? Is it haproxy configuration or MySQL configuration change.

In the above mentioned article,  
it says "

BUT, it did not provide enough details. Can you please provide documentation on how to achieve this ?

---

<div class="post-metadata">

**Author:** ![sanjay92](https://avatars.discourse-cdn.com/v4/letter/s/b9e5f3/32.png) [@sanjay92](https://forums.percona.com/u/sanjay92)\
**Post date:** [November 24, 2015, 6:29pm UTC](https://forums.percona.com/t/show-real-host-ip-hostname-instead-of-haproxy-ip/4540/2 "2015-11-24T18:29:15Z")

</div>

Followed this and I can see now real client IP  
[url][https://www.percona.com/blog/2015/10/15/proxy-protocol-percona-xtradb-cluster-quick-guide/[/url]](https://www.percona.com/blog/2015/10/15/proxy-protocol-percona-xtradb-cluster-quick-guide/%5B/url%5D)