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
Ïà¹ØÎĵµ£º
PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔÒò¼°½â¾ö
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕ߶¼Í³Ò»²ÅÐУ ......
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Êý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......
Êý¾Ýͬ²½ÎÊÌâÖÕÓÚ½â¾ö£º
תÌû£ºA·þÎñÆ÷£º host 192.168.1.101 port 3306 B·þÎñÆ÷£º host 192.168.1.102 port 3306 1,ÊÚȨÓû§£º A·þÎñÆ÷ mysql>grant replication slave,file on *.* to 'repl9'@'192.168.1.102' identified by '1234569'; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges; Qu ......
sqlserverÖУº
1 /*
2 1 * Description:¶ÔÊý¾Ý±í½øÐÐÐÐÁÐת»»
3 2 * Author:llf
4 3 * µ÷ÓÃ˵Ã÷£ºexec SP_RowChangeCol 'ѧÉú³É¼¨±í','ÐÕÃû','¿Î³Ì','·ÖÊý','desc',0,0,'where Ä꼶=''Ò»Ä꼶'''
& ......
ÔÚ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 ......