免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 数据库技术 › MySQL › 怀疑高并发导致binlog日志错乱，slave复制报错
最近访问板块 发新帖
查看: 4189 | 回复: 2
打印 上一主题 下一主题

怀疑高并发导致binlog日志错乱，slave复制报错 [复制链接]

laizhebujum

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2014-02-21 10:41 |只看该作者 |倒序浏览
本帖最后由 laizhebujum 于 2014-02-21 10:46 编辑

mysql 5.5.21 日志模式mixed

起因应该是有自增ID，binlog自动添加set insert-id ，并且执行的replace还是插入多值，高并发下日志颠倒了顺序，所以复制报错。这是不是mysql的bug呢


表结构
mysql> desc promo_product;
+--------------------+---------------+------+-----+---------+----------------+
| Field              | Type          | Null | Key | Default | Extra          |
+--------------------+---------------+------+-----+---------+----------------+
| id                 | int(11)       | NO   | PRI | NULL    | auto_increment |
| promotion_id       | int(11)       | YES  | MUL | NULL    |                |
| promotion_type     | int(11)       | YES  |     | NULL    |                |
| product_id         | int(11)       | YES  | MUL | NULL    |                |
| shop_id            | int(11)       | YES  | MUL | NULL    |                |
| step               | int(11)       | YES  |     | NULL    |                |
| promo_v_rule_id    | int(11)       | YES  |     | NULL    |                |
| money_compare_type | int(11)       | YES  |     | NULL    |                |
| buy_total_money    | decimal(12,2) | YES  |     | NULL    |                |
| num_compare_type   | int(11)       | YES  |     | NULL    |                |
| buy_total_num      | int(11)       | YES  |     | NULL    |                |
| buy_add_money      | decimal(12,2) | YES  |     | NULL    |                |
| limit_buy_num      | int(11)       | YES  |     | NULL    |                |
| is_sync            | int(11)       | YES  | MUL | NULL    |                |
| is_sync_list       | int(11)       | YES  | MUL | NULL    |                |
| is_delete          | int(11)       | YES  |     | NULL    |                |
| direct_price       | decimal(12,2) | YES  |     | NULL    |                |
| min_prod_price     | decimal(12,2) | YES  |     | NULL    |                |
| special_price      | decimal(12,2) | YES  |     | NULL    |                |
| discount           | int(11)       | YES  |     | NULL    |                |
| coupon_id          | int(11)       | YES  |     | NULL    |                |
| times_points       | int(11)       | YES  |     | NULL    |                |
| ship_fee           | decimal(12,2) | YES  |     | NULL    |                |
| n_discount         | int(11)       | YES  |     | NULL    |                |
| n_num              | int(11)       | YES  |     | NULL    |                |
| max_buy_n          | int(11)       | YES  |     | NULL    |                |
| min_buy_n          | int(11)       | YES  |     | NULL    |                |
| creation_date      | datetime      | YES  |     | NULL    |                |
| last_changed_date  | datetime      | YES  |     | NULL    |                |
| gift_sku_num       | int(11)       | YES  |     | NULL    |                |
| coupon_min_use     | decimal(12,2) | YES  |     | NULL    |                |
| coupon_amt         | decimal(12,2) | YES  |     | NULL    |                |
| coupon_type        | int(11)       | YES  |     | NULL    |                |
| is_sync_model      | int(11)       | YES  | MUL | NULL    |                |
| package_type       | int(11)       | YES  |     | NULL    |                |
| sort_num           | int(11)       | YES  |     | NULL    |                |
+--------------------+---------------+------+-----+---------+----------------+

建表语句
CREATE TABLE `promo_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `promotion_id` int(11) DEFAULT NULL,
  `promotion_type` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `step` int(11) DEFAULT NULL,
  `promo_v_rule_id` int(11) DEFAULT NULL,
  `money_compare_type` int(11) DEFAULT NULL,
  `buy_total_money` decimal(12,2) DEFAULT NULL,
  `num_compare_type` int(11) DEFAULT NULL,
  `buy_total_num` int(11) DEFAULT NULL,
  `buy_add_money` decimal(12,2) DEFAULT NULL,
  `limit_buy_num` int(11) DEFAULT NULL,
  `is_sync` int(11) DEFAULT NULL,
  `is_sync_list` int(11) DEFAULT NULL,
  `is_delete` int(11) DEFAULT NULL,
  `direct_price` decimal(12,2) DEFAULT NULL,
  `min_prod_price` decimal(12,2) DEFAULT NULL,
  `special_price` decimal(12,2) DEFAULT NULL,
  `discount` int(11) DEFAULT NULL,
  `coupon_id` int(11) DEFAULT NULL,
  `times_points` int(11) DEFAULT NULL,
  `ship_fee` decimal(12,2) DEFAULT NULL,
  `n_discount` int(11) DEFAULT NULL,
  `n_num` int(11) DEFAULT NULL,
  `max_buy_n` int(11) DEFAULT NULL,
  `min_buy_n` int(11) DEFAULT NULL,
  `creation_date` datetime DEFAULT NULL,
  `last_changed_date` datetime DEFAULT NULL,
  `gift_sku_num` int(11) DEFAULT NULL,
  `coupon_min_use` decimal(12,2) DEFAULT NULL,
  `coupon_amt` decimal(12,2) DEFAULT NULL,
  `coupon_type` int(11) DEFAULT NULL,
  `is_sync_model` int(11) DEFAULT NULL,
  `package_type` int(11) DEFAULT NULL,
  `sort_num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_unique_rule` (`promotion_id`,`product_id`,`step`,`promo_v_rule_id`),
  KEY `promotion_id` (`promotion_id`) USING BTREE,
  KEY `product_id` (`product_id`) USING BTREE,
  KEY `is_sync` (`is_sync`) USING BTREE,
  KEY `is_sync_list` (`is_sync_list`) USING BTREE,
  KEY `shop_id` (`shop_id`) USING BTREE,
  KEY `is_sync_model` (`is_sync_model`)
) ENGINE=InnoDB AUTO_INCREMENT=94763926 DEFAULT CHARSET=gbk

以下是连贯的binlog，直接执行相当于模拟在从库执行的情形。
主库插入INSERT_ID=92484204的记录在日志里记到了后边，之前...207，...220，....221数据的日志记到了前边，所以从库就先插入了...207，...220，....221三条数据，而后执行日志...204的一段sql就报错了。

/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#140214 17:45:04 server id 1136  end_log_pos 107         Start: binlog v 4, server v 5.5.21-log created 140214 17:45:04
BINLOG '
oOX9Ug9wBAAAZwAAAGsAAAAAAAQANS41LjIxLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
# at 283697754
#140214 18:59:58 server id 1136  end_log_pos 283697823         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
SET @@session.pseudo_thread_id=201578019/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C gbk *//*!*/;
SET @@session.character_set_client=28,@@session.collation_connection=28,@@session.collation_server=28/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
# at 283697823
#140214 18:59:58 server id 1136  end_log_pos 283697851         Intvar
SET INSERT_ID=92484201/*!*/;
# at 283697851
#140214 18:59:58 server id 1136  end_log_pos 283698517         Query        thread_id=201578019        exec_time=0        error_code=0
use promo/*!*/;
SET TIMESTAMP=1392375598/*!*/;
REPLACE INTO `promo_product` (promotion_id,promotion_type,product_id,shop_id,step,money_compare_type,buy_total_money,num_compare_type,buy_total_num,buy_add_money,limit_buy_num,is_delete,creation_date,last_changed_date,is_sync,is_sync_list,is_sync_model,promo_v_rule_id,direct_price,min_prod_price,special_price,discount,coupon_id,coupon_amt,times_points,ship_fee,min_buy_n,n_num,n_discount,sort_num) VALUES ('877577','101','1070184008','9891','1','3',NULL,'3',NULL,NULL,NULL,'0','2014:02:14 18:59:57','2014:02:14 18:59:57','0','0','0','0','357.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1')
/*!*/;
# at 283698517
#140214 18:59:58 server id 1136  end_log_pos 283698544         Xid = 8821635526
COMMIT/*!*/;
# at 283698544
#140214 18:59:58 server id 1136  end_log_pos 283698613         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
BEGIN
/*!*/;
# at 283698613
#140214 18:59:58 server id 1136  end_log_pos 283698641         Intvar
SET INSERT_ID=92484202/*!*/;
# at 283698641
#140214 18:59:58 server id 1136  end_log_pos 283699307         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
REPLACE INTO `promo_product` (promotion_id,promotion_type,product_id,shop_id,step,money_compare_type,buy_total_money,num_compare_type,buy_total_num,buy_add_money,limit_buy_num,is_delete,creation_date,last_changed_date,is_sync,is_sync_list,is_sync_model,promo_v_rule_id,direct_price,min_prod_price,special_price,discount,coupon_id,coupon_amt,times_points,ship_fee,min_buy_n,n_num,n_discount,sort_num) VALUES ('877577','101','1070184408','9891','1','3',NULL,'3',NULL,NULL,NULL,'0','2014:02:14 18:59:57','2014:02:14 18:59:57','0','0','0','0','357.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1')
/*!*/;
# at 283699307
#140214 18:59:58 server id 1136  end_log_pos 283699334         Xid = 8821635528
COMMIT/*!*/;
# at 283699334
#140214 18:59:58 server id 1136  end_log_pos 283699403         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
BEGIN
/*!*/;
# at 283699403
#140214 18:59:58 server id 1136  end_log_pos 283699431         Intvar
SET INSERT_ID=92484203/*!*/;
# at 283699431
#140214 18:59:58 server id 1136  end_log_pos 283700097         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
REPLACE INTO `promo_product` (promotion_id,promotion_type,product_id,shop_id,step,money_compare_type,buy_total_money,num_compare_type,buy_total_num,buy_add_money,limit_buy_num,is_delete,creation_date,last_changed_date,is_sync,is_sync_list,is_sync_model,promo_v_rule_id,direct_price,min_prod_price,special_price,discount,coupon_id,coupon_amt,times_points,ship_fee,min_buy_n,n_num,n_discount,sort_num) VALUES ('877577','101','1070184508','9891','1','3',NULL,'3',NULL,NULL,NULL,'0','2014:02:14 18:59:57','2014:02:14 18:59:57','0','0','0','0','357.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1')
/*!*/;
# at 283700097
#140214 18:59:58 server id 1136  end_log_pos 283700124         Xid = 8821635531
COMMIT/*!*/;
# at 283700124
#140214 18:59:58 server id 1136  end_log_pos 283700193         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
BEGIN
/*!*/;
# at 283700193
#140214 18:59:58 server id 1136  end_log_pos 283700221         Intvar
SET INSERT_ID=92484207/*!*/;
# at 283700221
#140214 18:59:58 server id 1136  end_log_pos 283700887         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
REPLACE INTO `promo_product` (promotion_id,promotion_type,product_id,shop_id,step,money_compare_type,buy_total_money,num_compare_type,buy_total_num,buy_add_money,limit_buy_num,is_delete,creation_date,last_changed_date,is_sync,is_sync_list,is_sync_model,promo_v_rule_id,direct_price,min_prod_price,special_price,discount,coupon_id,coupon_amt,times_points,ship_fee,min_buy_n,n_num,n_discount,sort_num) VALUES ('877577','101','1070184108','9891','1','3',NULL,'3',NULL,NULL,NULL,'0','2014:02:14 18:59:57','2014:02:14 18:59:57','0','0','0','0','357.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1')
/*!*/;
# at 283700887
#140214 18:59:58 server id 1136  end_log_pos 283700914         Xid = 8821635534
COMMIT/*!*/;
# at 283700914
#140214 18:59:58 server id 1136  end_log_pos 283700983         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
BEGIN
/*!*/;
# at 283700983
#140214 18:59:58 server id 1136  end_log_pos 283701011         Intvar
SET INSERT_ID=92484220/*!*/;
# at 283701011
#140214 18:59:58 server id 1136  end_log_pos 283701677         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
REPLACE INTO `promo_product` (promotion_id,promotion_type,product_id,shop_id,step,money_compare_type,buy_total_money,num_compare_type,buy_total_num,buy_add_money,limit_buy_num,is_delete,creation_date,last_changed_date,is_sync,is_sync_list,is_sync_model,promo_v_rule_id,direct_price,min_prod_price,special_price,discount,coupon_id,coupon_amt,times_points,ship_fee,min_buy_n,n_num,n_discount,sort_num) VALUES ('877577','101','1070184208','9891','1','3',NULL,'3',NULL,NULL,NULL,'0','2014:02:14 18:59:57','2014:02:14 18:59:57','0','0','0','0','357.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1')
/*!*/;
# at 283701677
#140214 18:59:58 server id 1136  end_log_pos 283701704         Xid = 8821635546
COMMIT/*!*/;
# at 283701704
#140214 18:59:58 server id 1136  end_log_pos 283701773         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
BEGIN
/*!*/;
# at 283701773
#140214 18:59:58 server id 1136  end_log_pos 283701801         Intvar
SET INSERT_ID=92484221/*!*/;
# at 283701801
#140214 18:59:58 server id 1136  end_log_pos 283702467         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
REPLACE INTO `promo_product` (promotion_id,promotion_type,product_id,shop_id,step,money_compare_type,buy_total_money,num_compare_type,buy_total_num,buy_add_money,limit_buy_num,is_delete,creation_date,last_changed_date,is_sync,is_sync_list,is_sync_model,promo_v_rule_id,direct_price,min_prod_price,special_price,discount,coupon_id,coupon_amt,times_points,ship_fee,min_buy_n,n_num,n_discount,sort_num) VALUES ('877577','101','1070184308','9891','1','3',NULL,'3',NULL,NULL,NULL,'0','2014:02:14 18:59:57','2014:02:14 18:59:57','0','0','0','0','357.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1')
/*!*/;
# at 283702467
#140214 18:59:58 server id 1136  end_log_pos 283702494         Xid = 8821635550
COMMIT/*!*/;
# at 283702494
#140214 18:59:58 server id 1136  end_log_pos 283702571         Query        thread_id=201578019        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
SET @@session.time_zone='SYSTEM'/*!*/;
BEGIN
/*!*/;
# at 283702571
# at 283702640
#140214 18:59:58 server id 1136  end_log_pos 283702640         Table_map: `promo`.`adm_sys_op_log` mapped to number 735
#140214 18:59:58 server id 1136  end_log_pos 283702799         Write_rows: table id 735 flags: STMT_END_F

BINLOG '
Lvf9UhNwBAAARQAAAHD16BAAAN8CAAAAAAEABXByb21vAA5hZG1fc3lzX29wX2xvZwAMAwMDAw/8
DAwDAwMDAygAAvAA
Lvf9UhdwBAAAnwAAAA/26BAAAN8CAAAAAAEADP//APC6wyAACWQNAKw5AQDnAwAACzE3Mi4xNy4w
LjI1QQAxMDcwMTg0MDA4LDEwNzAxODQ0MDgsMTA3MDE4NDUwOCwxMDcwMTg0MTA4LDEwNzAxODQy
MDgsMTA3MDE4NDMwOObvT0JREgAA5u9PQlESAAAAAAAAAAAAAAAAAAAAAAAA
'/*!*/;
# at 283702799
#140214 18:59:58 server id 1136  end_log_pos 283702826         Xid = 8821635559
COMMIT/*!*/;
# at 283702826
#140214 18:59:58 server id 1136  end_log_pos 283702895         Query        thread_id=201578020        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
BEGIN
/*!*/;
# at 283702895
#140214 18:59:58 server id 1136  end_log_pos 283703134         Query        thread_id=201578020        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
update shop_promo_request_info set error_code=0,response_content='{\"status\":\"0\",\"data\":{\"promotion_id\":\"877577\"}}',response_time=0,promotion_id=0 where id='12013527'
/*!*/;
# at 283703134
#140214 18:59:58 server id 1136  end_log_pos 283703161         Xid = 8821635578
COMMIT/*!*/;
# at 283703161
#140214 18:59:58 server id 1136  end_log_pos 283703230         Query        thread_id=201577590        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
BEGIN
/*!*/;
# at 283703230
#140214 18:59:58 server id 1136  end_log_pos 283703258         Intvar
SET INSERT_ID=92484204/*!*/;
# at 283703258
#140214 18:59:58 server id 1136  end_log_pos 283712175         Query        thread_id=201577590        exec_time=0        error_code=0
SET TIMESTAMP=1392375598/*!*/;
REPLACE INTO promo_product (promotion_id,promotion_type,product_id,step,shop_id,money_compare_type,buy_total_money,num_compare_type,buy_total_num,buy_add_money,limit_buy_num,is_delete,creation_date,last_changed_date,is_sync,is_sync_list,is_sync_model,promo_v_rule_id,direct_price,min_prod_price,discount,coupon_id,times_points,ship_fee,min_buy_n) VALUES ('876812','102','20590038','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','12.4',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20604369','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20605074','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','17.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20606500','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','11.9',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20607258','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','19.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20607285','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','19.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20607811','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20612745','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20618234','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','16.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20618463','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','11.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20620763','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','22.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20623016','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','16.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20623694','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','16.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20627067','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','12.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20627216','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','12.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20629288','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.9',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20630163','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20638107','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','17.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20642218','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','22.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20645230','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20645232','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','12.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20646830','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','12.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20649205','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.9',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20650039','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','18.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20650042','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20650767','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','15.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20652985','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','240.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20654025','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20654029','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','19.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20655268','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','24.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20658349','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','19.9',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20658736','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','9.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20659527','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','17.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20661735','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','390.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20663092','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','18.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20666308','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','20.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20667125','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.9',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20677037','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','6.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20678200','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','17.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20681342','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20684926','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','14.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20688685','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','20.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20688726','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','11.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20692559','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','13.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20693067','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','30.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20693076','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','17.5',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20693758','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','22.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20693767','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','10.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20693768','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','10.0',NULL,NULL,NULL,NULL,NULL,NULL),('876812','102','20693786','1','0',NULL,NULL,NULL,NULL,NULL,'10000','0','2014-02-14 18:59:56','2014-02-14 18:59:56','0','0','0','0','10.0',NULL,NULL,NULL,NULL,NULL,NULL)
/*!*/;
# at 283712175
#140214 18:59:58 server id 1136  end_log_pos 283712202         Xid = 8821635530
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
chinafenghao

论坛徽章:
8
CU大牛徽章 日期:2013-09-18 15:20:48CU大牛徽章 日期:2013-09-18 15:20:58CU大牛徽章 日期:2013-09-18 15:21:06CU大牛徽章 日期:2013-09-18 15:21:12CU大牛徽章 日期:2013-09-18 15:21:17天秤座 日期:2013-10-30 14:01:03摩羯座 日期:2013-11-29 18:02:31luobin 日期:2016-06-17 17:46:36
2楼 [报告]
发表于 2014-02-27 09:40 |只看该作者
@laizhebujum
如果insert id重复的话，slave应该报错，主键冲突.有这种情况发生吗？
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
jd_chen

论坛徽章:
0
3楼 [报告]
发表于 2014-03-04 09:29 |只看该作者
楼主这个有做读写分离吗？并发量是多少？
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP