תһƪ²âÊÔ Amoeba For MySQLµÄÎÄÕÂ
×÷ÕߣºSky.Jian | ¿ÉÒÔÈÎÒâ×ªÔØ, µ«×ªÔØÊ±Îñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ ºÍ ×÷ÕßÐÅÏ¢ ¼° °æÈ¨ÉùÃ÷
Á´½Ó£ºhttp://www.jianzhaoyang.com/database/amoeba_for_mysql | del.icio.us | Twitter it
ͬÊ Struct Chen µÄ Amoeba For MySQL ÏîÄ¿ÒѾ ³öÀ´²»¶Ìʱ¼äÁË£¬¿ÉһֱûÓÐʱ¼äºÃºÃÌåÑ飬×î½üÒ»Ö±ÔÚ×öһЩÈí¼þºÍÓ²¼þµÄ¹¦ÄÜÒÔ¼°ÐÔÄÜÏà¹ØµÄ²âÊÔ¹¤×÷£¬Amoeba For MySQL×ÔȻҲ½«±»ÁÐÈë¼Æ»®Ö®ÄÚ¡£
¶Ô Amoeba For MySQL µÄ²âÊÔµ½Ä¿Ç°Î»ÖÃÖ÷Òª»¹Êǹ¦ÄÜ·½ÃæµÄ²âÊÔ£¬ÅäÖÃÁËÒ»Ì×ËĄ̈»úÆ÷µÄ»·¾³£º
Server A£º Amoeba Server
Server B£º MySQL Master
Server C£º MySQL Slave1
Server D£º MySQL Slave2
Èí¼þ»·¾³£ºRHEL5.2 £¨X86_64£©£¬JAVA 1.5.0_16£¬ Amoeba For MySQL 0.31
²âÊÔ¹¦ÄÜ£º
1¡¢¶Áд·ÖÀë
2¡¢Êý¾Ý´¹Ö±ÇзÖ
3¡¢Êý¾ÝˮƽÇзÖ
amoeba.xmlÅäÖÃÈçÏ£º
< ?xml version="1.0" encoding="gbk"?>
< !DOCTYPE amoeba:configuration SYSTEM "amoeba.dtd">
<amoeba :configuration xmlns:amoeba="http://amoeba.meidusa.com/">
<server>
<property name="port">8066</property>
<property name="ipAddress">10.0.38.21</property>
<!-- proxy server net IO Read thread size -->
<property name="readThreadPoolSize">500</property>
<!-- proxy server client process thread size -->
<property name="clientSideThreadPoolSize">500</property>
<!-- mysql server data packet process thread size -->
<property name="serverSideThreadPoolSize">500</property>
<!-- socket Send and receive BufferSize(unit:K) -->
<property name="netBufferSize">200</property>
<!-- Enable/disable TCP_NODELAY (disable/enable Nagle's algorithm). -->
&nb
Ïà¹ØÎĵµ£º
ĿǰLAMP (Linux + Apache + MySQL + PHP) ½ü¼¸ÄêÀ´·¢Õ¹Ñ¸ËÙ£¬ÒѾ³ÉΪWeb ·þÎñÆ÷µÄÊÂʵ±ê×¼¡£LAMP
Õâ¸ö´ÊµÄÓÉÀ´×îÔçʼÓڵ¹úÔÓÖ¾“c't Magazine”£¬Michael KunzeÔÚ1990Äê×îÏȰÑÕâЩÏîÄ¿×éºÏÔÚÒ»Æð´´ÔìÁËLAMPµÄËõд×Ö¡£ÕâЩ×é¼þËäÈ»²¢²»ÊÇ¿ª¿ªÊ¼¾ÍÉè¼ÆÎªÒ»ÆðʹÓõ쬵«ÊÇ£¬ÕâЩ¿ªÔ´Èí¼þ¶¼¿ÉÒԺܷ½±ã µÄË ......
1¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL
Ŀ¼ɾ³ý
2¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet003\Services\Eventlog\Application\MySQL
Ŀ¼ɾ³ý
3¡¢HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL
Ŀ¼ɾ³ý ......
¼¸¸öƽ³£ÓõÄmysqlº¯Êý
/*****************************************************
1.ÅжÏ×Ö·û´®ÊÇ·ñΪºº×Ö ·µ»ØÖµ£º1-ºº×Ö 0-·Çºº×Ö
*****************************************************/
DROP FUNCTION IF EXISTS fc_is_hanzi;
CREATE FUNCTION fc_is_hanzi(
p_str VARCHAR(1024)
)
......
Ò».MYSQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin;”ÆäÖÐpathΪMYSQLµÄ°²×°Â·¾¶¡£
¶þ.¼òµ¥µÄ½éÉÜÒ»ÏÂÃüÁîÐнøÈëMYSQLµÄ·½·¨£º
1.C:\>mysql -h hostname -u username -p
°´ENTER¼ü£¬µÈ´ýÈ»ºóÊäÈëÃÜÂë¡£ÕâÀïhostnameΪ·þÎñÆ÷µÄÃû³Æ£¬Èçlocalh ......
MySQL ±¸·ÝºÍ»Ö¸´
ÖÜÁù, 2006/09/30 - 14:21 — yejr
MySQL ±¸·ÝºÍ»Ö¸´
×÷/ÒëÕߣºÒ¶½ðÈÙ£¨Email:
£©£¬À´Ô´£ºhttp://imysql.cn
£¬×ªÔØÇë×¢Ã÷×÷/ÒëÕߺͳö´¦£¬²¢ÇÒ²»ÄÜÓÃÓÚÉÌÒµÓÃ;£¬Î¥Õ߱ؾ¿¡£
ÈÕÆÚ£º2006/10/01
±¾ÎÄÌÖÂÛ MySQL µÄ±¸·ÝºÍ»Ö¸´»úÖ ......