ÍøÕ¾¾µÏñ£¬Ö÷ÍøÕ¾ºÍ¾µÏñÍøÕ¾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.
¶øÎÒµÄÒªÇóÊÇÁ½Ì¨·þÎñÆ÷¶¼¿ÉÒÔËæʱ¸üÐÂÊý¾Ý£¬È»ºó»¥
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
jspÁ¬½ÓmysqlÊý¾Ý¿â²éѯ£¬²¢ÔÚÒ³ÃæÏÔʾ Öм䲻ÓÃstruts£¬ÔõôʵÏÖ£¬ÇóÀý×Ó
javabean ×öÁ¬½Ó
jsp Ò³ÃæʵÀý»¯Àà
jsp Ò³ÃæÏÔʾÊý¾Ý
<%@ page contentType="text/html;
charset=gb2312" ......
linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔÒò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔÒò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔÒò£¬²» ......
ÇëÎÊһϣ¬mysqlµÄsequenceÊÇ×Ô¶¯µÝÔöµÄ£¬²»ÐèÒª½øÐвÙ×÷¡£
ÄÇÎÒÔÚ²åÈëÒ»ÌõÖ÷¼Ç¼µÄʱºò£¬Í¬Ê±Òª¸øÕâ¸öÖ÷¼üµÄÆäËû±í½øÐвåÈëÊý¾Ý¡£Õâʱºò£¬ÎÒ¸ù±¾È¡²»µ½Õâ¸öµÝÔöµÄsequence°¢¡£¡£
Õâ¸öÎÊÌâÔõô½â¾ö°¢¡£¡£
......
ÏÖÓеķþÎñÆ÷ÊÇ4ºË£¬ÄÚ´æΪ4G£¬Êý¾Ý¿âֻʹÓÃinnodbÊý¾ÝÒýÇæ¡£Á´½ÓÊý¿ÉÄܱȽϸߣ¬ÏÈÉèÖÃΪ500°É£¬¶øÇÒÊý¾Ý¿âÖеÄÊý¾Ý²åÈë¡¢¸üкÍɾ³ý²Ù×÷»á·Ç³£µÄƵ·±¡£
ÓÐûÓиßÈË°ïæÅäÖÃÒ»ÏÂmy.cnf
Õâ¸öûÓж¨Â۵ģ¬¾ßÌå ......