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ÌÐòÔ±ÐèҪȥ¹Ø×¢µÄÊÂÇé¡£µ±ÎÒÃÇÈ¥Éè¼ÆÊý¾Ý¿â±í½á¹¹£¬¶Ô²Ù×÷Êý¾Ý¿âʱ£¨ÓÈÆäÊ ......
http://www.cnblogs.com/amboyna/archive/2009/11/16/1603867.html
ÓÐÒ»¶ÎÈÕ×ÓÁË£¬Ôø¾ÉèÖÃÁËÒ»´Î¼Ç¼ÔÚmysqlÖвéѯÂýÓÚ1ÃëÖÓµÄSQLÓï¾ä¡£¸Õ²ÅͻȻ»ØÏëÉèÖõķ½·¨£¬Óм¸¸ö²ÎÊýµÄÃû³ÆËÀ»î»ØÒä²»ÆðÀ´ÁË£¬ÓÚÊÇÖØÐÂÕûÀíһϣ¬×Ô¼º×ö¸ö±Ê¼Ç¡£
¶ÔÓÚÅŲéÎÊÌâÕÒ³öÐÔÄÜÆ¿¾±À´Ëµ£¬×îÈÝÒ×·¢ÏÖ²¢½â¾öµÄÎÊÌâ¾ÍÊÇMYSQLµÄÂý²éѯÒÔ¼°Ã»Óеà ......
¹Ø¼ü×Ö: key×Ö¶ÎÊÇmysqlÀïÃæµÄ¹Ø¼ü×Ö
insert into app(name,created,key,secret,masterSecret) values ('aa',null,null,null,null);
ÒòΪÕâÀïµÄkey×Ö¶ÎÊÇmysqlµÄ¹Ø¼ü×Ö£¬ËùÒÔÒ»Ö±²å²»½øÈ¥¡£
ÐÞ¸ÄÈçÏÂ:ÔÚkeyµÄÍ·ÉϼÓÉÏÁ½µã(·´ÒýºÅ£¬ËüÔÚ¼üÅ̵Ä~Õâ¸ö¼üÉÏ)¡£¼´¿É¸ã¶¨
sql½¨±íÈçÏ£º
Java´úÂë
CREATE T ......
Óï·¨:
/usr/local/mysql/bin/mysqladmin -u username -p newpassword
ϵͳ»áÌáʾÄúÊäÈë¾ÉÃÜÂë:
°´Enterºó,ϵͳ½«¾ÉµÄÃÜÂë¸Ä³Énewpassword,
×¢Òânewpassword²»ÊÇÃüÁî,ÊÇÒ»¸ö×Ö´®,¾ÍÊÇÐÂÃÜÂëµÄ×Ö´®,Äã¿ÉÒÔ¸ü¸Ä³ÉÆäËüµÄ.
-uºóÃæ¸ú×ÅÊÇÓû§Ãû,¾ÍÊÇÄãËùÒª¸ü¸ÄµÄÓû§Ãû. ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......