XtraDB cluster installation and setup


I want to install XtraDB cluster setup in same machine having 2 different nodes in EC2 instance having RHEL6

I have gone through this link http://www.percona.com/doc/percona-xtradb-cluster/installation/yum_repo.html#yum-repo but I am getting these errors:
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

Also, I do not have any MySQL server running in this machine… so it’s a completely new machine.

  1. How to setup Percona XtraDB cluster in single machine having two nodes?
  2. Do I require MySQL also to be installed along with Percona Cluster?

A step-by-step guide would be helpful.

I know this might be easy questions to you but I am completely new to cluster environment … we are switching from MySQL replication to Cluster environment for HA.

What is the actual yum conflict you are having? Include the yum output. Probably you have some MySQL packages installed already.

Also regarding more then one node on single box: http://www.percona.com/doc/percona-xtradb-cluster/howtos/singlebox.html

Error: Execution of ‘/usr/bin/yum -d 0 -e 0 -y install Percona-XtraDB-Cluster-server-56’ returned 1:

Error Downloading Packages:
1:Percona-XtraDB-Cluster-shared-56-5.6.14-25.1.596.rhel6.x86_64: failure: Percona-XtraDB-Cluster-shared-56-5.6.14-25.1.596.rhel6.x86_64.rpm from percona
: [Errno 256] No more mirrors to try.
1:Percona-XtraDB-Cluster-client-56-5.6.14-25.1.596.rhel6.x86_64: failure: Percona-XtraDB-Cluster-client-56-5.6.14-25.1.596.rhel6.x86_64.rpm from percona
: [Errno 256] No more mirrors to try.
percona-xtrabackup-2.1.6-702.rhel6.x86_64: failure: percona-xtrabackup-2.1.6-702.rhel6.x86_64.rpm from percona: [Errno 256] No more mirrors to try.
1:Percona-XtraDB-Cluster-server-56-5.6.14-25.1.596.rhel6.x86_64: failure: Percona-XtraDB-Cluster-server-56-5.6.14-25.1.596.rhel6.x86_64.rpm from percona
: [Errno 256] No more mirrors to try.
Percona-XtraDB-Cluster-galera-3-3.1-1.182.rhel6.x86_64: failure: Percona-XtraDB-Cluster-galera-3-3.1-1.182.rhel6.x86_64.rpm from percona: [Errno 256] No
more mirrors to try.

Jarjis, so you are using testing repo it seems. Show me:
curl -I http://repo.percona.com/testing/centos/6/os/x86_64/Percona-XtraDB-Cluster-server-56-5.6.14-25.1.596.rhel6.x86_64.rpm

Also, for production purposes I would suggest to use our standard repository, not testing.

I tried using the following repos


Result some what the same. I’m using CentOS 6.4 and Puppet Enterprise 3.1

[root@esgsql02 etc]# curl -I http://repo.percona.com/testing/cent…el6.x86_64.rpm
HTTP/1.0 404 Not Found
Date: Mon, 16 Dec 2013 14:23:37 GMT
Server: Apache
Vary: Accept-Encoding
Content-Type: text/html; charset=iso-8859-1
X-Cache: MISS from coacache.austintexas.gov
X-Cache-Lookup: MISS from coacache.austintexas.gov:3128
Via: 1.0 coacache2.austintexas.gov (squid/3.1.10)
Connection: keep-alive

OK, so you are behind a squid proxy that may mess up with something. Are you able to bypass it?
Also, the link I gave you is truncated by forum (full URL is shown when you hover over with mouse).
The correct curl command is:

curl -I http://repo.percona.com/testing/centos/6/os/x86_64/Percona-XtraDB-Cluster-server-56-5.6.14-25.1.596.rhel6.x86_64.rpm

btw, pretty please don’t ask for the same thing in 5 different forum threads…