MySQLÊý¾Ý¿âÎóɾ³ýºóÈçºÎ»Ö¸´£¿Êý¾Ý¿â
ÔÚÈÕ³£ÔËά¹¤×÷ÖУ¬¶ÔÓÚÊý¾Ý¿âµÄ±¸·ÝÊÇÖÁ¹ØÖØÒªµÄ£¡Êý¾Ý¿â¶ÔÓÚÍøÕ¾µÄÖØÒªÐÔʹµÃÎÒÃÇ¶Ô MySQL Êý¾Ý¿âµÄ¹ÜÀí²»ÈÝÓÐʧ£¡È»¶øÊÇÈË×ÜÄÑÃâ»á·¸´íÎó£¬Ëµ²»¶¨ÄÄÌì´óÄÔ¶Ì·ÁË£¬Îó²Ù×÷°ÑÊý¾Ý¿â¸øÉ¾³ýÁË£¬Ôõô°ì£¿
ÏÂÃæ£¬¾Í MySQL Êý¾Ý¿âÎóɾ³ýºóµÄ»Ö¸´·½°¸½øÐÐ˵Ã÷¡£
Ò»¡¢¹¤×÷³¡¾°
£¨1£©MySQLÊý¾Ý¿âÿÍí12:00×Ô¶¯ÍêÈ«±¸·Ý¡£
£¨2£©Ä³ÌìÔçÉÏÉϰ࣬9µãµÄʱºò£¬Ò»Í¬Ê·¸ÔÎdropÁËÒ»¸öÊý¾Ý¿â£¡
£¨3£©ÐèÒª½ô¼±»Ö¸´£¡¿ÉÀûÓñ¸·ÝµÄÊý¾ÝÎļþÒÔ¼°ÔöÁ¿µÄbinlogÎļþ½øÐÐÊý¾Ý»Ö¸´¡£
¶þ¡¢Êý¾Ý»Ö¸´Ë¼Â·
£¨1£©ÀûÓÃÈ«±¸µÄsqlÎļþÖмǼµÄCHANGE MASTERÓï¾ä£¬binlogÎļþ¼°ÆäλÖõãÐÅÏ¢£¬ÕÒ³öbinlogÎļþÖÐÔöÁ¿µÄÄDz¿·Ö¡£
£¨2£©ÓÃmysqlbinlogÃüÁÉÏÊöµÄbinlogÎļþµ¼³öΪsqlÎļþ£¬²¢ÌÞ³ýÆäÖеÄdropÓï¾ä¡£
£¨3£©Í¨¹ýÈ«±¸ÎļþºÍÔöÁ¿binlogÎļþµÄµ¼³ösqlÎļþ£¬¾Í¿ÉÒÔ»Ö¸´µ½ÍêÕûµÄÊý¾Ý¡£
Èý¡¢ÊµÀý˵Ã÷
Ê×ÏÈ£¬ÒªÈ·±£mysql¿ªÆôÁËbinlogÈÕÖ¾¹¦ÄÜ¡£ÔÚ/etc/my.cnfÎļþÀïµÄ[mysqld]Çø¿éÌí¼Ó£º
log-bin=mysql-bin
È»ºóÖØÆômysql·þÎñ
£¨1£©ÔÚops¿âÏ´´½¨Ò»Õűícustomers
mysql> use ops;
mysql> create table customers(
-> id int not null auto_increment,
-> name char(20) not null,
-> age int not null,
-> primary key(id)
-> )engine=InnoDB;
Query OK, 0 rows affected (0.09 sec)
mysql> show tables;
+---------------+
| Tables_in_ops |
+---------------+
| customers |
+---------------+
1 row in set (0.00 sec)
mysql> desc customers;
+-------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | char(20) | NO | | NULL | |
| age | int(11) | NO | | NULL | |
+-------+----------+------+-----+---------+----------------+
3 rows in set (0.02 sec)
mysql> insert into customers values(1,"wangbo","24");
Query OK, 1 row affected (0.06 sec)
mysql> insert into customers values(2,"guohui","22");
Query OK, 1 row affected (0.06 sec)


- 2016Äê3ÔÂÍøÃñÉÏÍøÊ±¼ä·Ö²¼£ºÍíÉÏ9µã
- Å̵ã×îÔçµÄÊý×ÖÓòÃû ÔÀ´ËüÃÇÕâôÓÐ
- £¨.ÎÒ°®Ä㣩ÓòÃû2015Äê¶È³ÂËߣºÉÌÎñ
- 2016Äê1ÔÂÊÕ¼¯²»Á¼ÓëÀ¬»øÐÅÏ¢£ºÒù»à
- ÆØ°¢Àï°Í°ÍµÍµ÷ÊÕ¹º2¸ö¡°°¢À￵
- 1ÔÂ28ÈÕÈ«ÇòÓòÃûÉ̽âÎöÐÂÔöÁ¿21Ç¿£º
- °¢ÀïÔÆÆìÏÂ.xinÓòÃû15ºÅ¿ª·Å×¢²á »ò
- ¿ç¾³µçÉÌÈÈ ÊÇÌÌÊÖɽÓóÕÕ¾ÉÏãâÄâÄ£¿
- Hadoop½«ËÀ£¬Í¼Êý¾Ý¿â³ÉΪÐÂÇ÷ÊÆ£¿¿´
