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

LVS & MySQL NDB Cluster

×é³ÉLVS×îÖØÒªµÄ²¿·ÖÓÐÈý¸ö£ºÇëÇó·Ö·¢·þÎñÆ÷¡¢´¦Àí·þÎñÆ÷¡¢¹²Ïí´æ´¢¡£
µäÐ͵ÄWeb¼¯Èº²¢²»ÐèÒª¹²Ïí´æ´¢£¬Ö»ÓÐÇëÇó·Ö·¢·þÎñÆ÷ºÍ´¦Àí·þÎñÆ÷£¬ÈçÏÂͼËùʾ£º
Èç¹ûÍê³ÉÇëÇóÐèÒª»ùÓÚÊý¾Ý£¬ÄÇô¹²Ïí´æ´¢¾ÍÊÇLVS±ØÐëµÄ×é¼þÁË¡£LVSÓʼþ·þÎñÆ÷¼¯ÈºÈçÏÂËùʾ£º
ĿǰÄÜÓ¦ÓÃÓÚLVSµÄMySQL¼¯ÈºÖ»ÄÜÊÇNDB Cluster£¬ÒòΪMySQLÖÚ¶àµÄ´æ´¢ÒýÇæÖУ¬Ö»ÓÐNDB ClusterʵÏÖÁ˹²Ïí´æ´¢µÄ¹¦ÄÜ¡£
ÔÚNDB ClusterÖУ¬SQL NodeÏ൱ÓÚ´¦Àí·þÎñÆ÷£¬Data NodeÏ൱ÓÚ¹²Ïí´æ´¢¡£LVS¿ÉÒÔÈÃÓ¦ÓóÌÐòµÄ¿ª·¢¸ü¼Ó¼òµ¥£¬¿ª·¢ÈËÔ±²¢²»ÐèÒªÖªµÀÖ´ÐÐSQLµÄÊý¾Ý¿â·þÎñÆ÷µ½µ×ÊÇÄÄÒ»¸ö£¬µ«ÊÇ¿ÉÒÔ»ñµÃ×Ô¼ºÏëÒªµÄÊý¾Ý¡£¶øNDB ClusterÌṩµÄÊý¾Ý²ð·ÖºÍÀ©Èݹ¦ÄÜ£¬±£Ö¤ÁËÊý¾Ý¿âµÄ¿ÉÀ©Õ¹ÐÔ¡£
ÃÀÖв»×ãµÄÊÇ£¬NDB ClusterµÄÐÔÄÜʵÔÚÌ«²î¡£¼´Ê¹LVS¸ºÔؾùºâ×öµÃºÜºÃºÜÇ¿´ó£¬NDB ClusterÒ²»á³ÉΪƿ¾±¡£
¸ù¾ÝÎҵĹ۲췢ÏÖ£¬LVSµÄ¼Ü¹¹·Ç³£ÊÊÓÃÓÚCPU-boundµÄÓ¦Óó¡¾°¡£ËäÈ»¹²Ïí´æ´¢µÄÒýÈëʹµÃLVSÄܹ»Ö§³ÖÓÐ״̬µÄÁ¬½Ó£¬µ«ÊÇLVS²¢²»ÊÊÓÃÓÚIO-boundµÄÓ¦Óá£ÒòΪ²»¹Ü¸ºÔØÈçºÎ¾ùºâ£¬×îÖÕÆ¿¾±ÔÚÓÚ¹²Ïí´æ´¢Ö®ÉÏ¡£¶ø¹²Ïí´æ´¢ÈçºÎÍØÕ¹£¬LVS²¢²»¹ØÐÄ¡£Ò²ÐíÖ»ÓÐNDB ClusterÌáÉýÁËIOÐÔÄÜÖ®ºó£¬LVS²ÅÄÜÕæÕýÔÚMySQL·½ÃæÓ¦ÓÃÆðÀ´¡£
·Ç³£¸ÐлÕ²©Ê¿µÄ·ÖÏí£¬NDB ClusterÖÕÓÚÈÃÎÒ¾õµÃ²»ÄÇô¼¦ÀßÁË¡£
×ªÔØ:http://rdc.taobao.com/blog/dba/html/390_lvs-mysql-ndb-cluster.html


Ïà¹ØÎĵµ£º

linux,nginx,mysql,php°²×°±¸Íü

niginx°²×°Á÷³Ì
Èí¼þÏÂÔØ:--->
mkdir -p /home/dancebear/programe
cd /home/dancebear/programe
wget http://sysoev.ru/nginx/nginx-0.6.31.tar.gz
wget http://www.php.net/get/php-5.2.6.tar.gz/from/this/mirror
wget http://php-fpm.anight.org/downloads/head/php-5.2.6-fpm-0.5.8.diff.gz
wget http://dev ......

MySQL NDB 6.3.20¼¯Èº°²×°

 
MySQL¼¯ÈºÊÇÒ»ÖÖÔÚÎÞ¹²Ïí¼Ü¹¹ÏµÍ³ÀïÓ¦ÓÃÄÚ´æÊý¾Ý¿â¼¯ÈºµÄ¼¼Êõ¡£ÕâÖÖÎÞ¹²ÏíµÄ¼Ü¹¹¿ÉÒÔʹµÃϵͳʹÓ÷dz£±ãÒ˵IJ¢ÇÒÊÇ×îСÅäÖõÄÓ²¼þ¡£
MySQL¼¯ÈºÊÇÒ»ÖÖ·Ö²¼Ê½Éè¼Æ£¬Ä¿±êÊÇÒª´ïµ½Ã»ÓÐÈκε¥µã¹ÊÕϵ㡣Òò´Ë£¬ÈκÎ×é³É²¿·Ö¶¼Ó¦¸ÃÓµÓÐ×Ô¼ºµÄÄÚ´æºÍ´ÅÅÌ¡£Èκι²Ïí´æ´¢·½°¸ÈçÍøÂç¹²Ïí£¬ÍøÂçÎļþϵͳºÍSANÉ豸ÊDz»ÍƼö»ò²»Ö ......

MySQLÍêÈ«±¸·Ý¡¢ÔöÁ¿±¸·ÝÓë»Ö¸´

[ ÅäÖÃ ]
Ö´ÐÐÔöÁ¿±¸·ÝµÄǰÌáÌõ¼þÊÇMySQL´ò¿ªlog-binÈÕÖ¾¿ª¹Ø£¬ÀýÈçÔÚmy.ini»òmy.cnfÖмÓÈë log-bin=C:/Program Files/MySQL/MySQL Server 6.0/Data/mysql-bin “log-bin=”ºóµÄ×Ö·û´®ÎªÈÕÖ¾¼ÇÔØÄ¿Â¼£¬Ò»°ã½¨Òé·ÅÔÚ²»Í¬ÓÚmysqlÊý¾ÝĿ¼µÄ´ÅÅÌÉÏ¡£
[ ÍêÈ«±¸·Ý]
¼Ù¶¨ÐÇÆÚÈÕÏÂÎç1µãÖ´ÐÐÍêÈ«±¸·Ý£¬ÊÊÓÃÓÚMyISAM ......

mysqlÖ÷´ÓÅäÖÃһЩעÒâ

ÅäÖÃÖ÷´Ó£º
Á½Ì¨·þÎñÆ÷mysql°æ±¾Ò»Ñù£¬
Server version: 5.1.16-beta-log MySQL Community Server
ÅäÖûù±¾Ò»Ñù¡¢Æô¶¯²ÎÊýÒ»Ñù
Ö÷µÄ¿ÉÒÔ·ÃÎʴӵģ¬
µ«ÊÇ
´ÓÄDZßÔõôÁ¬½ÓÖ÷µÄ£¬¶¼ÊÇʧ°Ü£º
[root@2006 htmlfile]# mysql -h192.168.xx.xxx -uxxx -pxxx --default-character-set=GBK --reconnect
ERROR 2003 (HY000): C ......

mysqlËæ»úÊý¾ÝÉú³É²¢²åÈë

      dblpÊý¾Ý¿âÖÐÒýÓÃÐÅÏ¢ºÜÉÙ£¬Æ½¾ùһƪÂÛÎÄÒýÓÃ0.2ƪ¡£Ê¹ÓÃdblp×öʵÑéÊý¾Ý¼¯µÄijƪÂÛÎÄÌáµ½£¬¿ÉÒÔËæ»úÌí¼ÓÒýÓÃÐÅÏ¢¡£ÊÜ´ËÆô·¢£¬ÎÒ´òËãΪÿһƪÂÛÎͼÌí¼Ó20ÆªËæ»úÒýÓã¬ÓÚÊǾÍд³öÁËÈçϵÄsqlÓï¾ä£º
     String sql = "insert into citation(pId1,pId2) values( (selec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ