Can I install percona cluster with mysql 5.6 BINARY version?

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Good morning, I read documents in website. It looks I can install rpm package or source code package. But, I don’t see the information about mysql server. I have installed mysql with BINARY version. The mysql folder is /usr/local/mysql.

I tried to install percona cluster by rpm. And I found the mysql was “updated” too. My package is “Percona-XtraDB-Cluster-5.6.26-25.12-r624ef81-el5-x86_64-bundle.tar”. My system is Redhat Release 5.5.

So, my question is:

  1. Can I install percona cluster with existing mysql server? And the mysql is a BINARY version.
  2. If yes, should I exclude some packages in the tar file not to install mysql server again?
  3. If #2 doesn’t work, should I install source code? If anybody has a document or URL to show how to complie and install source code with existin mysql? In the percona website, it says to run the BUILD/compile-pentium-wsrap. However, I only find BUILD/compile-pentium and BUILD/compile-pentium64 in the source code package. So, I guess I should type BUILD/compile-pentium64 for x86_64 system.
  4. If #3 is okay, how much package should I download? I see “percona-xtradb-cluster-5.6_5.6.26-25.12.orig.tar.gz”, “percona-xtradb-cluster-galera-3.x_3.12.2-1.jessie.tar.gz”, “percona-xtradb-cluster-galera-3.x_3.12.2-1.vivid.tar.gz” and etc.
  5. If I miss something, please advise. thanks.
2

The recommended method is for you to shutdown the existing mysql service, remove mysql package and then install Percona XtraDB Cluster rpms. You cannot use Galera with regular mysql binaries not built with wsrep API.

You will need the following RPMs
Percona-XtraDB-Cluster-client-56-5.6.26-25.12.1.el5.x86_64.rpm
Percona-XtraDB-Cluster-galera-3-3.12.2-1.rhel5.x86_64.rpm
Percona-XtraDB-Cluster-server-56-5.6.26-25.12.1.el5.x86_64.rpm
Percona-XtraDB-Cluster-shared-56-5.6.26-25.12.1.el5.x86_64.rpm

Also download the latest Percona Xtrabackup rpm for RH5
You will also need to install socat and qpress

3

Hi[B] Jrivera,

thank you for response. Do you mean we can’t install percona cluster for Oracle’s mysql? We have to use percona’s mysql, don’t we?

If yes, based on "[/B]Percona Server Feature Comparison" section in the document of percona mysql, it is based on ORACLE mysql v5.6.13. Am I correct? thanks.

4

Dillon, you may use Galera binaries provided by Codership if you want to have the version closer to vanilla Oracle MySQL.
In PXC, the binaries are based on Percona Server, which in turn is always based on corresponding MySQL version. So, no, that comparison was only made on 5.6.13 example. Then PXC 5.6.26 is based on Percona Server 5.6.26, which is based on MySQL Community 5.6.26. We take the compatibility seriously and we use the same major version numbering as the upstream MySQL.