Re: Mysql replication
Posted by:
Aftab Khan
Date: August 27, 2012 08:32AM
You should add Primary key to cluster_master i.e.
ALTER TABLE cluster_master ADD `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (id);
row based replication requires
(RBR + no PK + update NULL value --> slave break with error HA_ERR_END_OF_FILE)
http://bugs.mysql.com/bug.php?id=60091
Subject
Views
Written By
Posted
5153
August 21, 2012 04:07AM
2205
August 22, 2012 09:51PM
5299
August 24, 2012 12:14AM
3069
August 24, 2012 02:27AM
2726
August 26, 2012 06:20PM
Re: Mysql replication
2775
August 27, 2012 08:32AM
2406
August 27, 2012 05:55PM
2067
August 24, 2012 04:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.