If I have amast/salve pair where the slave is replicating from the master then do the table types have to be the same ?
Specifically can I have a myisam table on the master and replicate to a bdb table on the slave ? The reasoning behind this is to try and find a *fast* was to convert a MYISAM table to a BDB table having the database down for the minimum amount of time. Idea so far is this: on current database machine do a ''mysqldump' and then enable logging. Load onto new database machine with table types set of BDB. Make new db machine replicate from old until it has caught up with the new data which was inserted into the master whilst the load was happening. When both are in sync then take them down and point allupdating clients to the new database machine. Any comments ? Converting the tables "in situ" is painfully slow - a couple of days I suspect. -pcf. --------------------------------------------------------------------- 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
