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

MYSQLͬ²½ÎÊÌ⣬¿¨ËÀÔÚÕâÀïÁË[93È«·ÖËͳö]

ÎÒµÄÄ¿±êÊÇʵÏÖÁ½Ì¨»òÕß¶ą̀MYSQLÏ໥ͬ²½£¬ÏÖÔÚÓÃÁ½¸öµçÄÔ×ö²âÊÔ£¬Áíһ̨ÊÇÐÂ×°µÄPC£¨windows server 2003£¬³ÉΪAÖ÷»ú£¬IP=192.168.1.150£©£¬Ò»Ì¨ÊDZʼDZ¾£¨XPϵͳ£¬³ÆÎªBÖ÷»ú£¬IP=192.168.1.10£©£¬¾­¹ýÒ»ÌìµÄÕÛÌÚ£¬ÏÖÔÚµÄÇé¿öÓ¦¸ÃºÍËùÓÐ×ÊÁÏÉÏÌṩµÄ×îÖճɹ¦×´Ì¬ÊDz鲻¶¼ÁË£¬µ«ÊÇ£¬»¹ÊDz»Äܳɹ¦Í¬²½£¬ÇëÀÏÊÖÖ¸µãһϣ»

ÏÈ˵ÅäÖãº
AÖ÷»úµÄMy.iniÎļþ×îºóµÄÄÚÈÝ£º

#ͬ²½²ÎÊýÉèÖÃ

server-id=1
log-bin=C:hobcmsdatamysqllog
binlog-do-db=MY_DATA1
log-slave-updates
master-host=192.168.1.10
master-user=root
master-password=26202122
replicate-do-db=MY_DATA1
master-connect-retry=20
slave-skip-errors=all

BÖ÷»úµÄMy.iniÎļþ×îºóµÄÄÚÈÝ£º

#ͬ²½²ÎÊýÉèÖÃ

server-id=2
log-bin=C:hobcmsdatamysqllog
binlog-do-db=MY_DATA1
log-slave-updates
master-host=192.168.1.150
master-user=root
master-password=26202122
replicate-do-db=MY_DATA1
master-connect-retry=20
slave-skip-errors=all

A»ú²éѯµÄ״̬£º
mysql> show master status;

mysql> show slave status;



B»ú²éѯµÄ״̬£º
mysql> show master status;

mysql> show slave status;


´ÓÉϵÄÐÅÏ¢À´¿´£¬»ù±¾Ö»ÓÐÒ»µãµãµØ²îÒ죬²»ÖªµÀÕâÊÇ·ñΪÎÊÌâÔ­ÒòÖ®ËùÔÚ¡£

ÆäËûÐÅÏ¢£º
Á½Ì¨Ö÷»úµÄ·À»ðǽȫ²¿¹Ø±Õ£¬ÓÃtelnet 192.168.1.150 3306,telnet 192.168.1.150


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ