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×éºÍÓû§,Èç¹ûûÓÐÓÃ
Ïà¹ØÎĵµ£º
1. °²×°mysqlµÄʱºòÑ¡Ôñ×Ö·û¼¯utf8
2. °²×°½áÊøºóÐÞ¸Ämy.ini,ÓÐÁ½¸öµØ·½ÒªÐ޸ģ¬
[mysql] default-character-set=gbk
# The default character set that will be used when a new schema or table is
# created and no character set ......
ÓÉMySQLÌṩµÄģʽƥÅäµÄÆäËûÀàÐÍÊÇʹÓÃÀ©Õ¹ÕýÔò±í´ïʽ¡£µ±Äã¶ÔÕâÀàģʽ½øÐÐÆ¥Åä²âÊÔʱ£¬Ê¹ÓÃREGEXPºÍNOT REGEXP²Ù×÷·û(»òRLIKEºÍNOT RLIKE£¬ËüÃÇÊÇͬÒå´Ê)¡£ À©Õ¹ÕýÔò±í´ïʽµÄһЩ×Ö·ûÊÇ£º
“.”Æ¥ÅäÈκε¥¸öµÄ×Ö·û¡£
Ò»¸ö×Ö·ûÀà“[...]”Æ¥ÅäÔÚ·½À¨ºÅÄÚµÄÈκÎ×Ö·û¡£ÀýÈ磬“[abc]”ƥŠ......
¼ÙÈçÎÒÃǵÄmysqlÓÐÒ»¸ö¼ÆÊýÆ÷£¬¶øÕâ¸ö¼ÆÊýÆ÷ÐèÒªÎÒÃÇÖØÐÂͳ¼Æ£¬Ôõô°ìÄØ£¿
Ó¦Óó¡¾°£¬±ÈÈç˵ÓÐÒ»¸öÉ̳¡£¬Ã¿ÂôÒ»¸ö²úÆ·¶¼²úÉúÒ»¸öÁ÷Ë®£¬È»ºóÎÒÃÇÐèÒªÖªµÀÿ±ÊÁ÷Ë®ÊǸòúÆ·µÚ¼¸´Î³öÊ۵ģ¬ÕâÑù˵¿ÉÄܲ»Ã÷°×£¬ÎÒÄÃÒ»¸öÏêϸµÄÊý¾Ý
¾ÙÀý°É¡£
recordID,productID,productType,sellDate,counter
1, 1, 1, '2010-1-15 15:20:10 ......
MySQLµ¼³öºÍµ¼ÈëSQL½Å±¾
µ¼³ösql½Å±¾£º
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > ´æ·ÅλÖÃ
mysqljump -u root -p test > c:\a.sql
µ¼Èësql½Å±¾£º
Òª½¨»·¾³±äÁ¿»òÕßÔÚbinµÄĿ¼Ï£¬mysqlÕâ¸öÃüÁî²ÅÄÜʶ±ð¡£
testÊÇÄãÒªµ¼½øÈ¥µÄÊý¾Ý¿âÃû×Ö£¬ÒªÌáǰ½¨ºÃ~~
mysql -u Óû§Ãû -p Êý¾Ý¿âÃû < ´æ·ÅλÖÃ
mysqljump -u ro ......
mysqlµÄÅäÖÃÎļþͨ³£ÃüÃûΪmy.cnf,Èç¹û±£´æÔÚĬÈϵÄ/etc/my.cnfĿ¼ÏÂ,ÄÇôÕâÀïÃæµÄÅäÖÃÊÇÈ«¾ÖµÄ,¼È¶Ô´Ë·þÎñÆ÷ÉϵÄËùÓÐmysql·þÎñÆ÷¶¼ÊÇÓÐЧµÄ(Èç¹ûÄãÓÐÔÚЩ·þÎñÆ÷Éϰ²×°Á˶à¸ömysql).Èç¹ûÖ»ÊDZ£´æÔÚij¸ömysql·þÎñÆ÷µÄÊý¾ÝĿ¼ÏÂ,ÔòÖ»¶Ô¸Ãmysql·þÎñÆ÷²úÉú×÷ÓÃ.Èç¹ûÊDZ£´æÔÚij¸öÓû§(µ±È»ÊÇmysqlÓû§)µÄhomeĿ¼ÏÂ,ÔòÖ»ÊÇÔÚmy ......