在Centos 5.2下安装最新的MySQL Proxy-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

在Centos 5.2下安装最新的MySQL Proxy

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:53 PM

centos

mysql proxy的代码树已经迁移到lauchpad，采用bazaar进行版本管理。参考了一些文档，在centos 5.2下编译安装最新mysql proxy成功

mysql proxy的代码树已经迁移到lauchpad，采用bazaar进行版本管理。参考了一些文档，在CentOS 5.2下编译安装最新mysql proxy成功。步骤记录如下（在centos 5下应该也适用）：

首先让EPEL (Extra Packages for Enterprise Linux) repository 生效
# rpm -Uvh
确定这些包已经安装：GNU Autotools, flex, pkg-config, bazaar, MySQL client libraries
# yum install autoconf automake libtool flex pkgconfig bzr mysql-devel
centos下自带的libevent版本超老，这个没有别的办法，只能自己重新编译，，版本需要在1.4.0以上，越高越好

$ wget ~provos/libevent-1.4.9-stable.tar.gz
$ tar zvfx libevent-1.4.9-stable.tar.gz
$ cd libevent-1.4.9-stable
$ ./configure
$ make
# make install

centos自带的glib版本也比较老，mysql proxy 0.7.0以上需要glib2 2.16.0以上才能编译成功，因此不得不重新编译glib

$ wget
$ tar zvfx glib-2.18.4.tar.gz
$ cd glib-2.18.4
$ ./configure
$ make
# make install

编译安装lua 5.1

$ wget
$ tar zvfx lua-5.1.4.tar.gz
$ cd lua-5.1.4
$ vi src/Makefile

在CFLAGS里加上-fPIC，因为我在64位机上编译出现了“relocations”错误

$ make linux
# make install
# cp etc/lua.pc /usr/local/lib/pkgconfig/

重要：让pkg-config找到自己编译的库在哪里

$ export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/lib/pkgconfig

最后，从bazaar中检出最新的mysql-proxy源文件进行编译：

$ bzr branch lp:mysql-proxy
$ cd mysql-proxy
$ ./autogen.sh
$ ./configure
$ make
# make install

编译完成，可以检查一下最终结果：

# mysql-proxy -V

mysql-proxy 0.7.0
glib2: 2.18.4
libevent: 1.4.9-stable
admin: 0.7.0
proxy: 0.7.0

配置启动脚本，在系统启动时运行mysql-proxy

cd /etc/init.d
wget
chmod 0755 /etc/init.d/mysql-proxy
chkconfig mysql-proxy on

增加运行参数

cat >/etc/sysconfig/mysql-proxy

# Options to mysql-proxy
# do not remove –daemon
PROXY_OPTIONS=”–daemon”

CTRL+D保存，然后就可以使用以下命令启动|停止mysql-proxy

/etc/init.d/mysql-proxy start|stop

作者: Volcano 发表于March 14, 2009 at 10:09 pm

版权信息: 可以任意转载, 转载时请务必以超链接形式标明文章原始出处和作者信息及此声明

永久链接 -

linux

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AM

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AM

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

See all articles