How do I install Percona and the XtraDB Engine?

[alexj.p...@googlemail.com]

On CentOS 5.5
Added the percona YUM repository easily enough.
But how do I replace MySQL with Percona and select XtraDB as the
engine? Thanks

[unit0x03]

Well, you'd install it in a similar way to how you would under Ubuntu, just with yum:

yum install Percona-Server-server-51

XtraDB is an enhanced InnoDB engine, so any time you'd use InnoDB you're actually getting XtraDB.

Graeme

[Alex Powell]

Ok thanks, I ran that and it said that it has installed. Restarted
MySQL as well, is that it now? Am I running Percona with XtraDB or is
there some settings that need editing first? My tables have already
been updated to be running InnoDB.

Thanks

> --
> You received this message because you are subscribed to the Google Groups
> "Percona Discussion" group.
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to
> percona-discuss...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/percona-discussion?hl=en.
>

[unit0x03]

On Fri, Nov 5, 2010 at 10:45 AM, Alex Powell <alexj.p...@googlemail.com> wrote:

Ok thanks, I ran that and it said that it has installed. Restarted
MySQL as well, is that it now? Am I running Percona with XtraDB or is
there some settings that need editing first? My tables have already
been updated to be running InnoDB.

Sounds like you're good. You can check by connected into the server with the mysql commandline client, it'll tell you the server version you're connecting to. If it says things about Percona and XtraDB, then you're fine. :)

 

[Alex Powell]

"Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4352
Server version: 5.1.51 MySQL Community Server (GPL)"

Not saying anything about Percona or XtraDB. Only command that I have
done is yum install Percona-Server-server-51

[unit0x03]

On Fri, Nov 5, 2010 at 11:04 AM, Alex Powell <alexj.p...@googlemail.com> wrote:

"Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4352
Server version: 5.1.51 MySQL Community Server (GPL)"

This seems to  indicate a non-percona version of the server.

 

Not saying anything about Percona or XtraDB. Only command that I have
done is yum install Percona-Server-server-51

And that succeeded?

Also, is it possible you have a local .my.cnf which points at a different, non-local MySQL instance?

Graeme

 

[Alex Powell]

It said that it installed and a key was issued. I am using WHM/cPanel
on my server

[unit0x03]

On Fri, Nov 5, 2010 at 12:00 PM, Alex Powell <alexj.p...@googlemail.com> wrote:

It said that it installed and a key was issued. I am using WHM/cPanel
on my server

Well, it sounds like this is something you're going to have to debug in your environment. Installing the Percona package should've removed the default MySQL install, so if that hasn't happened, you'll have to take a closer look at your system to see why not.

Graeme

[Alex Powell]

I ran the yum command again to see what would happen and got the
following output from SSH:
Downloading Packages:
warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID cd2efd2a
Public key for Percona-Server-server-51-5.1.51-rel11.5.132.rhel5.x86_64.rpm
is not installed

[Aleksandr Kuzminsky]

Am 05.11.2010 21:33, schrieb Alex Powell:
> I ran the yum command again to see what would happen and got the
> following output from SSH:
> Downloading Packages:
> warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID cd2efd2a
> Public key for Percona-Server-server-51-5.1.51-rel11.5.132.rhel5.x86_64.rpm
> is not installed
>

Alex,

In your environment yum is told to check gpg signature of installed
packages, but the key is not installed.
You should either diables gpg checks in /etc/yum.repos.d/Percona.repo:

gpgcheck=0

or install Percona's repo with correct yum configs and the public key:
rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

-Aleks

[alexj.p...@googlemail.com]

Ok thanks, I changed the gpgcheck to 0 and ran yum update. After
trying to install the package via yum again I get the following
errors:
Transaction Check Error:
file /etc/init.d/mysql from install of Percona-Server-
server-51-5.1.51-rel11.5.132.rhel5.x86_64 conflicts with file from
package MySQL-server-5.1.51-0.glibc23.x86_64

There are a number of these...

On Nov 6, 8:47 am, Aleksandr Kuzminsky <aleksandr.kuzmin...@gmail.com>
wrote:

> Am 05.11.2010 21:33, schrieb Alex Powell:
>
> > I ran the yum command again to see what would happen and got the
> > following output from SSH:
> > Downloading Packages:
> > warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID cd2efd2a
> > Public key for Percona-Server-server-51-5.1.51-rel11.5.132.rhel5.x86_64.rpm
> > is not installed
>
> Alex,
>
> In your environment yum is told to check gpg signature of installed
> packages, but the key is not installed.
> You should either diables gpg checks in /etc/yum.repos.d/Percona.repo:
>
> gpgcheck=0
>
> or install Percona's repo with correct yum configs and the public key:

> rpm -Uhvhttp://www.percona.com/downloads/percona-release/percona-release-0.0-...
>
> -Aleks

>
> > On Fri, Nov 5, 2010 at 7:02 PM, unit0x03 <unit0...@gmail.com> wrote:
> >> On Fri, Nov 5, 2010 at 12:00 PM, Alex Powell
> >> <alexj.powell...@googlemail.com> wrote:
> >>> It said that it installed and a key was issued. I am using WHM/cPanel
> >>> on my server
>
> >> Well, it sounds like this is something you're going to have to debug in your
> >> environment. Installing the Percona package should've removed the default
> >> MySQL install, so if that hasn't happened, you'll have to take a closer look
> >> at your system to see why not.
> >> Graeme
>
> >> --
> >> You received this message because you are subscribed to the Google Groups
> >> "Percona Discussion" group.
> >> To post to this group, send email to percona-d...@googlegroups.com.
> >> To unsubscribe from this group, send email to
> >> percona-discuss...@googlegroups.com.
> >> For more options, visit this group at
> >>http://groups.google.com/group/percona-discussion?hl=en.
>
>
>

>  signature.asc
> < 1KViewDownload

[Aleksandr Kuzminsky]

Am 06.11.2010 15:21, schrieb alexj.p...@googlemail.com:
> Ok thanks, I changed the gpgcheck to 0 and ran yum update. After
> trying to install the package via yum again I get the following
> errors:
> Transaction Check Error:
> file /etc/init.d/mysql from install of Percona-Server-
> server-51-5.1.51-rel11.5.132.rhel5.x86_64 conflicts with file from
> package MySQL-server-5.1.51-0.glibc23.x86_64
>
> There are a number of these...

That's because MySQL-server conflicts with Percona-Server-server-51.
MySQL-server should be deinstalled first.

-Aleks

[alexj.p...@googlemail.com]

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------------------+
| innodb_version | 1.0.12-11.5 |
| protocol_version | 10 |
| version | 5.1.51-rel11.5 |
| version_comment | Percona Server (GPL), 11.5, Revision 132 |
| version_compile_machine | x86_64 |
| version_compile_os | unknown-linux-gnu |
+-------------------------+------------------------------------------+
6 rows in set (0.01 sec)


thanks loads!

On Nov 6, 1:54 pm, Aleksandr Kuzminsky <aleksandr.kuzmin...@gmail.com>
wrote:

>  signature.asc
> < 1KViewDownload