MySQLÊý¾Ý¿â¸´ÖÆMaster Master Slave¼Ü¹¹
ÎÒÃÇÓÃMaster-Slaves¼Ü¹¹½â¾öÁ˶ÁѹÁ¦±È½Ï´óµÄÓ¦Ó㬶øÎÒÃÇÓÃMaster-Master¼Ü¹¹½â¾öÁ˵¥µã·þÎñÎÊÌ⣬ÌṩÁËϵͳµÄ¿ÉÓÃÐÔ¡£µ«ÊÇÓÐʱÎÒÃÇÃæÁÙ¾Þ´óµÄ¶ÁÊý¾ÝѹÁ¦£¬ÌرðÊÇwebϵͳ£¬ÓÖÐèÒª½â¾öµ¥µã·þÎñµÄÎÊÌ⣬ΪӦÓÃÌṩ×ã¹»¸ßµÄ¿ÉÓÃÐÔ¡£ÕâʱÎÒÃǾÍÐèÒª½«ÕâÁ½Öּܹ¹½áºÏÆðÀ´¡£Õâ¾ÍÊÇMaster-Master-Slaves¼Ü¹¹¡£½á¹¹Í¼ÈçÏÂ
Master×éµÄ·þÎñÆ÷µÄÖ÷ÒªÌØµã£º
1. ¸ºÔðÓ¦Óÿͻ§¶ËµÄдÊý¾Ý´¦Àí¡£
2. ½â¾öµ¥µã·þÎñµÄ·½°¸£¬Ìá¸ß¿ÉÓÃÐԵķ½°¸¡£
3. ×÷Ϊslave×é·þÎñÆ÷µÄ¸´ÖÆÊý¾ÝÔ´¡£
Slave×éµÄ·þÎñÆ÷µÄÌØµã£º
1. ¸ºÔðÓ¦Óÿͻ§¶ËµÄ¶ÁÊý¾Ý´¦Àí¡£
2. ·Öµ£Ó¦ÓÃϵͳǿ´óµÄ¶ÁÊý¾ÝѹÁ¦¡£
3. ±£³ÖÓëmaster×éµÄÊý¾ÝÒ»Ö¡£
Ïà¹ØÎĵµ£º
MySQLÐÔÄÜÓÅ»¯µÄ×î¼Ñ20+Ìõ¾Ñé
ÎÄÕ·ÖÀà:Êý¾Ý¿â
from£ºhttp://www.uml.org.cn/sjjm/201001041.asp
½ñÌ죬Êý¾Ý¿âµÄ²Ù×÷Ô½À´Ô½³ÉΪÕû¸öÓ¦ÓõÄÐÔÄÜÆ¿¾±ÁË£¬Õâµã¶ÔÓÚWebÓ¦ÓÃÓÈÆäÃ÷ÏÔ¡£¹ØÓÚÊý¾Ý¿âµÄÐÔÄÜ£¬Õâ²¢²»Ö»ÊÇDBA²ÅÐèÒªµ£ÐĵÄÊ£¬¶øÕâ¸üÊÇÎÒÃdzÌÐòÔ±ÐèҪȥ¹Ø×¢µÄÊÂÇé¡£µ±ÎÒÃÇÈ¥Éè¼ÆÊý¾Ý¿â±í½á¹¹£¬¶Ô²Ù×÷Êý¾Ý¿âʱ£¨ÓÈÆäÊ ......
1 modify the /etc/mysql/my.cnf
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
you see the bind-address, comment it. ×¢µôËü ......
MySQLµ¼Èëµ¼³ö.sqlÎļþ²½ÖèÈçÏ£º
Ò».MySQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin;”ÆäÖÐpathΪMySQLµÄ°²×°Â·¾¶¡£
¶þ.¼òµ¥µÄ½éÉÜÒ»ÏÂÃüÁîÐнøÈëMySQLµÄ·½·¨£º
1.C:\>mysql -h hostname -u username -p
°´ENTER¼ü£¬µÈ´ýÈ»ºóÊäÈëÃÜÂë¡£Õâ ......
1¡¢MYSQLµÄ°²×°
1£©Ê×Ïȵ±È»ÊÇÏÂÔØÔ´Âë°ü¿©£¬È磺mysql-5.0.27µÄ°²×°£¬http://www.mysql.com
2£©½âѹËõ£¬>tar -zxvf mysql-5.0.27.tar.gz
3£©½âѹÍê³É£¬½øÈëmysql-5.0.27Îļþ¼Ð£¬>cd mysql-5.0.27
4£©°²×°ÅäÖã¬>./configure --prefix=/opt/mysql --with-extra-charsets=all --with-unix-socket-path=/opt/m ......
Õþ¸®»¹ÓÐÒ»¸öÈÃÊý¾Ý¿âר¼Ò̯Éϸü¶àÊÂÇéµÄÖ°ÄÜ£¬¾ÍÊǰ²È«¿ØÖƺÍÊý¾ÝÉ󼯡£ÄÇЩ¹ÜÀíן£Á¿Êý¾Ý²Ö¿âµÄÆóÒµ¹ÙÔ±³£³£µÃ»Ø´ðÖîÈ瓺ÎÈ˺ÎʱÐÞ¸ÄÁËʲô”»òÕß“ºÎÈ˺Îʱ²é¿´ÁËʲô”ÕâÑùµÄÌáÎÊ¡£ÄÇЩӵÓÐÊýÒÔǧ¼ÆµÄÔ±¹¤£¬¿ªÕ¹×Ų»¼ÆÆäÊýµÄÒµÎñµÄÆóÒµ£¬Ã¿Ìì¶¼»á²úÉú³ö´óÁ¿µÄÈÕÖ¾¼Ç¼Êý¾Ý£¬¶øÇÒ±ØÐ뽫ÆäºÃºÃ±£´æ ......