Re: Limitations of InnoDB about REPLICATION
- Original Message - From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 12:31 PM Subject: Re[2]: Limitations of InnoDB about REPLICATION > Dobrý den, > quinta-feira, 23 de janeiro de 2003, 08:28:43, napsal jste: > > HT> Dyego, ... > >> * THE LOAD TABLE FROM MASTER DOES NOT WORK ON INNODB TABLES > > HT> true. > > >> * THE TABLES ARE LOADED AUTOMATICALLY ON SET REPLICATION > > HT> Sorry, I do not understand? Do you mean that when you set up a new slave, > HT> you make a cold or a hot backup of the InnoDB tablespace and log files and > HT> .frm files, and use them to set up the new slave? That is the normal > HT> procedure to set up a new slave. The command LOAD TABLE FROM MASTER is > HT> awkward anyway if you have lots of tables. ... > The Command LOAD TABLE FROM MASTER work on slave with InnoDB tables ? > ( >= 4.0.9 ) sorry, no. The workarounds are: A. 1) convert the table to MyISAM in the master, 2) use then LOAD TABLE FROM MASTER in the slave, 3) convert back to InnoDB in the master. B. Or simply dump the table in the master and import the dumpfile to the slave. > Tanks ;) > > sql,query > > - > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento You are welcome :), Heikki - 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
Re: Limitations of InnoDB about REPLICATION
Dyego, - Original Message - From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 12:13 PM Subject: Limitations of InnoDB about REPLICATION > Hello guy ! > > The limitations about InnoDB on replication is present in >= 4.0.9 release > ? > > * THE LOAD TABLE FROM MASTER DOES NOT WORK ON INNODB TABLES true. > * THE TABLES ARE LOADED AUTOMATICALLY ON SET REPLICATION Sorry, I do not understand? Do you mean that when you set up a new slave, you make a cold or a hot backup of the InnoDB tablespace and log files and .frm files, and use them to set up the new slave? That is the normal procedure to set up a new slave. The command LOAD TABLE FROM MASTER is awkward anyway if you have lots of tables. > is true this limitations on >= 4.0.9 ? > > > sql,query > > - > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento Regards, Heikki > - > E S C R I B A I N F O R M A T I C A > - > The only stupid question is the unasked one (somewhere in Linux's HowTo) > Linux registred user : #230601 > -- > $ look into "my eyes" Phone : +55 041 296-2311 r.112 > look: cannot open my eyes Fax : +55 041 296-6640 > - >Reply: [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
Limitations of InnoDB about REPLICATION
Hello guy ! The limitations about InnoDB on replication is present in >= 4.0.9 release ? * THE LOAD TABLE FROM MASTER DOES NOT WORK ON INNODB TABLES * THE TABLES ARE LOADED AUTOMATICALLY ON SET REPLICATION is true this limitations on >= 4.0.9 ? sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into "my eyes" Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [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
