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

ÁªºÏMySQL Proxy ºÍMySQL Cluster£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â


ÁªºÏMySQL Proxy ºÍMySQL Cluster£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â
Ô­ÎÄ£ºhttp://blogs.mysql.com/kaj/2007/12/10/combining-mysql-proxy-with-mysql-cluster/
       ²»¾Ãǰ£¬ÎÒºÍStewart Smith, Vinay Joosery, Monty Taylor ÒÔ¼°ÆäËûµÄmysqlʹÓÃÕߣ¨ËûÃDZÈÎÒ¸üÊìϤMySQL Cluster £©Õ¹¿ªÁËÒ»´ÎÌÖÂÛ£¬Ì½ÌÖµÄÖ÷ÌâÊÇ£ºÔÚ²»¸ü¸ÄÓ¦ÓõÄÇé¿öÏ£¬Ê¹ÓÃMySQL ProxyÀ´Ïû³ýMySQL Cluster µÄÈ«±íɨÃè¡£
      ÌÖÂÛÔ´×ÔÎÒÎÊStewartµÄÒ»¸öÎÊÌ⣺À©Õ¹MySQL ClusterʹÓÃÓû§ÊýÁ¿µÄÆ¿¾±ÊÇʲô£¿Ëû»Ø´ð£ºÆ¿¾±¿ÉÄÜÀ´×ÔJoinºÍÆäËûµÄselect¿ÉÄÜÐèҪɨÃèÊý¾Ý¿âµÄ´ó²¿·Ö¡£ÕâÀïÓÐÆäËû¸ü¿ìµÄ´æ´¢ÒýÇæ£¬±ÈÈç MyISAM and InnoDB¡£
    
        ´ÓÒ»¸ö¼òµ¥µÄͼÀ´¿´——Èçͼ1£¬Ó¦ÓúÍMySQL Clusterͨ¹ýsql½»»¥£¬Í¬Ê±µÃµ½Ò»Ð©·þÎñµÄÏìÓ¦¡£ÕâÖÖ¹Ûµã¿ÉÒÔͼ1 ÖдøÓÐË«¼ýÍ·µÄ“sql”À´±íʾ¡£“sql”Ö÷Òª°üÀ¨ÏÂÃæ¼¸²¿·Ö£º
                      UPDATE, INSERT, DELETE Óï¾ä£¬ÇáÁ¿¼¶µÄ£¬¾­³£¾ÍÓ°Ï켸ÐЗ—ÔÚͼ2ÖÐÓÃÀ¶É«µÄµ¥Ïò¼ýÍ·±íʾ
                      ¼òµ¥µÄSELECTÓï¾ä£¬Ò²ÊÇÇáÁ¿¼¶µÄ£¬ÕâÖÖ²éѯͨ³£Ê¹ÓÃË÷ÒýÀ´·µ»Ø¼¸ÐЗ—ÔÚͼ2ÖÐÓúÚÉ«µÄË«Ïò¼ýÍ·±íʾ
                      ¸´ÔÓµÄSELECTÓï¾ä£¬±ÈÈç³£¼ûµÄʹÓÃ" select *"  £¬µ«ÕâÖÖÓï¾ä²»ÊÇʹÓÃË÷Òý£¬¶øÇÒ¾­³£»á·µ»Ø¶àÐÐÊý¾Ý——Õâ     ÖÖÇé¿öÔÚͼ2ÖÐÓôøÐéÏßµÄË«Ïò¼ýÍ·£¨×¢Òâ·µ»Ø¶ÎµÄÁ½¸ö¼ýÍ·´ú±í·µ»Ø¶àÊý¾Ý£©±íʾ
 
           Í¼2²¢Ã»ÓÐÔÚÓ¦ÓýṹÉϺÍͼ1²úÉú±ä»¯£¬Ö»ÊǸü¼ÓµÄϸÁ£¶ÈÒ»µã¡£ÏÖÔÚÎÒÃÇÀ´¿´ÆÕͨµÄMySQL Server £¨´øÓÐMyISAM »ò InnoDBÒýÇæ£©Äܹ»¸ü¿ìµÄ·¢Ë͸´ÔӵIJéѯÇëÇó¡£ÔÚͼ3ÖУ¬ÎÒÃÇÄÜ¿´µ½£º
              


Ïà¹ØÎĵµ£º

UbuntuÏÂÅäÖÃLAMP£¨Linux+Apache+Mysql+PHP)»·¾³

ÖÕÓڷżÙÁË£¬ÕýÏëÔÚÕâ¸ö¼ÙÆÚÀïѧѧPHP£¬ÓÉÓÚ×Ô¼ºÓõÄÊÇ×ÀÃæ°æµÄUbuntu8.04,ÓÚÊǾÍÏë¼ÜÉèÒ»¸öLAMP»·¾³À´Ñ§PHP£¬Ò²³Ã´Ë»ú»áѧһÏÂPHP·þÎñÆ÷µÄ¼ÜÉè¡£
Ò»¡¢°²×°Ubuntu8.04
ËäȻ˵ÊÇÅäÖÃLAMP»·¾³£¬µ«ÔÚÎÄÕÂÀï²¢²»»á½²ÊöÈçºÎ°²×°Ubuntu8.04,ÒòΪ¹ØÓÚÈçºÎUbuntu8.04ÔÚÍøÉÏÒѾ­ÓкܶàµÄ½Ì³ÌÁË£¬¾ÍËãÊÇÓ²Å̰²×°Ò²ÊÇÒ»¼þºÜ¼òµ¥µÄÊÂÁ ......

javaÁ¬½ÓmysqlÊý¾Ý¿â

Ê×ÏÈ£¬ÒªÏÂÔØÒ»¸öÁ¬½ÓmysqlÊý¾Ý¿âµÄÇý¶¯³ÌÐò: mysql-connector-java-3.0.15-ga-bin.jar, Õâ¸öÇý¶¯³ÌÐò²»ÐèÒª×öÆäËüÅäÖÃ,Ò²¾ÍÊÇ˵£¬¶ÔÓÚmysqlÊý¾Ý¿â£¬²»±ØÏñaccess»òÕßoracleÒª½¨Á¢odbcÊý¾ÝÔ´¡£
 
Æä´Î£¬½«ÉÏÃæµÄ.jarÎļþ¼ÓÈëµ½classpath»·¾³±äÁ¿ÖС£
×îºó£¬¾ÍÊÇд´úÂë½øÐвâÊÔÁË¡£
 
Ö÷Òª´úÂëÈçÏ£º
  ......

LVS+Mysql¼¯Èº¸ºÔؾùºâ ÄÚÍølvsÅäÖÃ

Ò»¡¢IPÐÅÏ¢ÁÐ±í£º
   Ãû³Æ                 IP   
   LVS-DR-VIP            192.168.50.245
   LVS-DR-Master  ......

Á¬½ÓmysqlµÄjavabeanʵÀý+¼òµ¥·ÖÒ³

<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*,java.util.*"%>
<html>
<head>
<title>Á¬½ÓmysqlµÄjavabeanʵÀý+¼òµ¥·ÖÒ³</title>
<link href="../CSS.css" rel="stylesheet" type="text/css">
</head>
<body>
<jsp:useBean ......

ÈçºÎµ¼Èëµ¼³öMySQLÊý¾Ý¿â *.sqlÎļþ²Ù×÷

 
1. ¸ÅÊö
MySQLÊý¾Ý¿âµÄµ¼È룬ÓÐÁ½ÖÖ·½·¨£º
1) Ïȵ¼³öÊý¾Ý¿âSQL½Å±¾£¬ÔÙµ¼È룻
2) Ö±½Ó¿½±´Êý¾Ý¿âĿ¼ºÍÎļþ¡£
ÔÚ²»Í¬²Ù×÷ϵͳ»òMySQL°æ±¾Çé¿öÏ£¬Ö±½Ó¿½±´ÎļþµÄ·½·¨¿ÉÄÜ»áÓв»¼æÈݵÄÇé¿ö·¢Éú¡£
ËùÒÔÒ»°ãÍÆ¼öÓÃSQL½Å±¾ÐÎʽµ¼Èë¡£ÏÂÃæ·Ö±ð½éÉÜÁ½ÖÖ·½·¨¡£
Linux주
2. ·½·¨Ò» SQL½Å±¾ÐÎʽ
²Ù×÷²½ÖèÈçÏ£º
2 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ