mysql cluster rpm°²×°°üµÄÑ¡Ôñ °²×° ÅäÖà ²âÊÔ
ÏÖÔÚа汾µÄmysql¼¯ÈºÒÑ´ÓÆÕͨµÄmysql°æ±¾ÖÐÌáÈ¡³öÀ´ÁË£¬Ò²¾ÍÊÇÒª×ömysqlµÄ¼¯ÈºÐèҪѡÔñmysql¼¯Èº¶ÔÓ¦µÄÈí¼þ°ü¡£¶øÇÒmysqlרÃÅÌṩÁËÕë¶Ôredhat ²Ù×÷ϵͳµÄrpmÈí¼þ°ü¡£¿ÉÒÔ´Óhttp://dev.mysql.com/downloads/»ñµÃ¶ÔÓ¦µÄ²Ù×÷ϵͳµÄrpmÈí¼þ°ü¡£ÔÚÕâÀïÖ÷Ҫ̸̸mysql rpm°üµÄ¼¯Èº
mysql¼¯ÈºµÄÈýÖÖÀàÐ͵Ľڵ㣺
sql node: ÕâÊÇÓÃÀ´·ÃÎʼ¯ÈºÊý¾ÝµÄ½Úµã¡£¶ÔÓÚMySQL¼¯Èº£¬sql½ÚµãÊÇʹÓÃNDB´Ø´æ´¢ÒýÇæµÄ´«Í³MySQL·þÎñÆ÷¡£µäÐÍÇé¿öÏ£¬SQL½ÚµãÊÇʹÓÃÃüÁîmysqld –ndbclusterÆô¶¯µÄ£¬»ò½«ndbclusterÌí¼Óµ½my.cnfºóʹÓÃmysqldÆô¶¯¡£(ÆäʵÆô¶¯sql node ¾ÍÏñÆô¶¯Ò»°ãµÄmysql serverÒ»ÑùÆô¶¯£¬ÓкܶàÖÖÆô¶¯·½Ê½£¬service mysql start»òÕßetc/rc.d/init.d/mysqld startÖ»²»¹ýÊÇÒªÔÚÅäÖúü¯ÈºµÄÅäÖÃÎļþµÄÇ°ÌáÏÂ)¡£
data node£ºÕâÀà½ÚµãÓÃÓÚ±£´æ´ØµÄÊý¾Ý¡£Êý¾Ý½ÚµãµÄÊýÄ¿Ó븱±¾µÄÊýÄ¿Ïà¹Ø£¬ÊÇƬ¶ÎµÄ±¶Êý¡£ÀýÈ磬¶ÔÓÚÁ½¸ö¸±±¾£¬Ã¿¸ö¸±±¾ÓÐÁ½¸öƬ¶Î£¬ÄÇô¾ÍÓÐ4¸öÊý¾Ý½Úµã¡£Ã»ÓбØÒªÓÐÒ»¸öÒÔÉϵĸ±±¾¡£Êý¾Ý½ÚµãÊÇÓÃÃüÁîndbdÆô¶¯µÄ¡£
MGM node(¹ÜÀí½Úµã)£ºÕâÀà½ÚµãµÄ×÷ÓÃÊǹÜÀíMySQL´ØÄÚµÄÆäËû½Úµã£¬ÈçÌṩÅäÖÃÊý¾Ý¡¢Æô¶¯²¢Í£Ö¹½Úµã¡¢ÔËÐб¸·ÝµÈ¡£ÓÉÓÚÕâÀà½Úµã¸ºÔð¹ÜÀíÆäËû½ÚµãµÄÅäÖã¬Ó¦ÔÚÆô¶¯ÆäËû½Úµã֮ǰÊ×ÏÈÆô¶¯ÕâÀà½Úµã¡£MGM½ÚµãÊÇÓÃÃüÁîndb_mgmdÆô¶¯µÄ¡£ÀýÈç(ndb-mgmd -f /var/lib/mysql-cluster/config.ini).
ÏÂÃæ¾ÍÊÇrpm°üµÄÑ¡Ôñ£¬ÔÚ²»Í¬ÀàÐ͵ĽڵãÑ¡Ôñ¶ÔÓ¦µÄrpm°ü(ÏÂÖ»ÊÇÎÒµÄÑ¡Ôñ£¬°æ±¾²»Í¬ÎļþÃû¾Í²»Ò»Ñù)£º
sql node: MySQL-Cluster-gpl-server-7.0.9-0.rhel4.i386£¨which supplies the core files needed to r
Ïà¹ØÎĵµ£º
ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Ñ§Ï°ÈçºÎͨ¹ýPHP 5µÄÒ»¸ö»ù±¾³éÏóÀàʹÓÃÍâ¼üÔ¼ÊøÀ´¸üÐÂÁ½¸öInnoDB±íµÄÊý¾Ý¡£ ÎÒÃǽ«Í¨¹ý¾ßÌåʾÀýÀ´ËµÃ÷ÈçºÎͨ¹ý·þÎñÆ÷¶Ë½Å±¾ÓïÑÔÀ´Ê¹ÓÃÍâ¼üÔ¼Êø¡£
¡¡¡¡Ò»¡¢ÀûÓÃÍâ¼üÔ¼Êø¸üÐÂMySQLÖеÄÊý¾Ý
¡¡¡¡ÏÖÔÚ£¬×îÁ÷ÐеĿªÔ´¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ·ÇMySQLĪÊô£¬¶øMySQLÓÖÖ§³Ö¶à¸ö´æ´¢ÒýÇ棬ÆäÖÐĬÈϵÄÒ²ÊÇËٶȽϿìµÄ´ ......
ÒÔÏÂÄÚÈÝÔÚubuntu 9.04 serverϵͳÉϲâÊÔͨ¹ý
ÓÃapt-get install vsftp°²×°µÄʱºòÏà¹ØµÄÎļþλÖãº
Ö÷ÅäÖÃÎļþ£º/etc/vsftpd.conf
ÑéÖ¤ÅäÖÃÎļþ/etc/pam.d/vsftpd
ÖØÆô£º/etc/init.d/vsftpd restart
vsftp MysqlÑéÖ¤·½Ê½£º
MYSQLÒѾ°²×°ÔÚ/usr/local/mysql
Ö±½Ó°²×°vsftp
sudo apt-get install vsftp
°²×°pam_mys ......
GROUP_CONCAT ÊÇÒ»¸öºÏ²¢¶àÐеĺ¯Êý£¬Ò»°ãÓõÄÉÙ£¬ËùÒԺܶàÈ˶¼²»ÖªµÀ£¬ÎÒÒ²ÊÇÒ»¸ö£¬½ñÌìżȻ¿´µ½£¬¹Ê¼ÇÏ·½·¨£»
GROUP_CONCATµÄÓï·¨ÈçÏ£º
GROUP_CONCAT([DISTINCT] expr [,expr ...][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name ...]][SEPARATOR str_val])
ÏÂÃæÑÝʾһÏÂÕâ¸öº¯Êý£¬ÏȽ¨Á¢Ò ......
Ò»¡¢µ¼³öÊý¾Ý¿âÓÃmysqldumpÃüÁעÒâmysqlµÄ°²×°Â·¾¶£¬¼´´ËÃüÁîµÄ·¾¶£©£º
1¡¢µ¼³öÊý¾ÝºÍ±í½á¹¹£º
mysqldump -uÓû§Ãû -p Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
#/usr/local/mysql/bin/mysqldump -uroot -p abc > abc.sql
Çûسµºó»áÌáʾÊäÈëÃÜÂë
2¡¢Ö»µ¼³ö±í½á¹¹
mysqldump -uÓû§Ãû -p -d Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
# ......
ÓкܶàÅóÓÑËäÈ»°²×°ºÃÁË MySQL µ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâƪÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½Ó MySQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð© MySQL µÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMySQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ª DOS ´°¿Ú£¬È»ºó½øÈëĿ¼ mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u ......