How would I implement separate databases for reading and writing operations?

Posted by Matt on Stack Overflow See other posts from Stack Overflow or by Matt
Published on 2010-05-26T16:00:53Z Indexed on 2010/05/26 16:51 UTC
Read the original article Hit count: 220

I am interested in implementing an architecture that has two databases one for read operations and the other for writes. I have never implemented something like this and have always built single database, highly normalised systems so I am not quite sure where to begin. I have a few parts to this question.

1. What would be a good resource to find out more about this achitecture?
2. Is it just a question of replicating between two identical schemas, or would your schemas differ depending on the operations, would normalisation vary too?
3. How do you insure that data written to one database is immediately available for reading from the second?


Any further help, tips, resources would be appreciated. Thanks.

© Stack Overflow or respective owner

Related posts about sql

Related posts about database