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 -hÖ÷»úµØÖ· -uÓû§Ãû -pÓû§ÃÜÂë
1¡¢ÈôÊÇÁ¬½Óµ½±¾»úÉϵÄMYSQL£ºÊ×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬»òÕß½«mysql\bin°²×°Â·¾¶ÉèÖÃÔÚ»·¾³±äÁ¿pathÖУ¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëǰ± ......
Ð޸ĺͱ¸·Ý¡¢Åú´¦Àí
ÓÐʱÎÒÃÇÒª¶ÔÊý¾Ý¿â±íºÍÊý¾Ý¿â½øÐÐÐ޸ĺÍɾ³ý£¬¿ÉÒÔÓÃÈçÏ·½·¨ÊµÏÖ£º
1¡¢Ôö¼ÓÒ»ÁУº
ÈçÔÚÇ°ÃæÀý×ÓÖеÄmytable±íÖÐÔö¼ÓÒ»ÁбíʾÊÇ·ñµ¥Éísingle:
mysql> alter table mytable add column single char(1);
2¡¢Ð޸ļǼ
½«abccsµÄsingle¼Ç¼ÐÞ¸ÄΪ“y”£º
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 ......