List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:April 20 2012 12:09pm
Subject:Re: Maser-Slave replication is playing up
View as plain text  

Am 20.04.2012 13:44, schrieb nixofortune:
> Thanks,
> So the actions should be:
> 1. Stop slaves
> 2. On Slaves: SET GLOBAL binlog_format=MIXED
> 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



Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
Maser-Slave replication is playing upnixofortune20 Apr
  • Re: Maser-Slave replication is playing upReindl Harald20 Apr
    • Re: Maser-Slave replication is playing upnixofortune20 Apr
      • Re: Maser-Slave replication is playing upshawn green20 Apr
      • Re: Maser-Slave replication is playing upReindl Harald20 Apr
        • Re: Maser-Slave replication is playing upnixofortune20 Apr
  • Re: Maser-Slave replication is playing upshawn green20 Apr
    • Re: Maser-Slave replication is playing upnixofortune20 Apr
    • Re: Maser-Slave replication is playing upnixofortune20 Apr
      • Re: Maser-Slave replication is playing upshawn green20 Apr