El Martes, 3 de Marzo de 2009, Juha Heinanen escribió:
Iñaki Baz Castillo writes:
what do you mean by not optimized? If the slave is not active (not running) and one use DRDB just for synchronizing the data, how this could be dangerous?
Simpler than that. Forget DB replication stuff. I just mean that if you have a MySQL 1 with a large MyISAM table and you copy it to other server using "scp/rsync", you will get a non optimized or corrupted table (even if both servers have same CPU, architecture and file system).
I've experimented it by copying with "rsync" a 2 GB long MyISAM table. After restarting the MySQL-2 and run a SQL command to check tables [1], you probably will get a "NOT OPTIMIZED TABLE" and you must to repair it. This is the best case.
inaki,
drdb keeps exact copy of the raw disk image of master on the slave. it has nothing to do with copying of files.
Yes, for sure. But in case of data corruption wouldn't it be very dangerous?