Sonia Hamilton wrote: > I'm working with MySQL5 replication at the moment. All is working fine > except for one problem - there's a large table on the Master that I > don't want to replicate (bandwidth), and the Master is running MySQL4.
Is running different versions of MySQL supported by replication? I'd be surprised if its bug free. MySQL replication is statement based, so unless the big table is seeing a lot of updates, you should be ok with something like: - bootstrap the replica either without the big table, or immediately dropping the big table depending on your bootstrap setup - change the storage engine for the big table to blackhole - profit! In other words, as long as a table with the same name exists on the replica, there is no strong requirement for it to use the same storage engine, or even have the same table schema [1]. Mikal 1: But you'll get errors on the replica if the schemas are incompatible. -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
