RE: Sequencial Replication
Hello, I understand that the slave executes the sqls from binlog in sequence, but are there any plans to make it multi-threaded so that it executes multiple sqls from binlog. Thanks Arvind. -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: 08 November 2004 13:02 To: [EMAIL PROTECTED] Subject: Re: Sequencial Replication Hello. MySQL slave receives all updates, but executes them in queue. More about implementation of replication you can read at: http://dev.mysql.com/doc/mysql/en/Replication_Implementation_Details.html Arvind Gangal [EMAIL PROTECTED] wrote: Hi Gurus, As I understand the slave replicates with the master reading one query at a time from the binlog files. And at times the slave comes across a long update query and unless this has completed it will not pick up the next sql even though the other sql is on other table or may be another database. Is there a mechanism of running multiple sql slave threads in order to keep slave in sync to the master to the max. I reckon this would mean remembering multiple positions on the binlog. TIA Arvind Gangal http://www.lastminute.com ** 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 __ __ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- 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]
Sequencial Replication
Hi Gurus, As I understand the slave replicates with the master reading one query at a time from the binlog files. And at times the slave comes across a long update query and unless this has completed it will not pick up the next sql even though the other sql is on other table or may be another database. Is there a mechanism of running multiple sql slave threads in order to keep slave in sync to the master to the max. I reckon this would mean remembering multiple positions on the binlog. TIA Arvind Gangal http://www.lastminute.com ** 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]
RE: Replication / Purge Logs
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]
RE: Error 1236 corrupt binlog on master
I have been using the mysqlbinlog to investigate the 'saturn2-bin.051' binlog file.. I have come to pinpoint the problem position in the binlog, but don't know how i can bypass the corrupted segment. Please help. Thanks Arvind. -Original Message- From: Arvind Gangal [mailto:[EMAIL PROTECTED] Sent: 24 March 2004 21:17 To: '[EMAIL PROTECTED]' Subject: Error 1236 corrupt binlog on master Hello Gurus, Anyone have any ideas as to how I should handle a case of the following error? 040324 21:02:05 Slave I/O thread: connected to master mailto:'[EMAIL PROTECTED]:3306' '[EMAIL PROTECTED]:3306', replication started in log 'saturn2-bin.051' at position 442744915 040324 21:02:05 Error in Log_event::read_log_event(): 'read error', data_len=657471024,event_type=61 040324 21:02:05 Slave SQL thread: I/O error reading event(errno: -1 cur_log-error: 1723122) 040324 21:02:05 Error reading relay log event: Aborting slave SQL thread because of partial event read 040324 21:02:05 Could not parse log event entry, check the master for binlog corruption This may also be a network problem, or just a bug in the master or slave code. 040324 21:02:05 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'satur n2-bin.051' position 442744915 040324 21:02:05 Error reading packet from server: binlog truncated in the middle of event (server_errno=1236) 040324 21:02:05 Got fatal error 1236: 'binlog truncated in the middle of event' from master when reading data from binary log 040324 21:02:05 Slave I/O thread exiting, read up to log 'saturn2-bin.051', position 442744915 Replication seems to have stopped at that point and the slave keeps trying to connect and dies at with that error. I think that the binlog file 'saturn2-bin.051' on master has got courrupted. Is there any way i can start after the point of corruption in the binary file? Thanks, Arvind Arvind Gangal Senior Analyst Programmer address: 4 Buckingham Gate, London SW1E 6JP tel: +44 (0)20 7802 4306 fax: +44 (0)20 7802 9302 mob: 07734938242 email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] internet: http://www.lastminute.com/ http://www.lastminute.com do something lastminute.com This e-mail has been scanned for all viruses by Star Internet. 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 Internet. 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 Internet. 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]
Error 1236 corrupt binlog on master
Hello Gurus, Anyone have any ideas as to how I should handle a case of the following error? 040324 21:02:05 Slave I/O thread: connected to master mailto:'[EMAIL PROTECTED]:3306' '[EMAIL PROTECTED]:3306', replication started in log 'saturn2-bin.051' at position 442744915 040324 21:02:05 Error in Log_event::read_log_event(): 'read error', data_len=657471024,event_type=61 040324 21:02:05 Slave SQL thread: I/O error reading event(errno: -1 cur_log-error: 1723122) 040324 21:02:05 Error reading relay log event: Aborting slave SQL thread because of partial event read 040324 21:02:05 Could not parse log event entry, check the master for binlog corruption This may also be a network problem, or just a bug in the master or slave code. 040324 21:02:05 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'satur n2-bin.051' position 442744915 040324 21:02:05 Error reading packet from server: binlog truncated in the middle of event (server_errno=1236) 040324 21:02:05 Got fatal error 1236: 'binlog truncated in the middle of event' from master when reading data from binary log 040324 21:02:05 Slave I/O thread exiting, read up to log 'saturn2-bin.051', position 442744915 Replication seems to have stopped at that point and the slave keeps trying to connect and dies at with that error. I think that the binlog file 'saturn2-bin.051' on master has got courrupted. Is there any way i can start after the point of corruption in the binary file? Thanks, Arvind Arvind Gangal Senior Analyst Programmer address: 4 Buckingham Gate, London SW1E 6JP tel: +44 (0)20 7802 4306 fax: +44 (0)20 7802 9302 mob: 07734938242 email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] internet: http://www.lastminute.com/ http://www.lastminute.com do something lastminute.com This e-mail has been scanned for all viruses by Star Internet. 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