MySQL Forums
Forum List  »  Archive Storage Engine

Replication Innodb table to archive table
Posted by: Owen C
Date: May 18, 2011 08:33PM

Is it possible to replicate a simple innodb table with int(11) primary key into a slave database where the same table uses archive engine. I've been trying to do this with 5.1 and auto_increment support but it keeps giving me a duplicate key error and never starts replicating.

CREATE TABLE `transactions` (
`transaction_id` int(11) NOT NULL AUTO_INCREMENT
...
PRIMARY KEY (`transaction_id`),
KEY `idx1_transactions` (`completed_date`)
) ENGINE=InnoDB AUTO_INCREMENT=1862714345 DEFAULT CHARSET=utf8

CREATE TABLE `transactions` (
`transaction_id` int(11) NOT NULL AUTO_INCREMENT
...
PRIMARY KEY (`transaction_id`),
KEY `idx1_transactions` (`completed_date`)
ENGINE=ARCHIVE AUTO_INCREMENT=1862714345 DEFAULT CHARSET=utf8

Thanks,
Owen

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication Innodb table to archive table
6646
May 18, 2011 08:33PM


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.