From: Reindl Harald
Date: October 16 2012 7:20pm
Subject: Re: Odd Behavior During Replication Start-Up
List-Archive: http://lists.mysql.com/mysql/228410
Message-Id: <507DB396.5030601@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigC0045F7BC53C928879161CD4"

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



Am 16.10.2012 20:18, schrieb Tim Gustafson:
> InnoDB: The log sequence number in ibdata files does not match
> InnoDB: the log sequence number in the ib_logfiles!
> 121016 10:40:20  InnoDB: Database was not shut down normally!

> So, I went back to the master server, backed up the "foo" database and
> dropped and re-created it, and then restored the data, and repeated
> the whole process, but then I just get the same error for another pair
> of database names.  I did this three times before giving up.  No data
> appears to be corrupted at all on the master server.

you can not simply copy a single database in this state
innodb is much more complex like myisam

* rsync on the master while it runs LOCAL
* stop the master
* rsync a second time to get a fast diff-sync
* stop the salve
* rsync the master-backup to the slave
* start replication

IMHO this is the only fast, safe and consistent way to
start a replication - and yes FS snapshots are REALLY
bad for such things

i am doing the above since many years now

BTW: you should take care that slave and master have the SAME mysql-versi=
on!



--------------enigC0045F7BC53C928879161CD4
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.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlB9s5cACgkQhmBjz394AnnknACeNQjFPWPExrriI7EaFffxFrwl
i5cAnjFxpjj+5UWfiE7m6He3gQy62j3f
=lCkH
-----END PGP SIGNATURE-----

--------------enigC0045F7BC53C928879161CD4--