Percona-XtraDB binary package for FreeBSD

MySQL & MariaDB Other MySQL® Questions
1

Hi Everyone,

It may seems a stupid question but I didn’t find an answer by myself.

I would like to install Percona-XtraDB-5.1.43-9.1 on our FreeBSD-8 amd64 system. Downloaded the package from http://www.percona.com/percona-builds/Percona-XtraDB/Percona -XtraDB-5.1.43-9.1/FreeBSD/binary/ but I’m not familiar with the procedure to install this package. In FreeBSD I usually make install through the ports tree which is source + freebsd specific parches which get compiled and installed OR freebsd package which includes compiled binaries with additional instructions where they should be located.

I’m looking forward to test Percona releases!

Nik

2

Hi Nik,

The tarball you’ve downloaded is neither FreeBSD package nor port.

  1. You have to untar the archive in /usr/local/.

cd /usr/local/
tar zxf Percona-XtraDB-5.1.43-1.0.6-9.1-FreeBSD-8.0-RELEASE-amd64.ta r.gz

  1. Then create a symlink:

ln -fs Percona-XtraDB-5.1.43-1.0.6-9.1-FreeBSD-8.0-RELEASE-amd64 percona-xtradb

  1. Then create a startup script:

cat /usr/local/etc/rc.d/percona-xtradb.sh

export PATH=$PATH:/usr/local/percona-xtradb/bin:/usr/local/percona- xtradb/libexec

case “$1” in
start)
mysqld_safe &
;;
stop)
killall mysqld
;;
*)
echo “Usage: basename $0 { start | stop }”
;;
esac

  1. Add mysql user

  2. Create a blank database:

export PATH=$PATH:/usr/local/percona-xtradb/bin:/usr/local

mysql_install_db

chown -R mysql /usr/local/percona-xtradb/data

  1. Start Percona-XtraDB:

/usr/local/etc/rc.d/percona-xtradb.sh start

  1. Give us your feedback :slight_smile:
3

All installed well, mysql server is working but it seems that libmysqlclient is not build into the package. Sure enough I can install the client from the normal port.

Now my question is - Is it possible to integrate the patches into the normal FreeBSD port? I’m willing to help but will need more info regarding how your source package differ from the one on mysql. Is it the structure the same, etc.

4

Nik,

The existing FreeBSD ports provide standard MySQL and I believe they should remain as they are.
Instead, in future we have to create a new port and submit it.
Percona Server is based on MySQL + patches of MySQL from [URL]https://code.launchpad.net/percona-patches[/URL] + patches of InnoDB from [URL]https://code.launchpad.net/percona-xtradb.[/URL]
I would appreciate your help, please contact me at aleksandr.kuzminsky_at_percona.com to coordiate efforts.