error installing xtradb-cluster on Ubuntu(mysqld refuse to start)

[Anatoly]

mysqld fail to start after fresh install of percona-xtradb cluster on Ubuntu 12.04(LTS) via apt.

Log message:
120802 20:08:21 [ERROR] WSREP: wsrep_sst_method is set to 'mysqldump' yet mysqld bind_address is set to '127.0.0.1', which makes it impossible to receive state transfer from another node, since mysqld won't accept such connections. If you wish to use mysqldump state transfer method, s
120802 20:08:21 [ERROR] Aborting

Default bind_address is set to 127.0.0.1 and due to https://bugs.launchpad.net/codership-mysql/+bug/800138, mysql refuse to start. Even if you add bind_address = <some ip>, mysqld refuse start until you remove "127.0.0.1".

[Przemek (pmalkowski)]

I don't think this is a bug.
All you have to do is to make sure there is no old my.cnf before you install, or make sure the configuration is correct.
Percona XtraDB Cluster (checked latest 5.5.30-30.2) won't install any my.cnf with wrong defaults.

If you set bind_address = 127.0.0.1 in your my.cnf, even if Percona XtraDB Cluster was successfully installed before - it won't start if you also leave the wsrep_sst_method at default value (mysqldump). I think this is just expected behaviour.

If you wan't a node working with bind_address = 127.0.0.1 you must specify different wsrep_sst_method, like xtrabackup.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Marking this a duplicate of lp:1026771 (which is being handled as documentation bug).