From: Reindl Harald
Date: April 20 2012 12:09pm
Subject: Re: Maser-Slave replication is playing up
List-Archive: http://lists.mysql.com/mysql/227219
Message-Id: <4F9151FD.20104@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigEA3C4EE73D7C203C9F3D4685"

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



Am 20.04.2012 13:44, schrieb nixofortune:
> Thanks,
> So the actions should be:
> 1. Stop slaves
> 2. On Slaves: SET GLOBAL binlog_format=3DMIXED
> 3. Start slaves.

not "SET GLOBAL", put things you want in my.cnf
you want them also get active after restart :-)

> What is "restart the replication from scratch with a binary ident copy =
(rsync)"
> Is it to use rsync to rsync mysql data on masters and slaves? and than =
run chnge the master to .... to start from

yes, that's the way i init replications sicne years

* stop slave
* "hot rsync from the running master
* stop master
* remove binlog files
* rsync again
* start master
* start slave
* "change master to...."

this way has several benefits

* if you are using de-duplication backups it may save space
* less possible errors because a binary ident start

the downtime on the master can be reduced to a minimum if
you are doing the rsync on a local drive on the
master-server, starting the master and after that you
have all time you need to rsync the copy to the slave
while the master happily writes new changes in his binlog
and after starting the salve it will fetch the changes

usually i have a shell-script for all actions
on the master machines which needs param "really"
or it would stop after the hot rsync and not stop
mysqld



--------------enigEA3C4EE73D7C203C9F3D4685
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://enigmail.mozdev.org/

iEYEARECAAYFAk+RUf0ACgkQhmBjz394AnmdhgCgmS6tuRc+LcbvNRTlTwuZWM9d
6GsAn264EWP/FtepS+IsIra+nz7xmUjv
=WIqF
-----END PGP SIGNATURE-----

--------------enigEA3C4EE73D7C203C9F3D4685--