Re: Replication from InnoDB - MyISAM

2002-07-15 Thread Heikki Tuuri
Philip, - Original Message - From: Philip Molter [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, July 15, 2002 5:55 PM Subject: Replication from InnoDB - MyISAM I have a 3.23.51 server with InnoDB tables. I want to replicate one of the databases over to some

RE: Replication from InnoDB - MyISAM

2002-07-15 Thread Nilesh Shah
How does transaction works in this scenario?. Is rollbacked transaction written into bin-log files?. Nilesh -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 1:30 PM To: Philip Molter; [EMAIL PROTECTED] Subject: Re: Replication from InnoDB

Re: Replication from InnoDB - MyISAM

2002-07-15 Thread Philip Molter
On Mon, Jul 15, 2002 at 02:40:14PM -0400, Nilesh Shah wrote: : How does transaction works in this scenario?. Is rollbacked transaction : written into bin-log files?. To quote Heikki from below: MySQL only writes committed transactions to the binlog, and consequently only replicates

RE: Replication from InnoDB - MyISAM

2002-07-15 Thread Nilesh Shah
I am sorry. I should have paid more attention to Heikki email. Nilesh -Original Message- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:43 PM To: Nilesh Shah Cc: [EMAIL PROTECTED] Subject: Re: Replication from InnoDB - MyISAM On Mon, Jul 15, 2002 at 02:40