From: Reindl Harald
Date: February 3 2013 4:07pm
Subject: Re: log sequence number InnoDB: is in the future!?
List-Archive: http://lists.mysql.com/mysql/228906
Message-Id: <510E8B27.3040709@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="----enig2RQTRGTRECFLQMXHQUKBA"

------enig2RQTRGTRECFLQMXHQUKBA
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable



Am 03.02.2013 15:30, schrieb Larry Martell:
> We also ended up dropping the database and restoring from dumps.
> However all recent dumps ended up having a similar corruption and we
> were still getting the same errors. We had to go back to an October
> dump before it would come up cleanly. And our db is fairly large, and
> it takes around 4 hours to load a dump. We were working on this Friday
> from 8:30 AM until 4AM Saturday before we got it going. And now we're
> trying to recall all the alters we did since then, and reload all the
> data since then, most of which is in files we can import. The only
> thing we don't have is the manual updates done. All in all a total
> disaster and something that will make us rethink our procedures.
> Perhaps we'll look at replication, although I don't know if that would
> have helped in this case

replication is the way to go

> "We had to go back to an October dump"

well with a replication savle you have

a) good changes that not both are corrupt
b) can stop the salve for backup it and skip useless dumps
c) restore a backup of a slave with rsync is MUCH faster




------enig2RQTRGTRECFLQMXHQUKBA
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.13 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlEOiycACgkQhmBjz394Anm0zgCeLQQ43q2eadQR5Ow0Es855rmD
DBkAn1SaQnwH0kPdt7mN1BZKMtEg7i6W
=mzaB
-----END PGP SIGNATURE-----

------enig2RQTRGTRECFLQMXHQUKBA--