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
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.