MySQL Proxy°²×°ºÍʹÓÃ(Ò»)
°´ÕÕÊֲᰲװMySQL Proxy֮ǰÏÈÒª°²×°ÒÔÏÂÈí¼þ 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 MySQL 5.0.x or higher developer files rpm²é¿´libevent $rpm -q libevent
libevent-1.1a-3.2.1 ÃãÇ¿ÓðÉ,¼ÒÏÂÀ´°²×°lua $tar xvzf lua-5.1.4.tar.gz $cd lua-5.1.4 $make linux $make install $cp etc/lua.pc /usr/local/lib/pkgconfig/ Ö®ºó°²×°MySQL Proxy°´×ªÊÀ¼ÌÐø±¨´í,ºÇºÇ,ËäÈ»ÊÖ²áÉ϶ÔÓÚglib2дµÄ°æ±¾ÊÇ2.6.0¼°ÒÔºóʵ¼ÊÔÚMySQL Proxy0.7.2ÉÏÊÇÒªÇó>2.16µÄ,¼ÌÐøÉý¼¶glib2 $tar xvzf glib-2.23.0.tar.gz $cd glib-2.23.0 $./configure $make $make install È»ºóÌáʾ°²×°libevent°æ±¾¹ýµÍ,ÔÎÁË $tar xvzf libevent-1.4.13-stable.tar.gz $cd libevent-1.4.13-stable $./configure $make $make install Õâ´ÎÔÙÈ¥°²×°MySQL Proxy $tar zxf mysql-proxy-0.7.2.tar.gz $cd mysql-proxy-0.7.2 $./configure --with-mysql=/usr/local/mysql/bin/mysql_config --with-lua $make $make install ĬÈϵÄmysql-proxy ±»°²×°µ½/usr/local/sbin/mysql-proxy¶øluaʵÀý½Å±¾ÔòÔÚ/usr/local/share/docÏÂ(²»¹ýºÃÏñÐèҪ֮ǰmake test²ÅÓÐ,²»È·¶¨). ²é¿´ÏÂMySQL ProxyµÄ°æ±¾ $mysql-proxy -V
mysql-proxy: error while loading shared libraries: /usr/local/lib/libmysql-chassis.so.0: cannot restore segment prot after reloc: Permission denied ±¨´í,ÕâÊÇSELinuxµÄÎÊÌâ,¿ÉÈçϽâ¾ö $chcon -t texrel_shlib_t /usr/local/lib/libmysql-chassis.so.0 $ mysql-proxy -V
mysql-proxy 0.7.2
glib2: 2.23.0
libevent: 1.4.13-stable
lua: Lua 5.1.4
LUA_PATH: /usr/local/lib/mysql-proxy/lua/?.lua
LUA_CPATH: /usr/local/lib/mysql-proxy/lua/?.so
2009-12-18 00:05:34: (warning) g_set_prgname() called multiple times
== plugins ==
admin: 0.7.0
proxy: 0.7.0 ÖÁ´ËMySQL Proxy°²×°Íê³É,¼ÇסLUA_PATH: /usr/local/lib/mysql-proxy/lua/?.luaÏÂÃæÒªÓõ½ Æô¶¯,±àÒëÆ
Ïà¹ØÎĵµ£º
MYSQLÓв»Í¬ÀàÐ͵ÄÈÕÖ¾Îļþ(¸÷×Ô´æ´¢Á˲»Í¬ÀàÐ͵ÄÈÕÖ¾)£¬´ÓËüÃǵ±ÖпÉÒÔ²éѯµ½MYSQLÀï¶¼×öÁËЩʲô£¬¶ÔÓÚMYSQLµÄ¹ÜÀí¹¤×÷£¬ÕâЩÈÕÖ¾ÎļþÊDz»¿ÉȱÉٵġ£
1.´íÎóÈÕÖ¾(The error log)£º¼Ç¼ÁËÊý¾Ý¿âÆô¶¯¡¢ÔËÐÐÒÔ¼°Í£Ö¹¹ý³ÌÖдíÎóÐÅÏ¢£»
2.ISAM²Ù×÷ÈÕÖ¾(The isam log)£º¼Ç¼ÁËËùÓжÔISAM±íµÄÐ޸쬏ÃÈÕÖ¾½ö½öÓÃÓÚµ÷ÊÔISAMģʽ ......
»·¾³ÉèÖãº
°²×°ÍêMySQLÖ®ºó£¬½«°²×°Ä¿Â¼ÖеÄincludeĿ¼ÏµÄlibmysql.libÎļþ¿½µ½VS2008°²×°Ä¿Â¼ÖеÄVC\lib\Ï£¬È»ºóÔÚ ÏîÄ¿-Ñ¡Ïî-c/c++-³£¹æ Öеĸ½¼Ó°üº¬Ä¿Â¼ÒÔ¼° Á´½ÓÆ÷-³£¹æ Öеĸ½¼Ó¿âĿ¼ÖмÓÈë“c:\MySQL\include\”£¬²¢ÇÒÔÚ Á´½ÓÆ÷-ÊäÈë Öеĸ½¼ÓÒÀÀµÏîÄÚÌí¼Ó“lib ......
linux
mysql
°²×°½éÉÜ:
linux
·þÎñÆ÷ RedHat 5.0.server.
MySQL
°æ±¾:
ÏÂÔØµØÖ·Á´½Ó:http://dev.mysql
.com/downloads/mysql
/5.1.html
MySQL
·þÎñ¶Ë:MySQL
-server-community-5.1.38-0.rhel5.i386.rpm
MySQL
¿Í»§¶Ë:MySQL
-client-community-5.1.38-0.rhel5.i386.rpm
1 °²×°²½ÖèÊ×ÏȼÓÔØ¹âÇý ......
mysql_affected_rows() ·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£
mysql_close() ¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£
mysql_connect() Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£
mysql_change_user() ¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£
mysql_create_db() ´´½¨Ò ......
nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ
×÷ÕߣºÌïÒÝ(sery@163.com
)
ÆðÒò£ºnagios¿ÉÄÜ¼à¿Øµ½mysql·þÎñµÄÔËÐÐÇé¿ö£¬µ«È·²»ÄÜ¼à¿ØmysqlµÄÖ÷´Ó¸´ÖÆÊÇ·ñÕý³££ºÓÐʱºò£¬Í¬²½ÒѾֹͣ£¬µ«¹ÜÀíÈËԱȴ²»ÖªµÀ¡£
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G
²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊÇij¸ö´Ó·þÎ ......