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: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 committed transactions. : ----- 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 3.23.49 servers with MyISAM tables. : > The tables do have some auto-increment columns. I expect that only : > valid data is going to be written to the binlog, so there shouldn't : > be an issue with invalid data appearing in my MyISAM tables. Can : > I expect any problems with this setup? : : MySQL only writes committed transactions to the binlog, and consequently : only replicates committed transactions. : : Fortunately the MySQL replication puts commands : : SET INSERT_ID = ... : : to the binlog to replicate inserts to tables with auto-increment : columns. : Thus small differences in auto-increment algorithms in different tables : types do not cause problems in replication. : : Thus replication InnoDB table -> MyISAM table should always work without : problems. : : > sql, query, stupid filter (perhaps the filter can be expanded to : > look for common MySQL words, like 'MyISAM, InnoDB, 3.23.x etc.'). : > : > * Philip Molter : > * Texas.net Internet : > * http://www.texas.net/ : > * [EMAIL PROTECTED] : : Best regards, : : Heikki : Innobase Oy * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
