Navigation
Who's online
There are currently 0 users and 190 guests online.
User login
Syndicate
Separation into read/write only databases
Sat, 08/09/2008 - 05:00 — mofey
At least in the articles on Plenty of Fish and Slashdot it was mentioned that one can achieve higher performance by creating read-only and write-only databases where possible.
I have read the comments and tried unsuccessfully to find more information on the net about this. I still do not understand the concept. Can someone explain it in more detail, as well as recommend resources for further investigation? (Are there books written specifically about this technique?) I think it is a very important issue, because databases are oftentimes the bottleneck.
- 507 reads
Re: Separation into read/write only databases
It' similar to building an OLAP database from an OLTP database. The write database is the database of record. All your transactions go through the write database. It's optimized to be fast for writes. It has minimal indexing, for example, yet maintains referential integrity and other data constraints. Data from the write database flows into the read database. It flows because your application writes the data in two places, from a cron job that moves data over, database replication mechanism, or some other magic. Applications direct all read queries to the read databases. Try something like MySQL Proxy. The read database can be denormalized and fully indexed to make queries faster.
Re: Separation into read/write only databases
Thank you Todd! Do you know books that talk about it?
Post new comment