Answer the question
In order to leave comments, you need to log in
MongoDB as a second DBMS?
There is a code autotesting system, now only PostgreSQL is used to store everything, is it worth moving the test logs (up to 100mb) field on MongoDB to a separate local server? Now the database weighs about 40gb, about (99% of the weight is text fields with test logs, some reach 100mb in size)
I see the following advantages here:
1) non-relational data is stored in MongoDB
2) The main PostgreSQL database will be freed from 99% of heavy logs.
3) The database backup will be faster.
4) Is it possible to increase productivity?
Answer the question
In order to leave comments, you need to log in
the size of the base is for children, it makes no sense to bother at all.
backup is not particularly important quickly slowly, if only it was.
I don’t understand at all what kind of productivity you have there, apparently mythical.
And what for in general a log to store in a DB? Push them into HDFS/ElasticSearch+Kibana. In general, more destined for this place.
docs.mongodb.org/master/reference/limits
Document size limit 16mb. You can get confused with partitioning, but why? It's easier to make a separate postgres instance for logs - I think you already know how to cook it, unlike mongi, and it's less redoing.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question