Fastest way to move Innodb database from one server to another
I understand I can use mysqldump or xtrabackup to move InnoDB from one db to another.
Considering I am okay with server down time, are there better way to move InnoDB database?
I have tried copying all "ib_*" files and seems does not work. Are there anything I've missed?
For anyone wondering, Copying the entire mysql data root (in my case) /var/lib/mysql AFTER shutting down mysqld worked perfectly to migrate data to another system.
Otherwise if you need replication the cluster solutions are more appropriate and faster than DRBD