mysql ¶àÖ÷Ò»´Ó£¬·Ö±íͬ²½¡£¿É·ñ£¿£¿
ÎÒÓиöÐèÇó£º
Èý¸ömysqlµÄMaster---A,B,C.Ò»¸ömysqlµÄSlave---S
AÖÐÓÐÕűíT_A£»BÖÐÓÐÕűíT_B£»CÖÐÓÐÕűíT_C£»¶øÔÚSÖÐÓÐÈýÕÅ±í£¬T_A,T_B,T_C¡£·Ö±ð¶ÔÓ¦T_A,T_B,T_C¡£
ÎÒÏëA,B,C,ÖÐдÈëÊý¾Ý£¬ÒªÍ¬²½µ½SÖС£
Ò²¾ÍÊÇ˵£ºÈý¸öÖ÷£¬Ò»¸ö´Ó¡£ÔÚmysqlÀïÃæ¿É·ñʵÏÖÄØ£¿£¿
ÎÒÑо¿Á˺þÃÁË£¬Ã»ÓÐʵÏÖ¡£ÓÐÈË˵²»¿ÉÒÔ£¬ÓÐÈË˵¿ÉÒÔ¡£
ÓÐÈËÄÜȨÍþµÄ¸æËßÎÒµ½µ×ÄÜ»¹ÊDz»ÄÜÂð£¿
ÓÐÈ˰ïæ½â´ðÂð£¿
´ó¼ÒûÓÐÈËÔ¸Òâ½â´ðÂð£¿
¼òµ¥µØËµ£¬²»¿ÉÒÔ£¬Ã¿¸ö´ÓÖ»ÄÜÓÐÒ»¸öÖ÷¡£
±È½ÏÈÆµÄ°ì·¨¿ÉÒÔʵÏÖ——°³µ±Äê¾ÍÊÇÕâô¸ÉµÄ£º^_^
AûÓÐÖ÷£»
BµÄÖ÷ÊÇA£¬Ö»¸´ÖƱíT_A£»
CµÄÖ÷ÊÇB£¬¸´ÖƱíT_AºÍT_B£»
SµÄÖ÷ÊÇC£¬¸´ÖƱíT_A£¬T_BºÍT_C
ÒªµãÊÇÉèÖÃB/C°ÑslaveµÄÐÞ¸ÄҲдµ½ÈÕÖ¾Àï¡£
Èç¹ûÓбíÃû³åÍ»µÄ»°£¬¿ÉÒÔÁí½¨Êý¾Ý¿âרÃÅÓÃÓÚ´Ë¡£
¶àл£¡µ«Õâ²»ÊÇÎÒÏ£ÍûµÄģʽ¡£
ÎÒÏëͨ¹ýmysqld_multiÀ´ÊµÏÖÔÚ´Ó·þÎñÆ÷ÉÏÆô¶¯¶à¸ömysqld£¬µ«ÊÇÿ¸ömysqldËùʹÓõÄÊý¾ÝÎļþÉèÖÃΪһÑùµÄ£¬¾ÍÊÇSµÄÊý¾Ý¿âÎļþ¡£ÕâÑù¿ÉÒÔ°É¡£ÔÚwindowsÏ¿ÉÒÔÂð£¿
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......