Replication question

[Rodolfo Baselli]

Hi list
I'm configuring our new db server, and the choice was MySQL.
Now, I think we are going to use InnoDB tables and replication.
Since replication is done after a binary log, is querying the slave database(s) really the same than querying the master? or, is transaction consistency guaranteed across the replication cluster on a time basis?
I mean, if a transaction takes place on the master it will take a short but not null time to replicate on the slaves, so the same query at the same time on the master and the slaves would return different data - am I right?
Again, my big and time-consuming query takes a snapshot of the database, meanwhile another one modifies the data and commits, log spreads, and a third one does the same query on a slave after some seconds (the first query has not finished yet): the two results should be different - or not?
Got a few concepts, but rather confused :-)

Thank you

Bye :-)

--
Rodolfo Baselli
(Italy)



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php