mysqld - master to slave replication using rsync innodb, sequence number issues
- by Luis
I've read several of the related topics posted here, but I have not been able to avoid this innodb error.
The steps I've taken to replicate data from a Slackware server - 5.5.27-log (S) to a FreeBSD slave - 5.5.21-log (F) were these:
(S) flush tables with read lock;
(S) in another terminal show master status;
(S) stop mysqld via command line in third terminal;
(F) while both servers are stopped, rsync mysql datadir from (S), excluding master.info, mysql-bin and relay-* files;
(F) start mysqld (skip-slave)
121018 12:03:29 InnoDB: Error: page 7 log sequence number
456388912904 InnoDB: is in the future! Current system log sequence
number 453905468629. InnoDB: Your database may be corrupt or you may
have copied the InnoDB InnoDB: tablespace but not the InnoDB log
files. See InnoDB:
http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: for more information.
This kind of error happens for a lot of tables.
I know I can use dump, but the database is large, ca. 70GB and the systems are slow (old), so would like to get this replication to work with data transfer.
What should I try to solve this issue?