On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote: > If you want to set it all up, just make sure you start an update-log on your > master server and connect the slave to it.. then if you're running mysql 4.0 > or higher just issue the command "LOAD DATA FROM MASTER;" and the slave will > become up-to-date. After that it will continue to read the updatelog and > manage on its own.
"LOAD DATA FROM MASTER" doesn't work with InnoDB. Since he's using two different table handlers, mysqldump is probably the best way to bring the slave up to date. Has anyone looked into using MySQL Cluster? Information on NDB is scarce on mysql.com. xn
