MySQL patches by Codership

MySQL server and wsrep

Asked by Sebastian

Hi,

Is it possible to install/compile "Galera" with native MySQL server included with original CentOS 6.2 repositories?
I've installed the .rpm package (https://launchpad.net/codership-mysql/5.1/5.1.59-22.2) but now I have some dependencies issue with "mysql-libs" for "postfix".

I'm wondering if I can use Galaera on minimal CentOS install without any external .rpm packages?

Kind Regards

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL patches by Codership Edit question
Assignee:
No assignee Edit question
Solved by:
Alex Yurchenko
Solved:
Last query:
Last reply:
Revision history for this message
Alex Yurchenko (ayurchen) said : 		#1

Hi,

It should be possible to do on minimal CentOS install, and the easiest option would be to use a binary tarball package that can be installed without causing conflicts with any RPMs.

If you want to go RPM way, mysql-wsrep RPMs were designed to substitute official Oracle mysql-server RPMs and so are built according to Oracle's mysql.spec file. Oracle RPMs are incompatible with native CentOS RPMs (due to different file layout). The best approach to resolve this would be
1) remove all mysql RPMs from CentOS, with --no-deps flag if necessary.
2) install mysql-client and mysql-shared-compat RPMs from Oracle (http://downloads.mysql.com/archives.php?p=mysql-5.1&v=5.1.60) - this should cover all other packages dependencies
3) install mysql-wsrep RPM

BTW, don't forget to install Galera wsrep provider (https://launchpad.net/galera/1.x/22.1.1) - it is a separate package. Without it mysql-wsrep is just a regular MySQL server.

Revision history for this message
Sebastian (sebastian-seo) said : 		#2

Hi Alex,

Thanks for your reply.

So I can install Galera on CentOS with default MySQL server (current version: 5.1.52)? I just need to compile the following binary tarball package - http://launchpad.net/galera/1.x/22.1.1/+download/galera-22.1.1-src.tar.gz. Is that correct?
This way I won't have to manually update MySQL server in the future and I could update the servers with YUM.

If the above option is not possible I will try RPM route.

Regards
Sebastian

Revision history for this message
Best Alex Yurchenko (ayurchen) said : 		#3

Sebastian,

You can compile Galera from source, or download and install precompiled RPM - but it is only a replication library.

Next you need MySQL server that can load and use that library and that's what wsrep patch for MySQL is about. Default MySQL server from CentOS (or Oracle) cannot do that.

So as I explained earlier, you need to install MySQL from https://launchpad.net/codership-mysql either from a binary tarball or an RPM or compile from source. MySQL server RPM from CentOS is useless for you.

The advantage of a binary tarball is that you don't have to update mysql-client and mysql-shared RPMs that come with CentOS to Oracle's, but it is of dubious benefit.

Revision history for this message
Sebastian (sebastian-seo) said : 		#4

Thanks Alex Yurchenko, that solved my question.