# PXC 5.5.28 Pb with multiple addresses

**URL:** <https://forums.percona.com/t/pxc-5-5-28-pb-with-multiple-addresses/2517>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [December 11, 2012, 8:30am UTC](https://forums.percona.com/t/pxc-5-5-28-pb-with-multiple-addresses/2517 "2012-12-11T08:30:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![azigui](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@azigui](https://forums.percona.com/u/azigui)\
**Post date:** [December 11, 2012, 8:30am UTC](https://forums.percona.com/t/pxc-5-5-28-pb-with-multiple-addresses/2517/1 "2012-12-11T08:30:31Z")

</div>

Hi,

I upgrade my PXC in 5.5.28 but I have a problem with wsrep\_cluster\_address variable for multiple addresses in the first node.  
With wsrep-url, my values was :  
wsrep\_url = gcomm://ip\_node2:4567,gcomm://ip\_node3:4567,gcom://

How can I apply this values with wsrep\_cluster\_address.  
At the moment I put like this :  
wsrep\_cluster\_address = gcomm://,ip\_node2:4567,ip\_node3:4567.  
The problem is if I restart the first node is in like a split brain, the wsrep\_cluster\_size’s equal to 1 instead to 3. And the others nodes are equal to 2.

Thx for your help

Best regards

---

<div class="post-metadata">

**Author:** ![lefred](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lefred/32/16885_2.png) [@lefred](https://forums.percona.com/u/lefred)\
**Post date:** [December 18, 2012, 4:34am UTC](https://forums.percona.com/t/pxc-5-5-28-pb-with-multiple-addresses/2517/2 "2012-12-18T04:34:03Z")

</div>

Hi,

wsrep\_cluster\_address syntax doesn’t require the port (and should be in [mysqld] and not in [mysqld\_slave], just to confirm).

So could you try with (I put some random ip’s):

wsrep\_cluster\_address=gcomm://192.168.70.2,192.168.70.3

And watch out the first comma in your setting, this is incorrect, with wsrep\_cluster\_address, you don’t have anymore the empty gcomm://

so you need to start the first time your cluster with:  
wsrep\_cluster\_address=gcomm://

and then modify that setting in my.cnf and never have the empty gcomm anymore (until all your nodes are off)

regards,

---

<div class="post-metadata">

**Author:** ![azigui](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@azigui](https://forums.percona.com/u/azigui)\
**Post date:** [December 18, 2012, 8:26am UTC](https://forums.percona.com/t/pxc-5-5-28-pb-with-multiple-addresses/2517/3 "2012-12-18T08:26:04Z")

</div>

Hi,

Thanks for your help but my cluster is in service for a long time.  
I’m afraid if I stop all nodes and I want restart first node it doesn’t work with your second config modification

How can I obtain like this wsrep\_urls= gcomm://192.168.60.12:4567,gcomm://192.168.60.13:4567,gcomm: // but with wsrep\_cluster\_address variable

Best regards,

---

<div class="post-metadata">

**Author:** ![azigui](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@azigui](https://forums.percona.com/u/azigui)\
**Post date:** [January 21, 2013, 5:07am UTC](https://forums.percona.com/t/pxc-5-5-28-pb-with-multiple-addresses/2517/4 "2013-01-21T05:07:47Z")

</div>

Hi lefred,

have you find a solution for my problem, because my first node is crashed impossible to start it.  
So it’s impossible to start PXC on my 2 and 3 node.  
With this upgrade I lose my HA availability because multiple adress function doesn’t work

Best regards

---

<div class="post-metadata">

**Author:** ![lefred](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lefred/32/16885_2.png) [@lefred](https://forums.percona.com/u/lefred)\
**Post date:** [January 21, 2013, 5:32am UTC](https://forums.percona.com/t/pxc-5-5-28-pb-with-multiple-addresses/2517/5 "2013-01-21T05:32:32Z")

</div>

The only solution you currently have is:

in my.cnf, set something like :  
wsrep\_cluster\_address=gcomm://192.1.1.1,192.1.1.2,192.1.1.3

and the first node that you will start you need (it works on redhat like distro, no idea yet on debian like) to start the first node like this :

/etc/init.d/mysql start --wsrep-cluster-address=“gcomm://”
