NoSQL - application featuresAsked by albert enriquez
When is the use of such databases as MongoDB, CouchDB, Redis and some others justified?
Does it make sense to put them instead of the classic mysql, on a site with a weak load?
Are they used in conjunction with mysql, or work separately?
Live very well.
CouchDB views allow you to make the application incredibly flexible, without spending time thinking through complex internal connections, creating composite indexes in the database, etc.
And due to very convenient admin tools (amazing web admin) and master-master replication, in 20 minutes we connect an additional server to the system (100+ requests per second, several gigabytes of data, 2 servers).
just like these are different tables, with the user_id shared key? - matt hempey
1) Justified when you can not accurately determine the structure of the data in advance, or the structure will often change;
2) Has, if your data fits well on the documentary tree-like storage system.
3) I did not encounter the fact that two SQL and NoSQL systems were involved at the same time. But this does not mean that it is impossible. It will just be hard for you to think in two different directions at once.