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

mysqlÊý¾Ýͬ²½ÎÊÌâÇóÖú

Óà mysql ×öË«Ïòͬ²½ ³öÏÖÁËÒ»µãÎÊÌâ ¾ßÌåÇé¿öÈçÏÂ
A »ú ºÍ B»ú ×öË«Ïòͬ²½
µ± A»ú¸üÐÂÊý¾Ýʱ B»ú»áͬ²½¸üÐÂ
µ«ÊÇ µ± ¶ÏÍøÁË AB»ú ²»ÄÜÁ¬Í¬µÄÇé¿öÏ ·Ö±ðÔÚ A»ú ºÍ B»ú ²Ù×÷Êý¾Ý¿â
¹ýÒ»»á ÍøÂç»Ö¸´ £¬ÔÚ¶ÏÍøÇé¿öÏ ²Ù×÷µÄÊý¾Ý ²»»áͬ²½µ½

ºóÀ´µ÷Á˰ëÌì ³öÏÖÁËÁíÒ»ÖÖÇé¿ö ¾ÍÊÇ ¶ÏÍøºó²Ù×÷µÄÊý¾Ý  A»ú ͬ²½µ½B»ú£¬B»úҲͬ²½µ½ÁËA»ú £¬µÈÓÚ˵ÊǶԵ÷ÁË£¬Èç¹ûÎÒ²Ù×÷µÄÊÇͬһÌõÊý¾Ý£¬ÕâÑù¶Ôµ÷ÁË ±ã³ö´íÁË ÎÒÏ£ÍûÄܱ£Áô×îºó¸üеÄÊý¾Ý.

A B»úµÄ my.cnf ÅäÖ÷ֱðÈçÏÂ

A»ú
[mysqld]
concurrent_insert = 1

#
server-id = 1
log-bin =mysqlbinlog
binlog_do_db = Êý¾Ý¿âÃû³Æ
binlog_ignore_db = mysql
sync_binlog =1
master-host=192.168.0.20
master-user=Êý¾Ý¿â·ÃÎÊÕ˺Å
master-password=Êý¾Ý¿â·ÃÎÊÃÜÂë
master-port=3306
master-connect-retry=60
replicate-do-db=Êý¾Ý¿âÃû³Æ
slave-skip-errors=all
#

B»ú

[mysqld]
concurrent_insert = 1

#
server-id = 2
log-bin =mysqlbinlog
binlog_do_db = Êý¾Ý¿âÃû³Æ
binlog_ignore_db = mysql
sync_binlog =1
master-host=192.168.0.21
master-user=Êý¾Ý¿â·ÃÎÊÕ˺Å
master-password=Êý¾Ý¿â·ÃÎÊÃÜÂë
master-port=3306
master-connect-retry=60
replicate-do-db=Êý¾Ý¿âÃû³Æ
slave-skip-errors=all
#

²»ÖªµÀÊÇÄÄÀïÉèÖÃÓÐÎÊÌâÁË ´ó¼Ò°ïæ¿´ÏÂ
ÄãÕâÖÖÊÇ¡°master <---> master¡±µÄģʽ£


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒ ......

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ