Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

תһƪ²âÊÔ 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)·þÎñÆ÷µÄÐÔÄÜÓÅ»¯

Ä¿Ç°LAMP (Linux + Apache + MySQL + PHP) ½ü¼¸ÄêÀ´·¢Õ¹Ñ¸ËÙ£¬ÒѾ­³ÉΪWeb ·þÎñÆ÷µÄÊÂʵ±ê×¼¡£LAMP 
Õâ¸ö´ÊµÄÓÉÀ´×îÔçʼÓڵ¹úÔÓÖ¾“c't Magazine”£¬Michael KunzeÔÚ1990Äê×îÏÈ°ÑÕâЩÏîÄ¿×éºÏÔÚÒ»Æð´´ÔìÁËLAMPµÄËõд×Ö¡£ÕâЩ×é¼þËäÈ»²¢²»ÊÇ¿ª¿ªÊ¼¾ÍÉè¼ÆΪһÆðʹÓõģ¬µ«ÊÇ£¬ÕâЩ¿ªÔ´Èí¼þ¶¼¿ÉÒԺܷ½±ã µÄË ......

¹¹½¨¸ßÐÔÄܵÄMYSQLÊý¾Ý¿â(¶þ) °ÑÄÇЩƿ¾±¸øÕÒ³öÀ´

Ò»¡¢´ÓÄÄÀïÈëÊÖ
     µ±Ò»Ì¨MYSQL·þÎñÆ÷´î½¨Íê³É²¢¿ÉÒÔÕý³£ÔËÐÐʱ£¬ÊDz»ÊÇÎÒÃǵĽŲ½¾ÍÍ£Ö¹ÁË£¬×ÔÒÔΪ¿ÉÒÔ¿ªÊ¼Ê¹ÓÃÁË£¬¶ÔרҵÈËÊ¿À´ËµÆäʵ»¹ÐèÒª¸ü¶àµÄÏà¹ØÓÅ»¯ºÍÉèÖá£ÔõôȥÓÅ»¯£¿ÔõôȥÉèÖã¿Ê×ÏÈÎÒÃǵÃÕÒµ½ËüµÄÆ¿¾±£¬ÎÒÏÖÔÚËùÁ˽âµÄÓÐÁ½ÖÖ·½·¨£¬Ò»ÊÇ»ù×¼²âÊÔ£¬¶þ¾ÍÊdzÌÐò·ÖÎö£¬ËûÃÇÓÐ×ÅÃÜÇеÄÁªÏµ ......

MySql ÅжϺº×Ö¡¢ÈÕÆÚ¡¢Êý×ֵĺ¯Êý

¼¸¸öƽ³£ÓõÄmysqlº¯Êý
/*****************************************************
1.ÅжÏ×Ö·û´®ÊÇ·ñΪºº×Ö ·µ»ØÖµ£º1-ºº×Ö 0-·Çºº×Ö
*****************************************************/
DROP FUNCTION IF EXISTS fc_is_hanzi;
CREATE FUNCTION  fc_is_hanzi(
p_str VARCHAR(1024)
)
    ......

MySQLÊý¾Ý¿â³£Ê¹ÓõÄһЩÃüÁî

Ò»¡¢Êý¾Ý¿âÁ¬½Ó
ÃüÁmysql -uÓû§Ãû -pÃÜÂë
¡¡¡¡¡¡mysql -h·þÎñÆ÷ -uÓû§Ãû -pÃÜÂë
¡¡¡¡¡¡mysql -h·þÎñÆ÷ -P¶Ë¿Ú -uÓû§Ãû -pÃÜÂë -DÊý¾Ý¿âÃû
˵Ã÷£ºÁ¬½Óµ½MySQLÊý¾Ý¿â·þÎñÆ÷£¬Èç¹ûÖ¸¶¨ÁË“-DÊý¾Ý¿â”²ÎÊý£¬»á½«Ö¸¶¨µÄÊý¾Ý¿âÉèΪ»î¶¯Êý¾Ý¿â¡£
Àý×Ó£ºmysql -hlocalhost -P3306 -uroot -p123456 -Dtest ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ