I expect using the Master_log_File should be fine since the slave caches the
sqls in its own Relay_Log_File using the IO Thread.
Arvind Gangal
internet: http://www.lastminute.com
do something lastminute.com
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: 21 October 2004 21:00
To: 'Marvin Wright'; [EMAIL PROTECTED]
Subject: RE: Replication / Purge Logs
No look at Relay_Master_Log_File and Exec_master_log_pos for the position of
that master log file. The Master_Log_File indicates what position the IO
thread is on.
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: Marvin Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 4:01 AM
To: [EMAIL PROTECTED]
Subject: Replication / Purge Logs
Hi,
Just wanted to check something from the documentation.
The recommended procedure for removing the bin logs on the master is
On each slave server, use SHOW SLAVE STATUS to check which log it is
reading.
Obtain a listing of the logs on the master server with SHOW MASTER LOGS.
Determine the earliest log among all the slaves. This is the target log.
If
all the slaves are up to date, this will be the last log on the list.
Make a backup of all the logs you are about to delete. (The step is
optional, but a good idea.) Purge all logs up to but not including the
target log.
When I do a show slave status, I should be looking at the
Master_Log_File field ?
Thanks.
Marvin Wright
Flights Developer
Lastminute.com
[EMAIL PROTECTED]
+44 (0) 207 802 4543
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**
__
__ This e-mail has been scanned for all viruses by Star. The service
is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
__
__
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
