From: Jeff Smelser
Date: April 14 2005 8:15pm
Subject: Re: slave out of sync
List-Archive: http://lists.mysql.com/mysql/182640
Message-Id: <200504141515.35527.tradergt@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart1732512.i9AUi12Fqt";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart1732512.i9AUi12Fqt
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Friday 08 April 2005 10:38 am, Chris Scheller wrote:
> i have replication going between 2 boxes. the master crashed a few days
> ago, and this morning i noticed that the slaves slave thread errored
> out. the binary log and offset had changed on the master and the slave
> couldn't sync up. i got the slave up and running again by changing the
> log file and offset in the slave. but now i am left with out of sync
> data. how do i get these back in sync, and how do i aviod this in the
> future?

Why wouldn't they sync up? If you left off at master-005, pos 123 (lets say=
).=20
It should pick up right there..

If your missing bin log files, then you need to set up the master to not=20
delete logs the slave has not processed yet. This would assure your up to=20
date, once the slave comes back alive..

Or am I missing something?

Jeff

--nextPart1732512.i9AUi12Fqt
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQBCXs9noOk9EvUvEtgRAns1AKClJ2UUqDk73ouyq9FOliGI9j0KGQCfRAKN
Vscpk/WsybZuV7EIchXq01g=
=gAmh
-----END PGP SIGNATURE-----

--nextPart1732512.i9AUi12Fqt--