XtraDB cluster installation and setup

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello,

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 [URL]http://www.percona.com/doc/percona-xtradb-cluster/installation/yum_repo.html#yum-repo[/URL] 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.

2

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: [url]Percona XtraDB Cluster

3

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.

4

Jarjis, so you are using testing repo it seems. Show me:
curl -I [url]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[/url]

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

5

I tried using the following repos
[url]http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm[/url]

http://repo.percona.com/testing/centos/$releasever/os/$basearch/"

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

[root@esgsql02 etc]# curl -I [url]http://repo.percona.com/testing/cent...el6.x86_64.rpm[/url]
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

6

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…