List:General Discussion« Previous MessageNext Message »
From:MaFai Date:July 6 2005 1:41am
Subject:mysql repl
View as plain text  
Dear mysql@stripped:

Our db is the innodb eng.
We have no hot backup tools to dump the data.

If lock the table by the following cmd before we dump the data
FLUSH TABLES WITH READ LOCK;

It seems ok,it can lock the innodb too.
But the replication would be crushed ,even it start up smoothly,due to the duplicated
entry.

Do any one try to lock innodb tables to make the snap shot?
Since shutdown the master db would take great effect,we don't hope so.

Best regards.
 
                MaFai
                zh-ma@stripped
                2005-07-06
                34955929



 

Thread
mysql replMaFai6 Jul
  • Re: mysql replGleb Paharenko6 Jul