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