ÅäÖÃmysql´Ô¿âСÐÄʹÓÃreplicate_do_dbºÍreplicate_ignore_db
²é¿´ÎÄÕÂ
СÐÄʹÓÃreplicate_do_dbºÍreplicate_ignore_db2009-01-07 15:54ʹÓÃreplicate_do_dbºÍreplicate_ignore_dbʱÓÐÒ»¸öÒþ»¼£¬¿ç¿â¸üÐÂʱ»á³ö´í
СÐÄʹÓÃreplicate_do_dbºÍreplicate_ignore_db2009-01-07 15:54ʹÓÃreplicate_do_dbºÍreplicate_ignore_dbʱÓÐÒ»¸öÒþ»¼£¬¿ç¿â¸üÐÂʱ»á³ö´í
ÈçÉèÖà replicate_do_db=test
use mysql;
update test.table1 set ......
µÚ¶þ¾ä½«²»»á±»Ö´ÐÐ
use mysql;
update test.table1 set ......
µÚ¶þ¾ä½«²»»á±»Ö´ÐÐ
ÈçÉèÖà replicate_ignore_db=mysql
use mysql;
update test.table1 set ......
µÚ¶þ¾ä»á±»ºöÂÔÖ´ÐÐ
use mysql;
update test.table1 set ......
µÚ¶þ¾ä»á±»ºöÂÔÖ´ÐÐ
ÔÒòÊÇÉèÖÃreplicate_do_db»òreplicate_ignore_dbºó£¬MySQLÖ´ÐÐsqlÇ°¼ì²éµÄÊǵ±Ç°Ä¬ÈÏÊý¾Ý¿â£¬ËùÒÔ¿ç¿â¸üÐÂÓï¾ä±»ºöÂÔ¡£
¿ÉÒÔʹÓÃreplicate_wild_do_tableºÍreplicate_wild_ignore_tableÀ´´úÌæ
Èç
replicate_wild_do_table=test.%
»ò
replicate_wild_ignore_table=mysql.%
ÕâÑù¾Í¿ÉÒÔ±ÜÃâ³öÏÖÉÏÊöÎÊÌâÁË
Èç
replicate_wild_do_table=test.%
»ò
replicate_wild_ignore_table=mysql.%
ÕâÑù¾Í¿ÉÒÔ±ÜÃâ³öÏÖÉÏÊöÎÊÌâÁË
ÍƼöÐÅÏ¢
- ¡¾ÊÓƵ²¥·Å¡¿JplayerÊÓƵ²¥·ÅÆ÷µÄʹÓÃ
- memcacheÄÚ´æÔÀí
- Memcache¼¼Êõ·ÖÏí£º½éÉÜ¡¢Ê¹Óᢴ洢¡¢Ëã·¨¡¢ÓÅ»¯....
- php³£ÓÃÕýÔò±í´ïʽ
- phpÐÔÄܼà²âÄ£¿éXHProf
- ÈÃCI¿ò¼ÜÖ§³Öservice²ã
- ʹÓÃPHPÉú³É´øLOGOµÄ¸öÐÔ»¯¶þάÂëͼÏñ
- ¹ØÓÚCodeIgniterÄã¿ÉÄܲ»ÖªµÀµÄ5¸ö֪ʶµã
- Memcache ºÁÃ뼶³¬Ê±¼°ÆäËû³£¼ûÎÊÌâ»ã×Ü
- [PHP±Ê¼Ç]PHPQueryÒ»¸ö´¦ÀíDOMµÄÀûÆ÷
ÈÈÃÅÐÅÏ¢
- nohup: redirecting stderr to stdou....
- ʹÓÃlog_formatΪNginx·þÎñÆ÷ÉèÖøüÏêϸµÄÈÕÖ¾¸ñʽ
- jquery easyUI--dataGrid-Json
- [Ô´´]·ÂGoogle Reader¡¢ÐÂÀË΢²©¡¢ÌÚѶ΢²©µ....
- ÀûÓÃKeepalived+mysql¹¹½¨¸ß¿ÉÓÃMySQLË«Ö÷×Ô¶....
- Nginx+keepalivedʵÏÖ¸ºÔؾùºâºÍË«»úÈȱ¸¸ß¿ÉÓÃ
- jqueryʵÏÖÒ³Ãæ¼ÓÔؽø¶ÈÌõ
- Rolling cURL: PHP²¢·¢×î¼Ñʵ¼ù
- codeigniter ·ÓÉÖÕ¼«ÓÅ»¯(url rewrite)
- linuxÏÂÉèÖÃsshÎÞÃÜÂëµÇ¼
×î½ü¸üÐÂ
- PHP»ñÈ¡Óû§µÄÕæʵIP£¬²¢ÅжÏÊÇ·ñÄÚÍøIP
- PHP ´íÎóÈÕÖ¾ error_log
- ÀûÓÃbigpipe»úÖÆʵÏÖÒ³ÃæÄ£¿éµÄÒì²½äÖȾ chunked¼¼Êõ
- php¿ØÖÆÎļþÏÂÔØËÙ¶È
- js + php ¶ÁÈ¡¡¢²¥·ÅÊÓƵÁ÷ ¼æÈÝfirefox£¬c....
- ¡¾ÊÓƵ²¥·Å¡¿JplayerÊÓƵ²¥·ÅÆ÷µÄʹÓÃ
- UNICODE Óë UTF-8 µÄ¹Øϵ
- memcacheÄÚ´æÔÀí
- Memcache¼¼Êõ·ÖÏí£º½éÉÜ¡¢Ê¹Óᢴ洢¡¢Ëã·¨¡¢ÓÅ»¯....
- phpʹÓÃmb_detect_encoding¼ì²â×Ö·û´®±àÂë
ÆÀÂÛ