Re: active-active DB

Mohit Anchlia said: > Then what's the difference between HDR (writable) vs ER. I think ER is > more > complex to setup and debug than HDR. Redirected writes perform all the "donkey work" on the secondary but then ship the final version of the page to the primary to do the actual write (provided the timestamps are OK). ER is true "update anywhere". It is only more difficult to set up and debug ER if you go for a complex setup. A simple setup "update-anywhere, replicate everything" can be done in the following steps: 1. Make sure every table has a primary key. 2. Add CRCOLS to every table. 3. Define each node (one command per server). 4. Create a template (one command). 5. Realize the template (one command). So it is slightly more complex to set up, but not significantly so. -- Bye now, Obnoxio http://obotheclown.blogspot.com/