Update:Remora Database Replication: Difference between revisions

Update:Remora Database Replication (view source)

624 bytes added , 21 February 2007

no edit summary

334

edits

@@ Line 11: / Line 11: @@
 }
 </pre>
+** For query, use preg_match to detect a write query type(insert, update, replace) and do the right thing.
+* Tests
+** Tests need to account for replication lag...
+*** How long to delay? Some way to detect it?
+** We need to test everything that writes to the db, some things already have tests for this that need to be modified to deal with replication lag.
+** Writes to the /test db/ won't replicate to the real db, obviously, so we probably need to have a replicated real db and a replicated test db.
+*** For this to work, we need to make the site read from the test db when called by the web tests, user agent detection?