495884965

參考
Read Replica Replication Error - SQLError: 1062, reason: Error 'Duplicate entry '312626' for key 'PRIMARY'' on query. Default database: 'urstylecomtw_search'. Query: '-- MarsZ: insert into cosme_review ( crv_seq,crv_fid,crv_sid,crv_pseq,crv_memid,crv_member_active_exp,crv_skin,crv_age,crv_evalues,crv_evalues_weighted,crv_comment,crv_comment0,crv_date,crv_situation1,crv_situation2,crv_situation3,crv_situation4,crv_situation5,crv_situation6,crv_situation7,crv_situation8,crv_situation9,crv_situation10,crv_situation11,crv_situation12,crv_poll_1,crv_poll_2,crv_accuse,crv_product_type,crv_product_obtain,crv_used_repeat,crv_poll,crv_ip,pics_count,crv_unverify_num,crv_reply_num,crv_prevreplydate,crv_lastreplydate,review_pageview_final,cosme_reviewcol,crv_product_weather) value( ' 312626 ' , ' 37 ' , ' 5899 ' , ' 13971 ' , ' 49102 ' , ' 61 ' , ' 4 ' , ' 18 ' , ' 4 ' , ' 4 ' , ' ?????????\r\n?????????\r\n\r\n????????\r\n\r\n????????r\n??????????????\r\n??????O??

 主鍵重複，只能跳過這筆的備份

mysql> call mysql.rds_skip_repl_error;
+-------------------------------------------------+
| Message                                            |
+-------------------------------------------------+
| Statement in error has been skipped   |
+-------------------------------------------------+
1 row in set (0.28 sec)

+-----------------------------------+
| Message                            |
+-----------------------------------+
| Slave is running normally    |
+-----------------------------------+
1 row in set (2.28 sec)

Query OK, 0 rows affected (2.34 sec)

mysql>

有些網路上要start slave;
不過在RDS上不用，他會自己啟動服務