[DOC] defining socket in my.cnf breaks startup/shutdown on Ubuntu

[Scott Larson]

When the socket variable is defined in /etc/my.cnf in the [mysqld] section on Ubuntu 11.10 and 12.04, even when set to the location which Percona defaults to when left undefined, the startup/shutdown via init.d breaks. Consequently if you have a my.cnf with this variable defined in place before you've done the install, the install process will fail to complete correctly.

[Przemek (pmalkowski)]

I can confirm that XtraDB Cluster (5.5.27) fails to install via apt-get, but only when there is my.cnf left by another package, like mysql-common. apt-get removes the mysql-common to solve dependencies, but does not purge it's config.
In my case, it failed due to bind_address = 127.0.0.1 in my.cnf with error:

mysqld_safe[5340]: 120918 10:25:50 [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

All I had to do to make it install properly was:
apt-get purge mysql-common

[Raghavendra D Prabhu (raghavendra-prabhu)]

@Przemek,

Is this still happening?

[Przemek (pmalkowski)]

@Raghavendra,

Yes, checked with 5.5.30-23.7.4-405.precise version.
To be exact: if you have my.cnf with a variable that prevents XtraDB Cluster from start, like bind_address = 127.0.0.1, the install fails on final configuration stage, so the package status is:
iF percona-xtradb-cluster-server-5.5 5.5.30-23.7.4-405.precise Percona Server database server binaries

But that's a normal Ubuntu and Debian style - the service must be successfully started in order to confirm the package install has been completed. So I don't think this is a bug. All you have to do to finalize the install is to fix the my.cnf and do:
dpkg --configure percona-xtradb-cluster-server-5.5

I can't confirm the socket variable problem though, when I set it to the same as default, that is:
socket = /var/run/mysqld/mysqld.sock
the init script works well, as well as installation process.

[Raghavendra D Prabhu (raghavendra-prabhu)]

bind_address = 127.0.0.1 is incompatible with mysqldump SST method. There is no fixing required here.
By default bind_address is 0.0.0.0 and sst method is mysqldump.

This probably needs to be documented somewhere.

[Raghavendra D Prabhu (raghavendra-prabhu)]

rsync is the default SST method, so this shouldn't affect unless mysqldump is used intentionally.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1040