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

ÍøÕ¾¾µÏñ£¬Ö÷ÍøÕ¾ºÍ¾µÏñÍøÕ¾MysqlÊý¾Ýͬ²½

ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ

ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµÄ¸üР ºÍ Óû§ÉÏ´«µÄÎļþ¸üÐÂ

ÎÒÏÖÔÚÔÚ¿´mysqlÊý¾Ý¿âµÄͬ²½¡£ ÔÚÁ½Ì¨·þÎñÆ÷ÉϵÄmysqlÊý¾Ý¿âÖ®¼äµÄͬ²½
ÍøÉϲéÁËÏÂmysqlÈȱ¸·Ý£¬´ó¶à½²µÄÊÇÊý¾Ý´Ó Ö÷·þÎñÆ÷ µ½ ´Ó·þÎñÆ÷ÉÏ¡£½²Ë«ÏòÈȱ¸µÄ±È½ÏÉÙ¡£ÓÉÓÚmysqlÈȱ¸·ÝÊÇÒì²½´¦ÀíµÄ£¬¶ÔÓÚauto_increment×ֶεÄÖµ£¬Ë«ÏòÈȱ¸µÄʱºò²»ÖªµÀ»á²»»á³öÎÊÌ⣿


Ï£Íû´ó¼Ò¿ÉÒÔ¸øСµÜÌṩһЩ½¨ÒéºÍ·½°¸£¬Ð»Ð»¡£

http://dev.mysql.com/doc/refman/5.1/zh/ndbcluster.html

17. MySQL´Ø
17.1. MySQL´Ø¸ÅÊö
17.2. MySQL´ØµÄ»ù±¾¸ÅÄî


MySQL´Ø ÒªÇó·þÎñÆ÷ÊÇÔÚÒ»¸ö¾ÖÓòÍøÖ®ÄڲſÉÒÔ¡£¹ãÓòÍøÉϺÜÄѳɹ¦°¡¡£

Mysql Replication ¹¦ÄÜ¿ÉÒÔ×öË«ÏòµÄÂð  ÎÒµÄÐèÇóÊÇÁ½Ì¨·þÎñÆ÷ÉϵÄÊý¾Ý¿âÊý¾Ý¿ÉÒÔ»¥Ïàͬ²½£¬¿ÉÒÔʵÏÖÂ𣿠ÎÒ¿´µ½MysqlÊÖ²áÀ

The target uses for replication in MySQL include:

Scale-out solutions - spreading the load among multiple slaves to improve performance. In this environment, all writes and updates must take place on the master server. Reads, however, may take place on one or more slaves. This model can improve the performance of writes (since the master is dedicated to updates), while dramatically increasing read speed across an increasing number of slaves.

¶øÎÒµÄÒªÇóÊÇÁ½Ì¨·þÎñÆ÷¶¼¿ÉÒÔËæʱ¸üÐÂÊý¾Ý£¬È»ºó»¥


Ïà¹ØÎÊ´ð£º

javaÁ¬½Ómysql±»¾Ü¾ø

ÎÒÔÚ³ÌÐòÀïÃæдÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......

mysql Ð޸IJéѯÊý¾ÝµÄÎÊÌâ

select time from table

time
2009-09-12 12
2009-09-12 13
2009-09-12 14
2009-09-12 15

Ôõô½« ²éѯµÄÊý¾Ý±äΪ
time
2009-09-12 12ʱ
2009-09-12 13ʱ
2009-09-12 14ʱ
......

MySQL±àÂëµÄÎÊÌâ

ÎÒµÄMySQL±àÂ룬ÎÒÔÚmy.iniÖÐÉèÖõÄΪutf8,ÔÚ´´½¨Êý¾Ý¿âʱѡÔñµÄ±àÂëΪutf8_Unicode_ci£¬ÎÒÔÚ¡¢´ÓÒ³Ãæ²åÈëÊý¾Ý¿â£¬ÔÚÒ³ÃæÉÏÏÔʾÕý³££¬µ«´ÓphpmyadminÖУ¬²é¿´Ê±£¬ÏÔʾΪÂÒÂ루ÎÒÎÒ¡£& ......

Mysql²éѯÎÊÌâ¡£¡£¡£

  ÎÒÏëÔÚmysqlÖн«t_flow_card_detail±íÖеÄclient_id×ֶθÄΪÍâ¼ü£¬ÒýÓÃt_client±íÖеÄclient_id×ֶΣº
  ÎÒµÄsqlÓï¾äÊÇ£º alter table t_flow_card_detail add constraint FK_flowcard_client foreig ......

¹ØÓÚMYSQLµ¥±í´æ´¢ÎÊÌâ

Êý¾Ý¿âÒýÇæʹÓÃMYISAM
ÀýÈç±íÃû£ºLOG¡¡Ã¿Ìì»á²úÉú400Íò×óÓҵļǼ

ÈÕ»ýÔÂÀÛÊý¾ÝÁ¿»á·Ç³£Ö®³è´ó

ËùÒÔ¿¼Âǵ½Õâµã
ÎÒÏëÁËÁ½¸ö·½°¸
1¡¢Ã¿Ìì²úÉúÒ»¸ö±í£¬ÀàËÆLOG20091010¡¢LOG20091011
2¡¢Ã¿Ìì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ