As I understand it... The SQL must be executed in sequence, otherwise you'll end up with incosistency between master and slave.
an example: If thread 1 is inserting data, and thread 2 is running updates based on the inserted data then you could end up with different results on the slave than on the master. I'm sure someone else could explain it better.. or possibly correctly :) Chris -----Original Message----- From: Arvind Gangal [mailto:[EMAIL PROTECTED] Sent: 10 November 2004 10:28 To: 'Gleb Paharenko'; [EMAIL PROTECTED] Subject: 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.htm l 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
