Oracle 5.0, Reference Manual

Page: 1414 / 3232

Installing MySQL Proxy
1394
System requirements for the MySQL Proxy application are the same as the main MySQL server.
Currently MySQL Proxy is compatible only with MySQL 5.0.1 and later. MySQL Proxy is provided as a
standalone, statically linked binary. You need not have MySQL or Lua installed.
15.7.2. Installing MySQL Proxy
You have three choices for installing MySQL Proxy:
• Precompiled binaries are available for a number of different platforms. See Section 15.7.2.1,
“Installing MySQL Proxy from a Binary Distribution” .
• You can install from the source code to build on an environment not supported by the binary
distributions. See Section 15.7.2.2, “Installing MySQL Proxy from a Source Distribution” .
• The latest version of the MySQL Proxy source code is available through a development repository
is the best way to stay up to date with the latest fixes and revisions. See Section 15.7.2.3, “Installing
MySQL Proxy from the Bazaar Repository” .
15.7.2.1. Installing MySQL Proxy from a Binary Distribution
If you download a binary package, you must extract and copy the package contents to your desired
installation directory. The package contains files required by MySQL Proxy, including additional Lua
scripts and other components required for execution.
To install, unpack the archive into the desired directory, then modify your
PATH
environment variable so
that you can use the
mysql-proxy
command directly:
shell> cd /usr/local
shell> tar zxf mysql-proxy-0.8.2-platform.tar.gz
shell> PATH=$PATH:/usr/local/mysql-proxy-0.8.2-platform/sbin
To update the path globally on a system, you might need administrator privileges to modify the
appropriate
/etc/profile
,
/etc/bashrc
, or other system configuration file.
On Windows, you can update the
PATH
environment variable using this procedure:
1. On the Windows desktop, right-click the My Computer icon, and select Properties.
2. Next select the Advanced tab from the System Properties menu that appears, and click the
Environment Variables button.
3. Under System Variables, select Path, then click the Edit button. The Edit System Variable
dialogue should appear.
The Microsoft Visual C++ runtime libraries are a requirement for running MySQL Proxy as of version
0.8.2. Users that do not have these libraries must download and install the Microsoft Visual C++ 2008
Service Pack 1 Redistributable Package MFC Security Update. Use the following link to obtain the
package:
http://www.microsoft.com/download/en/details.aspx?id=26368
15.7.2.2. Installing MySQL Proxy from a Source Distribution
You can download a source package and compile the MySQL Proxy yourself. To build from source,
you must have the following prerequisite components installed:
•
libevent
1.x or higher (1.3b or later is preferred).
•
lua
5.1.x or higher.
•
glib2
2.6.0 or higher.
•
pkg-config
.
•
libtool
1.5 or higher.