CODEWITHSUNDEEP
mysqlcluster-computingpercona
avhacker
avhacker

Reputation: 677

Percona cluster not running in cluster mode

I'm setting up a percona cluster (ver 5.6) on CentOS 6.5 in AWS ec2 according to the official guide: How to setup 3 node cluster in EC2 enviroment

When I run this command on the first node:

/etc/init.d/mysql bootstrap-pxc

or

service mysql bootstrap-pxc

The output on my console is

Starting MySQL (Percona XtraDB Cluster).. SUCCESS!

Not the output from the guide:

2014-01-30 11:52:35 23280 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.6.15-56' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release 25.3, Revision 706, wsrep_25.3.r4034

Looks like it's running in single server mode, not the cluster mode.

Then I start mysql service on the second node:

service mysql start

and get this error:

Starting MySQL (Percona XtraDB Cluster)...................................... ERROR! The server quit without updating PID file (/mnt/data/ben-ec2-usw1.pid).

ERROR! MySQL (Percona XtraDB Cluster) server startup failed!

Can anyone help on this? Thanks.

Upvotes: 0

Views: 949

Answers (1)

utdrmac
utdrmac

Reputation: 780

You may have misread the guide. This output: Starting MySQL (Percona XtraDB Cluster).. SUCCESS! comes from the service command. This output:

2014-01-30 11:52:35 23280 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.6.15-56' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release 25.3, Revision 706, wsrep_25.3.r4034

comes from a tail of the mysql error log file.

On your second node, did you examine the error log for the failure reason? Did you correctly configure gcomm:// URI in the my.cnf of node2? Did you open all necessary ports in the AWS security groups?

Upvotes: 0

Related Questions