Update:Remora Database Replication: Difference between revisions

no edit summary
No edit summary
No edit summary
 
Line 11: Line 11:
}
}
</pre>
</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?
334

edits