hi all
i did done some homework about the different between rdbms and nosql and the difference between postgressql and mongodb but i am still not sure which database to use for logs storing purpose and other factors e.g. HA and ease of setup/maintaining
hope to hear some advice from the folks here
-
i am on oracle RAC with dataguard on
-
the IT team is treating the database as application log dump for the reason that it is easier to search for logs
-
the database is growing very big and bulky due to all these logs which affect the standby sync
-
these logs are not mission critical and do not require complete join / relation
-
i am not able to stop them from logging and i need to provide an alternative database to store the logs
-
we have explore other options such as ELK but please just treat it as logging to database is still preferred
=================================================
-
any idea on what database should i use ? will nosql database do better here ? since there are alot of different kind of application logs and they can be shard by country / app etc
-
is mongo easier to setup then postgres ? does mongo generated less redo ? i still need the HA but it is not as important
-
should i just use any rdbms for this log storing purpose ? or nosql database does really have an edge here ?
Thank you