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

MySQL¼¯ÈºÊµ¼ùÏê½âϵÁÐÖ®¶þ£ºÈçºÎ°²×°Management Node

±ÊÕߣ¨mqboss£©½üÆÚÔÚ×öMySQL¼¯ÈºµÄ¼¼Êõµ÷ÑУ¬»áÂ½Ðø°Ñ×Ô¼ºµÄÐĵÃÌå»áд³öÀ´ºÍ´ó¼Ò·ÖÏí£¬Çë´ó¼Ò¼ÌÐø¹Ø×¢¡£
1.´Ómysq¹Ù·½ÍøÕ¾ÏÂÔØ°²×°Îļþmysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.tar.gz£¬²¢Í¨¹ýFTPÉÏ´«µ½Solaris·þÎñÆ÷ÉÏ£»
2.Ìí¼ÓÓû§×émysqlºÍÓû§mysql(×¢£ºmysqlÓû§ÊôÓÚmysqlÓû§×é)
shell> groupadd mysql
shell> useradd -g mysql mysql
3.½øÈëmysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.tar.gzÎļþËùÔÚµÄĿ¼£¬½âѹËõ¸ÃÎļþ£º
µÃµ½Îļþ¼Ðmysql-cluster-gpl-7.0.9-solaris10-sparc-64bit£¬ÎªÁË·½±ãÆð¼û£¬°Ñ¸ÃÎļþÃûÖØÃüÃûΪmysql-cluster-7.0.9£»
´Ë´¦¼Ù¶¨¸ÃÎļþ¼ÐÔÚĿ¼/var/tmpÏ£¬ÒÀ´ÎÖ´ÐÐÒÔÏÂÃüÁ
shell> cd /var/tmp
shell> cd mysql-cluster-7.0.9
shell> cp bin/ndb_mgm* /usr/local/bin
Ä¿µÄÊǰÑndb_mgmºÍndb_mgmd¿½±´µ½/usr/local/binĿ¼ÏÂ
´Ëºó£¬¿ÉÒÔ·ÅÐĵİÑmysql-cluster-7.0.9Îļþ¼Ðɾ³ý
4.½øÈë/usr/local/binĿ¼Ï£¬²¢ÊÚÓèndb_mgmºÍndb_mgmd¿ÉÖ´ÐÐȨÏÞ£¬¾ßÌåÈçÏ£º
shell> cd /usr/local/bin
shell> chmod +x ndb_mgm*
×÷Õß¼ò½é£º mqboss ÊÇ×÷Õß±ÊÃû£¬Ôø¾ÍÖ°ÓÚÆÕÌìºÍÖÐÐË£¬ÏÖÔÚÒ»ÍâÆó¹¤×÷£¬Ò»Ö±´ÓÊÂͨÐÅÈí¼þµÄ²âÊÔ¡¢¿ª·¢ÓëÉè¼Æ¹¤×÷£¬×¨×¢ÓÚJAVA, J2EE, WEB, DBµÈÁìÓòµÄÀíÂÛÑо¿¡¢²âÊÔ¡¢¿ª·¢ÓëÉè¼Æ


Ïà¹ØÎĵµ£º

ʵÓÃMYSQLÃüÁî´óÈ«

Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû -pÓû§ÃÜÂë
      1¡¢ÈôÊÇÁ¬½Óµ½±¾»úÉϵÄMYSQL£ºÊ×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬»òÕß½«mysql\bin°²×°Â·¾¶ÉèÖÃÔÚ»·¾³±äÁ¿pathÖУ¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëǰ± ......

mysqlѧϰ5

Ð޸ĺͱ¸·Ý¡¢Åú´¦Àí
   ÓÐʱÎÒÃÇÒª¶ÔÊý¾Ý¿â±íºÍÊý¾Ý¿â½øÐÐÐ޸ĺÍɾ³ý£¬¿ÉÒÔÓÃÈçÏ·½·¨ÊµÏÖ£º
1¡¢Ôö¼ÓÒ»ÁУº
ÈçÔÚÇ°ÃæÀý×ÓÖеÄmytable±íÖÐÔö¼ÓÒ»ÁбíʾÊÇ·ñµ¥Éísingle:
mysql> alter table mytable add column single char(1);
2¡¢Ð޸ļǼ
½«abccsµÄsingle¼Ç¼ÐÞ¸ÄΪ“y”£º
mysql> ......

Ô¶³ÌÁ¬½ÓmysqlËÙ¶ÈÂýµÄ½â¾ö·½·¨

Ô¶³ÌÁ¬½ÓmysqlËÙ¶ÈÂýµÄ½â¾ö·½·¨
http://www.xishuiw.com
¡¡¡¡PHP Ô¶³ÌÁ¬½ÓMYSQLËÙ¶ÈÂý,ÓÐʱԶ³ÌÁ¬½Óµ½MYSQLÓÃʱ4-20Ãë²»µÈ,±¾µØÁ¬½ÓMYSQLÕý³£,³öÏÖÕâÖÖÎÊÌâµÄÖ÷ÒªÔ­ÒòÊÇ,ĬÈϰ²×°µÄMYSQL¿ªÆôÁËDNSµÄ·´Ïò½âÎö,ÔÚMY.INI(WINDOWSϵͳÏÂ)»òMY.CNF(UNIX»òLINUXϵͳÏÂ)ÎļþµÄ[mysqld]ϼÓÈëskip- name-resolveÕâÒ»¾ä¡£Á¬½Ómysq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ