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

¼ÇÏÂЩlinuxÏÂmysqlµÄ²Ù×÷£¬ÒÔ±ãÒÔºó²é¿´£º
1. Æô¶¯£¬¹Ø±Õmysql£º
Æô¶¯£ºsudo /etc/init.d/mysql start
¹Ø±Õ£º/usr/bin/mysqladmin -uroot -p shutdown
2.ÏÔʾ ±í½á¹¹£º
describe:tableName
3.±¸·Ý£º
Ö»±¸·Ý±í½á¹¹£ºmysqldump -d -uroot -p  DataBase TableName> xxx.sql
±¸·Ý±í½á¹¹ºÍÊý¾Ý£ºmysqldump -uro ......

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

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

mysqlÊý¾Ý¿â×Ô¶¯¶¨ÆÚ±¸·ÝµÄ½Å±¾

˵Ã÷£º
±£ÁôÿÌ챸·ÝµÄÊý¾ÝÊǼþ²»Ì«ÏÖʵµÄÊ£¬×öºÃµÄ×ö·¨ÊDZ£ÁôǰÈýÌìµÄ
±¸·ÝÊý¾Ý¡£°Ñ±¸·ÝµÄÊý¾Ý´ò°ü²¢Ñ¹Ëõ£¬ÎļþÃûÒÔϵͳʱ¼äÃüÃû£¬´ò°üºóµÄ
±¸·ÝÎļþ·ÅÔÚÒ»¸öÌØ¶¨µÄÎļþ¼ÐÏÂÃæ£¬Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÒÔʱ¼äÃüÃû±¸·ÝÎļþ£¬
ls ÃüÁîºó£¬Îļþ½«×Ô¶¯°´Ê±¼äÅÅÐòµÄ£¬ÕâÑù¾Í¿ÉÒÔ·½±ãµÄɾ³ýÈýÌìÒÔǰµÄ±¸·ÝÎļþ£¬ÓÚÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ