MySQLÖ÷´Ó·þÎñÆ÷£¨Replication£©µÄÉèÖÃ
Ê×ÏÈÉèÖÃMySQLÖ÷·þÎñÆ÷£º
ÔÚÖ÷·þÎñÆ÷ÉÏΪ´Ó·þÎñÆ÷½¨Á¢Ò»¸öÓû§£º
grant replication slave on *.* to 'Óû§Ãû'@'Ö÷»ú' identified by 'ÃÜÂë';
Èç¹ûʹÓõÄÊÇMySQL 4.0.2֮ǰµÄ°æ±¾£¬ÔòÓÃfileȨÏÞÀ´´úÌæreplication slave
±à¼Ö÷·þÎñÆ÷µÄÅäÖÃÎļþ£º/etc/my.cnf
server-id=1
log-bin
binlog-do-db=ÐèÒª¸´ÖƵÄÊý¾Ý¿âÃû£¬Èç¹û¸´Öƶà¸öÊý¾Ý¿â£¬Öظ´ÉèÖÃÕâ¸öÑ¡Ïî¼´¿É
binlog-ignore-db=²»ÐèÒª¸´ÖƵÄÊý¾Ý¿â¿àÃü£¬Èç¹û¸´Öƶà¸öÊý¾Ý¿â£¬Öظ´ÉèÖÃÕâ¸öÑ¡Ïî¼´¿É
×¢Ò⣺Èç¹ûÄãÏë×öÒ»¸ö¸´ÔÓµãµÄ½á¹¹£º±ÈÈç˵£¬A->B->C£¬ÆäÖÐBÊÇAµÄ´Ó·þÎñÆ÷£¬Í¬Ê±BÓÖÊÇCµÄÖ÷·þÎñÆ÷£¬ÄÇôB·þÎñÆ÷³ýÁËÐèÒª´ò¿ªlog-binÖ®Í⣬»¹ÐèÒª´ò¿ªlog-slave-updatesÑ¡ÏÄã¿ÉÒÔÔÙBÉÏʹÓÓshow variables like 'log%';”À´È·ÈÏÊÇ·ñÒѾÉúЧ¡£
±à¼´Ó·þÎñÆ÷µÄÅäÖÃÎļþ£º/etc/my.cnf
server-id=2
master-host=Ö÷»ú
master-user=Óû§Ãû
master-password=ÃÜÂë
master-port=¶Ë¿Ú
replicate-do-db=ÐèÒª¸´ÖƵÄÊý¾Ý¿âÃû£¬Èç¹û¸´Öƶà¸öÊý¾Ý¿â£¬Öظ´ÉèÖÃÕâ¸öÑ¡Ïî¼´¿É
replicate-ignore-db=ÐèÒª¸´ÖƵÄÊý¾Ý¿âÃû£¬Èç¹û¸´Öƶà¸öÊý¾Ý¿â£¬Öظ´ÉèÖÃÕâ¸öÑ¡Ïî¼´¿É
ÅäÖÃÖ÷´Ó·þÎñÆ÷µÄmy.cnfʱ£¬ÁôÐĸ÷×ÔµÄserver-idÒ»¶¨Òª±Ë´Ë¶ÀÁ¢£¬²»ÄÜÖØ¸´£¬·ñÔò£¬»á³öÏÖÈçÏ´íÎó£º
Slave: received end packet from server, apparent master shutdown
ÁíÒ»¸öÐèҪעÒâµÄÊÇ×îºÃÔÚ´Ó·þÎñÆ÷µÄmy.cnfÀïÉèÖÃread_onlyÑ¡Ï·ÀÖ¹·¢ÉúÒâÍ⣨Á¬½ÓÓû§²»ÄÜÓÐSUPERȨÏÞ£¬·ñÔòÎÞЧ£©¡£
¼ÇµÃÏÈÊÖ¶¯Í¬²½Ò»ÏÂÖ÷´Ó·þÎñÆ÷£¬Êý¾ÝÁ¿Ð¡µÄ»°¿ÉÒÔÓÃmysqldump£¬ËüÓÐÒ»¸ömaster-data²ÎÊýºÜÓÐÓã¬Í¨¹ýʹÓô˲ÎÊý£¬µ¼³öµÄSQLÎļþÀï»á×Ô¶¯°üº¬CHANGE MASTER TO MASTER_LOG_FILE='...', MASTER_LOG_POS=...;£¬ÕâÑù´´½¨´Ó·þÎñÆ÷¾Í¸ü·½±ãÁË¡£
Èç¹ûÊý¾ÝÁ¿´óµÄ»°²»Ì«ÊʺÏʹÓÃmysqldump£¨Âý£©£¬Èç¹ûÊÇmyisam±íµÄ»°£¬¼ÓÉÏ--lock-all-tables²ÎÊý£¬Èç¹ûÊÇinnodb±íµÄ»°£¬¼ÓÉÏ--single-transaction²ÎÊý¡£
¶øÓ¦¸Ã²ÉÓÿ½±´ÎļþµÄ·½Ê½£¬Çë°´ÈçϲÙ×÷²½Ö裺
ÏÈÔÚÖ÷·þÎñÆ÷ÉÏËø¶¨ËùÓÐµÄ±í£¬ÒÔÃâÔÚ¸´Öƹý³ÌÖÐÊý¾Ý·¢Éú±ä»¯£º
mysql> flush tables with read lock;
È»ºóÔÚÖ÷·þÎñÆ÷Éϲéѯµ±Ç°¶þ½øÖÆÎļþµÄÎļþÃû¼°Æ«ÒÆÎ»Öãº
mysql > show master status;
È»ºóÍ£Ö¹Ö÷·þÎñÆ÷ÉϵÄMySQL·þÎñ£º
shell> mysqladmin -u root shutdown
×¢Ò⣺Èç¹û½öÊÇMyISAMµÄ»°£¬¿ÉÒÔ²»Í£Ö¹MySQL·þÎñ£¬µ«ÒªÔÚ¸´ÖÆÊý¾ÝÎļþµÄ¹ý³ÌÖб£³ÖÖ»¶ÁËø£¬Èç¹ûÊÇIn
Ïà¹ØÎĵµ£º
ͨ³£ÎÒϰ¹ß½«mysqlÊý¾Ý¿âÉèÖÃĬÈϱàÂëΪutf-8£¬Õâ¾ÍÓÐÒ»¸öÎÊÌ⣬ÔÚwindows¿Í»§¶ËÖÐÖÐÎÄÏÔʾÂÒÂ룬ÒòΪwindowsĬÈϱàÂëΪgb2312»òansi¡£¶à·½²éÕÒÖÕÓÚ½â¾ö£¬ÔÚwindows¿Í»§¶ËµÇÈëmysql
ÊäÈë
set NAMES GB2312;
СÃüÁ´ó×÷Óð¡¡£ ......
PBÁ¬½ÓMySQLÊý¾Ý¿â
È¥mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØodbc connector(http://dev.mysql.com/downloads/connector/odbc/)
ÏÂÔØµÄÊÇmysql-connector-odbc-noinstall-5.1.6-win32.zip
½âѹºóÖ±½ÓÔËÐÐÎļþ¼ÐÖÐµÄ Install.bat Åú´¦ÀíÎļþ
mysql-connectorÓкü¸ÖÖ£¬Ñ¡ÔñÒ»¸ö×Ô¼ºÏ²»¶µÄ¼´¿É¡£
ÔÚxpÖдò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......
ÔÚ×ÀÃæÉÏн¨Ò»¸ö¿ÕµÄÎı¾Îļþmysql.txt,ÖØÃüÃûΪmysql.udl,Ë«»÷Õâ¸ömysql.udlÎļþ£¬´ò¿ª“Êý¾Ý¿âÁ¬½ÓÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ìṩ³ÌÐò”ҳѡÔñ”Micrsoft Ole DB Provider for ODBC Drivers“£¬ µã»÷ÏÂÒ»²½£¬ÔÚ“Á¬½Ó”Ò³µÄ,"Ö¸¶¨Êý¾ÝÔ´"Ñ¡Ôñ"ʹÓÃÁ¬½Ó×Ö·û´®",µã» ......
ÔÎÄת×Ôhttp://www.mysqlsystems.com/2009/04/mysql_sanbox.html
һȺº£ëàÔÚÊôÓÚ×Ô¼ºµÄº£Ì²ÉÏ×ÔÓɵÄÍæË££¬¾¡¹ÜÖ»ÊÇÒ»¸ö·½ºÐµÄ´óС£¬µ«ÊÇÉ豸һÑù
µÄÆëÈ«£¬Í¬Ñù¿ÉÒÔÍæµÄºÜ¿ªÐÄ£¬Õâ¾ÍÊÇÎÒ½ñÌìҪ˵µÄ——MySQL Sandbox2.0£¬3.0Ò²½«ÒªÍƳö¡£
MySQL
SandboxÊÇÒ»¸ö·Ç³£¼òµ¥¿ì½Ý²¿ÊðMySQL¼¼ÊõµÄÒ»¸ö¹¤¾ßÌ×¼þ£¬Ëü¿É ......
ÔÚrootÕ˺ÅÖÐ,¿ÉÒÔÕý³£µ÷Óô洢¹ý³Ì.
»»µ½common_userÕ˺Åʱ,ͬһ´æ´¢¹ý³ÌÃûµ÷ÓóöÏÖÎÊÌâ.
×·×Ùµ÷ÊÔʱ³öÏÖ:
SELECT command denied to user 'common_user'@'localhost' for table 'proc'
ËÑË÷½â¾ö·½°¸:
MySqlConnection myconnection = new MySqlConnection("server=localhost;user id=common_user; password=***;dat ......