From: Reindl Harald
Date: February 16 2011 11:38am
Subject: Re: Replication issue
List-Archive: http://lists.mysql.com/mysql/224429
Message-Id: <4D5BB740.80908@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig02B1F5C518F548AF12F5F8C3"

--------------enig02B1F5C518F548AF12F5F8C3
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Am 16.02.2011 12:33, schrieb Carl:
> The max_allowed_packet setting is the same on both.

the question is how large the setting is
we have 200M on all machines

> I have tried restarting the slave... didn't work

after replication errors you should every time

* stop the slave
* "hot" rsync the dadadir on the master
* stop the master
* "cold" rsync to get last changes
* remove binlog files in datadir und backup
* start the master
* rsync the backup to the slave
* start the slave
* restart replication

this way the downtime of the master is very short because
the second rsync must only copy changes since the first run


--------------enig02B1F5C518F548AF12F5F8C3
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.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk1bt0AACgkQhmBjz394AnkzvQCeOMx1omQlw3cc61kBHo1Sv+dn
QYQAn213tge1B0h1cxAwIDC/Z7qUeCdV
=B/uW
-----END PGP SIGNATURE-----

--------------enig02B1F5C518F548AF12F5F8C3--