Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

MySQL³£ÓõÄÃüÁî

MYSQLÖг£ÓõÄÃüÁî´óÈ«
Ò»¡¢    Êý¾Ý¿â²Ù×÷µÄÃüÁî
1.  ´´½¨Êý¾Ý¿â
Ø  create database Name;
2.  Ñ¡ÔñÊý¾Ý¿â
Ø  use DatabaseName;
3.  Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
Ø  drop database Name;
4.  ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
Ø  drop ......

LAMP(Linux+Apache+MySQL+PHP)·þÎñÆ÷µÄÐÔÄÜÓÅ»¯

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

railsʹÓÃsqlite3ºÍmysqlµÄÎÊÌâ

1¡¢Èç¹ûʹÓÃsqlite3ʱ³öÏÖÈçÏ´íÎó£º
/!\ FAILSAFE /!\  Thu Jul 30 22:16:15 +0800 2009
  Status: 500 Internal Server Error
  unknown error
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize'
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'
&nb ......

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

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

°²×°UCenter¹ý³ÌÖС°²»Ö§³ÖMysqlÊý¾Ý¿â¡±µÄ½â¾ö·½·¨

°´ÕÕ¹Ù·½ÌṩµÄ“UCenter 1.5.0 °²×°Í¼ÎĽ̳̔£¬ÎÒ¿ªÊ¼×°ÉÏphp5,mysql5,apache2.2£¬½á¹ûÔÚhttp://127.0.0.1/ucenter/install/index.phpʱÓöµ½ÁËÁîÈËÓôÃÆµÄÒ»¿Ì£¬
²é²é×ÊÁÏÒ»¿´£¬ÓкܶàÅóÓѶ¼Óöµ½ÀàËÆÇé¿ö£¬¶øÇÒÎʵÄÌû×Óµ½ÏÖÔÚ»¹Ã»Óиø»Ø£¬ÐÄÀíÄÉÃÆÑ½£¬ÎªÉ¶UcenterµÄÌṩ¹«Ë¾“¿µÊ¢´´Ï딵Ŀª·¢ÈËÔ±²» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ