Re: Slave Bin Log Question

After you stop the slave and start mysqldump, execute the below on slave db.
show slave status\G.

Note down the Master_Log_File and Exec_Master_Log_Pos. This will be the point from which you need to do the recovery.

regards
anandkl

On 9/25/07, Eric Frazier <efrazier@ic-agency.com> wrote:
>
> Boyd Hemphill wrote:
> > I have executed a strategy for backup where I stop a slave and do a
> mysqldump with --master-data. Both master and slave are 4.1.20
> >
> > My assumption was that the log coordinates in the dump file would
> provide me with the place to replay the log for a point in time recovery.
> >
> > What I learned today however is that it appears the binary log only
> captures statements run directly on the slave. Any SQL run by the SQL
> thread of replication seems only to go in the relay log. This effectively
> renders the --master-data useless for my purpose.
> >
> > So, I have two questions.
> > 1. Can someone verify that the binary log on the slave is not capturing
> SQL from the replication SQL thread.
> >
>
> It sounds like you need --log-slave-updates
>
> http://dev.mysql.com/doc/refman/5.0/en/replication-options.html
> > 2. If the above is really true, what strategies are you using to backup
> InnoDB without InnoDB hot backup?
> >
> > Thanks for your time!
> >
> > Peace
> > Boyd
> >
> >
> >
> >
> >
> >
> >
> > CONFIDENTIALITY NOTICE: This email & attached documents may contain
> confidential information. All information is intended only for the use of
> the named recipient. If you are not the named recipient, you are not
> authorized to read, disclose, copy, distribute or take any action in
> reliance on the information and any action other than immediate delivery to
> the named recipient is strictly prohibited. If you have received this email
> in error, do not read the information and please immediately notify sender
> by telephone to arrange for a return of the original documents. If you are
> the named recipient you are not authorized to reveal any of this information
> to any other unauthorized person. If you did not receive all pages listed or
> if pages are not legible, please immediately notify sender by phone.
> >
> >
> >
> >
> >
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=anandkl@gmail.com
>
>
Received on Tue Sep 25 02:08:02 2007