T
T
th3mis2015-08-26 15:01:23
Django
th3mis, 2015-08-26 15:01:23

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

3 answer(s)
P
Puma Thailand, 2015-08-26
@opium

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.

P
protven, 2015-08-26
@protven

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.

A
Alexander Melekhovets, 2015-08-26
@Blast

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 question

Ask a Question

731 491 924 answers to any question