PrimeBase XT Download

The source code control system used is bazaar. You can checkout the root source tree usng the following command:

bzr branch lp:pbxt pbxt

• A UNIX user: <unix-user>, For example: my-user
• A "build" directory: <build-dir>. For example: /home/my-user/build
• A MySQL test directory: <mysql-dir>. For example: /home/my-user/mysql
• The MySQL 5.1 source tree: <mysql-src>.tar.gz. For example: mysql-5.1.47.tar.gz
• The PBXT source tree: <pbxt-src>.tar.gz. For example: pbxt-1.0.11-6-pre-ga.tar.gz

1. Unpack the source trees in the build directory:

cd <build-dir>
gunzip -c <mysql-src>.tar.gz | tar -x
gunzip -c <pbxt-src>.tar.gz | tar -x

2. Configure, build and install MySQL:

cd <build-dir>/<mysql-src>
./configure --prefix=<mysql-dir> --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-plugins=max-no-ndb --with-embedded-server --enable-local-infile --with-mysql-user=<unix-user>
make
make install

3. Configure, build and install PBXT:

cd <build-dir>/<pbxt-src>
./configure --with-mysql=<build-dir>/<mysql-src>
make install

4. Install the MySQL database:

cd <mysql-dir>
bin/mysqld_install_db --no-defaults

5. Start the MySQL server (in the foreground):

libexec/mysqld --no-defaults

6. Install the PBXT plug-in (using a second terminal):

cd <mysql-dir>
bin/mysql -uroot

mysql> INSTALL PLUGIN PBXT SONAME 'libpbxt.so';

7. Create a test table:

mysql> use test;
mysql> CREATE TABLE a_test_tab (id INT, string VARCHAR(100)) ENGINE=PBXT;

8. Shutdown the MySQL server:

cd <mysql-dir>
bin/mysqldadmin -uroot shutdown

Note, if these instruction do not work it may be due to a change in MySQL. Please refer to the documentation for more details on building and installing PBXT.

Install the MySQL binary distribution specified for the plugin above.

2. Determine the plugin directory:

mysql> show variables like "%plugin%";
+---------------+-----------------------------+
| Variable_name | Value                       |
+---------------+-----------------------------+
| plugin_dir    | /usr/local/mysql/lib/plugin |
+---------------+-----------------------------+
1 row in set (0.01 sec)

3. Copy the plugin into the plugins directory:

cp libpbxt.so /usr/local/mysql/lib/plugin

4. Install the PBXT plug-in (using a second terminal):

mysql> INSTALL PLUGIN PBXT SONAME 'libpbxt.so';