Hello colleagues, I want to set up a replication schema on MySQL (ISAM tables). I then have to align the databases before starting the replication.
I would like to NOT stop the database to do the alignment because the application needs a lot of time to startup (1 hour) and I may have to start and stop the replication several times during the application life (don't care about binary logs, they are always enabled!)
My database is composed by several "pieces" ...
What is the best way to perform the alignment including the costs Vs. benefits?
* tar cvf of the datafiles? Is it absolutely needed to shutdown the database?
* mysqlhotcopy? can I keep ON the application?
* mysqldump? How can I to lock all the database structures? what's about the application
transactions? are they frozen on the COMMIT until the tables are unlocked?
Thanks Enrico
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
