In news:[EMAIL PROTECTED], Bruno Rodrigues Silva <[EMAIL PROTECTED]> wrote:
> this field (The master is dep= loyed Europe and the slave in Brazil). > The time of fly to replicate the que= ry that leave the master and go > to slave can be more than 1 second. Therefo= re, when this query is > executed in slave server, the timestamp value will b= e different of > the master server one. No, it will not be a different value. The replicated query is preceded by SET TIMESTAMP statement which informs slave of the execution time on the master server. If row-based replication is enabled, the problem does not even exist, because the entire updated row contents is replicated. In either case it does not matter if the slave is one second or one year behind the master server. MySQL replication is asynchronous and therefore the delays between execution times are at the foundation of the functionality. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
