public marks

PUBLIC MARKS with tags delay & php

25 August 2007 11:30

Database replication lag | Dries Buytaert

by Xavier Lacot
Consider the following pseudo-code: $nid = node_save($data); $node = node_load($nid); Because node_save() executes a mutator query (an INSERT or UPDATE statement) is has to be executed on the master, so the master can propagate the changes to the slaves. Because node_load() uses a read-only query, it can go to the master or any of the available slaves. Because of the lack of synchronization between master and slaves, there is one obvious caveat: when we execute node_load() the slaves might not have been updated.

PUBLIC TAGS related to tag delay

2.0 +   apprentice +   apprenticebid +   apprenticeship +   auction +   bid +   blog +   blogger +   blogging +   demand +   experience +   fosbn +   freedom +   laszlo +   list +   network +   of +   open +   openlaszlo +   sell +   speech +   web +   web2 +   web2.0 +   win +  

Active users

Xavier Lacot
last mark : 25/08/2007 11:38