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

Mysql¼¯ÈºÅäÖÃÎĵµ

¹ÜÀí½Úµã:192.168.50.211 Êý¾Ý½Úµã: 192.168.50.214 Êý¾Ý½Úµã: 192.168.50.215 SQL½Úµã: 192.168.50.212 SQL½Úµã: 192.168.50.213 ²Ù×÷ϵͳ:Red Hat Enterprise Linux AS release 5 ------------------------------------------°²×°Ç°±Ø¶Á---------------------------------------- µ±Ç°ÎĵµµÄ°æ±¾Îªmysql-cluster-7.0.9£¬I386/X_64°æ±¾¶¼°²×°³É¹¦¡£×°ndbǰ£¬ÏÈɾ³ýÔ­ÏÈϵͳ×Ô´ømysql£¬Ê¹ÓÃÃüÁîyum remove ¡°*mysql*¡±,±ØÐë×¢ÒâµÄÊÇÊý¾Ý½Úµã±ØÐë´óÓÚµÈÓÚ2£¬·ñÕß½«»á°²×°Ê§°Ü¡£¸÷¸ö½ÚµãµÄ°²×°Ë³Ðò¡°¹ÜÀí½Úµã—Êý¾Ý½Úµã—SQL½Úµã¡°£¬Ö»ÓмܺÃ2̨¼°Æä2̨ÒÔÉÏÊý¾Ý¼¸µã£¬²ÅÄÜ¿ªÊ¼¼ÜÉèSQL½Úµã¡£ ¸÷¸ö½Úµã½á¹¹£º ¹ÜÀí½Úµã£º½«°²×°°übinĿ¼ÏµÄËùÓÐÒÔndb¿ªÍ·µÄ¶þ½øÖÆÎļþ¿½±´µ½/usr/local/binÖУ¬²¢ÇÒÅäÖÃconfig.iniÒÔ¼°my.cnf Ŀ¼½á¹¹£º /usr/local/mysql-cluster/config.ini --------¹ÜÀí½ÚµãÅäÖÃÎļþ /etc/my.cnf --------mysqlÅäÖÃÎļþ /usr/local/bin/ndb* --------¹ÜÀí½ÚµãÏà¹Ø¶þ½øÖÆÎļþ Æô¶¯ÃüÁÂÔ ¿ª·Å¶Ë¿Ú£º1186 Êý¾Ý½Úµã£ºÊý¾ÝÕæÕý´æ·ÅλÖ㬽«Õâ¸ötar°ü½âѹµ½/usr/local/mysqlÖУ¬ÅäÖÃmy.cnf£¬ÐèÒª³õʼ»¯Êý¾Ý¿â£¬ÎÞÐè´ò¿ª3306¶Ë¿Ú£¬×îºóÖ»ÐèÒªÔËÐÐ/usr/local/mysql/bin/ndbd¼´¿É Ŀ¼½á¹¹ /usr/local/mysql/ --------mysqlĿ¼ /etc/my.cnf --------mysqlÅäÖÃÎļþ /opt/mydata/ --------Êý¾Ý¿âĿ¼ Æô¶¯ÃüÁ/usr/local/mysql/bin/ndbd ¿ª·Å¶Ë¿Ú£º63132 SQL½Úµã£º½«Õâ¸ötar°ü½âѹµ½/usr/local/mysqlÖУ¬ÅäÖÃmy.cnf£¬ÐèÒª³õʼ»¯Êý¾Ý¿â£¬²¢ÇÒ×îºóʹÓÃÃüÁîservice mysqld start´ò¿ª3306¶Ë¿Ú Ŀ¼½á¹¹£º /usr/local/mysql/ --------mysqlĿ¼ /etc/my.cnf --------mysqlÅäÖÃÎļþ /opt/mydata/ --------Êý¾Ý¿âĿ¼ Æô¶¯ÃüÁservice mysqld start ¿ª·Å¶Ë¿Ú£º3306 Æô¶¯²½Ö裺Æô¶¯¹ÜÀí½Úµã---Æô¶¯ËùÓÐÊý¾Ý½Úµã----Æô¶¯ËùÓÐmysqld½Úµã --------------------------------------»ªÀöµÄ½áÊø------------------------------------------- ¹ÜÀí½Úµã°²×° 1. ¼ì²éÊÇϵͳÊÇ·ñ°²×°¹ýmysql, Èç¹ûÓа²×°£¬ÐèҪɾ³ý°²×°Ä¿Â¼µÄÎļþ£®Í¨¹ýps afx |grep mysql ²é¿´µ½mysqlµÄÅäÖÃÎļþ£¬Êý¾Ý¿âĿ¼£¬pid,port,socket µÈÐÅÏ¢£¬Òª½«ÕâЩÐÅϢȫ²¿Çå³ý£®Ò»°ã¶øÑÔ£¬É¾³ý /usr/local/mysql* /var/lib/mysql*¾Í¿ÉÒÔ # service mysql.server stop #rm -rf /usr/local/mysql* /var/lib/mysql* 2. ¼ì²émysql×éºÍÓû§,Èç¹ûûÓÐÓÃ


Ïà¹ØÎĵµ£º

MYSQLÖÐͳ¼Æ²éѯ½á¹û×ÜÐÐÊýµÄ±ã½Ý·½·¨¡¾×ªÔØ¡¿

ת×Ô£ºhttp://ginew.blog.163.com/
½ñÌìÔĶÁ wordpress´úÂëʱ£¬·¢ÏÖÒ»¸öMYSQLµÄ¹Ø¼ü´Ê SQL_CALC_FOUND_ROWS ²é¿´ÊÖ²áºó·¢Ïִ˹ؼü´ÊµÄ×÷ÓÃÊÇÔÚ²éѯʱͳ¼ÆÂú×ã¹ýÂËÌõ¼þºóµÄ½á¹ûµÄ×ÜÊý£¨²»ÊÜ Limit µÄÏÞÖÆ£©
ÀýÈ磺 SELECT SQL_CALC_FOUND_ROWS tid from cdb_threads WHERE fid=14 LIMIT 1,10;
¼ÙÉèÂú×ãÌõ¼þµÄÓÐ1000Ìõ£¬Õâ ......

mysqlÕýÔò±í´ïʽ LIKE ͨÅä·û

ÓÉMySQLÌṩµÄģʽƥÅäµÄÆäËûÀàÐÍÊÇʹÓÃÀ©Õ¹ÕýÔò±í´ïʽ¡£µ±Äã¶ÔÕâÀàģʽ½øÐÐÆ¥Åä²âÊÔʱ£¬Ê¹ÓÃREGEXPºÍNOT REGEXP²Ù×÷·û(»òRLIKEºÍNOT RLIKE£¬ËüÃÇÊÇͬÒå´Ê)¡£ À©Õ¹ÕýÔò±í´ïʽµÄһЩ×Ö·ûÊÇ£º
“.”Æ¥ÅäÈκε¥¸öµÄ×Ö·û¡£
Ò»¸ö×Ö·ûÀà“[...]”Æ¥ÅäÔÚ·½À¨ºÅÄÚµÄÈκÎ×Ö·û¡£ÀýÈ磬“[abc]”ƥŠ......

UbuntuÏÂÅäÖÃLAMP£¨Linux+Apache+Mysql+PHP)»·¾³

ÖÕÓڷżÙÁË£¬ÕýÏëÔÚÕâ¸ö¼ÙÆÚÀïѧѧPHP£¬ÓÉÓÚ×Ô¼ºÓõÄÊÇ×ÀÃæ°æµÄUbuntu8.04,ÓÚÊǾÍÏë¼ÜÉèÒ»¸öLAMP»·¾³À´Ñ§PHP£¬Ò²³Ã´Ë»ú»áѧһÏÂPHP·þÎñÆ÷µÄ¼ÜÉè¡£
Ò»¡¢°²×°Ubuntu8.04
ËäȻ˵ÊÇÅäÖÃLAMP»·¾³£¬µ«ÔÚÎÄÕÂÀï²¢²»»á½²ÊöÈçºÎ°²×°Ubuntu8.04,ÒòΪ¹ØÓÚÈçºÎUbuntu8.04ÔÚÍøÉÏÒѾ­ÓкܶàµÄ½Ì³ÌÁË£¬¾ÍËãÊÇÓ²Å̰²×°Ò²ÊÇÒ»¼þºÜ¼òµ¥µÄÊÂÁ ......

ÐÞ¸ÄMySQL 5.1 dataÎļþ¼Ð·¾¶

ÐÞ¸ÄMySQL 5.1 dataÎļþ¼Ð·¾¶
ÎÒ°²×°µÄÕâ¸ö°æ±¾µÄMYSQLûÓÐdataÎļþ¼Ð£¬µ«ÊÇ¿ÉÒÔÕý³£Ê¹Ó㬲»ÖªµÀÄãÃǵÄÓÐûÓÐÄØ£¿Ôõô²Å¿ÉÒÔ³öÏÖdataÎļþ¼ÐÄØ£¬Ã»ÓÐdataÎļþ¼Ð£¬ÄÇÎÒµÄÊý¾Ý¿âÎļþ´æ·ÅÔÚʲôµØ·½ÁËÄØ£¿ÎÒËÑË÷ÁËÕû¸öµçÄÔ¶¼Ã»ÓÐÕÒµ½¡£
ºÃÐĵÄÅóÓÑ£¬¿ì¸æËßÎÒÔõô»ØÊ£¿¸ÃÔõô½â¾ö£¿
ллÁË£¡£¡£¡
====================== ......

LVS+Mysql¼¯Èº¸ºÔؾùºâ ÄÚÍølvsÅäÖÃ

Ò»¡¢IPÐÅÏ¢ÁÐ±í£º
   Ãû³Æ                 IP   
   LVS-DR-VIP            192.168.50.245
   LVS-DR-Master  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ