Questions tagged [mongodb]
All versions of MongoDB - a scalable, high-performance, open source, document-oriented database.
1
vote
1answer
151 views
MongoDB sharding by monotonic id with zones for archiving
Situation:
I have an ever-growing collection of documents which do have monotonically increasing unique id.
All queries are direct lookup for documents with specified _id (no range queries nor ...
0
votes
1answer
16 views
Mongodb cluster issue
I would like to put in place a cluster with 2 instances of Graylog. Ideally, one of them will receive logs from servers in the cloud and the other one on premise will receive logs from servers that ...
1
vote
0answers
94 views
It is possible to take incremental backup in mongoDB Shard cluster? without opsmanager
Shard MongoDB Cluster:
3-router
3-config
2-shard (3-replica's per shard)
We are tring to take incremental backup for every one hour. We gone through few google links, but no luck. As per our above ...
0
votes
0answers
26 views
Issue in accessing the mongodb data in Tableau
I am using the mongosqld to view the mongodb data in Tableau
mongodb Bi COnnector 2.5 is used
Mongo Document Schema for Events Collection:
"_id" : ObjectId("57f824abe3301b1984sdsds"),
"information" ...
0
votes
0answers
32 views
Restore data with Ops Manager
I'm currently using MongoDB, version and Ops manager is latest version with RHEL 7 OS.
As per my understanding, Ops manager takes base snapshot every 24 hours or based on our schedule which can be 6, ...
1
vote
1answer
42 views
MongoDB Shard distribution issue
I am facing an issue in the shard distribution.
MongoDB Version: 3.0.15
I have a collection that is sharded. I have two shards.
Output of db.getCollection('event').stats()
{
"sharded" : true,
"...
1
vote
0answers
26 views
ok design for mongodb - daily data?
So I don't have experience with Mongodb besides a few tutorials. Currently a website is set up using Mongodb for user access and for some other data. Because of this, I'd like to stick with Mongodb ...
2
votes
1answer
30 views
MongoDB Embeded Index
we have a collection in below format:
{
"_id" : {
"a" : 8,
"b" : ObjectId("5b23aa9e24826b82a2553ce7")
},
"field1" : "value1",
"field2" : "value2",
"field3" : "...
1
vote
1answer
229 views
MongoDB Using String-Type Shard Key for Zone Ranges
Mongo lets any field type be used to set ranges for Shard Zones, but doesn't specify how analyses are conducted.
My goal is to point queries and writes at the exact right server, WITHOUT using a ...
1
vote
0answers
96 views
MongoDB write locks on insert
Why would an insert into a MongoDB 3.4 collection require global write locks? I'm creating a copy of a large collection in a new replica set (via mongodump/restore) and I'm finding that some inserts ...
1
vote
0answers
43 views
MongoDB: db.collection.watch on sharded clusters
I'm interested in db.collection.watch feature on MongoDB sharded clusters.
Did you have any problems with it in the production environment?
To guarantee total ordering of changes, for each change ...
0
votes
1answer
99 views
Transfer Data between MySQL and MongoDB Databases [closed]
My latest IT project has me working with MongoDB for the first time. While I have a bit (very little) experience with NoSQL, I have always mostly worked with MySQL using Workbench.
I need to migrate ...
0
votes
1answer
42 views
Ops Manager clarification
I am quite new to MongoDB ops manager backup process
I have understood basic ops Manager setup from the document https://docs.opsmanager.mongodb.com/v4.0/tutorial/install-basic-deployment/
My doubt ...
0
votes
1answer
21 views
MongoDb use indexes partially
Can mongodb take advantage of an index partially? I'm not talking about using a "partial index" ( https://docs.mongodb.com/manual/core/index-partial/ ), but using a regular index partially.
For ...
0
votes
0answers
114 views
Array as input for query in MongoDB (node.js)
I am stuck for 2 days with this issue. Any help will be much appreciated.
I've got the following array of objects (more than 500 objects):
var rentals = [{
deviceId: 1,
start_date: ISODate("...
0
votes
1answer
27 views
Write concern in mongodb
All,
Lets say devoper sets the write concern as Majority in MongoDB
As a DBA can i have the access to change the write concern of whole cluster or only the developers has the rights to do through ...
3
votes
1answer
213 views
MongoDB Connectivity Issue
From last few days, I am facing connectivity issues with MongoDB Replica Sets deployed in google cloud. Interesting fact is these issues are appeared at Development machines and not on the production. ...
0
votes
0answers
179 views
MongoDB - Azure Cosmos DB replication?
What would be the easiest way to replicate an on premises MongoDB to an Azure Cosmos DB? The ideal scenario for me should be a transactional replication.
0
votes
1answer
2k views
node is not in primary or recovering state
My config file is:
systemLog:
destination: file
logAppend: true
path: c:\data\log\mongod.log
storage:
dbPath: c:\data\db
journal:
enabled: true
replication:
replSetName:...
1
vote
2answers
722 views
MongoDB show duplicate key is null?
MongoDB version 3.6
I got the duplicate key message when I executed this. What's the actual problem?
mongos> db.setup.findAndModify({
... query : {"_id" : ObjectId("5b3c7abbea95705803084cad")},
.....
1
vote
1answer
36 views
MongoDB delayed member replication mechanism
We are considering implementing a delayed member in our MongoDB replicaset to protect us from human error based data corruption, e.g. someone accidentally deletes some data.
How does a delayed ...
1
vote
1answer
31 views
MongoDB as a log storage. Choosing shard key
I'm designing a log storage system based on MongoDB.
I want to shard a log collection to increase ingestion and capacity (distribute writes to several machines) while allow fast search.
I should be ...
0
votes
1answer
222 views
How does Pymongo connection work?
I created a small speed test
from misc.Database import Database
import time
db = Database.getDb()
def main():
test_db = db.test_db.find({})
return "done"
if __name__ == '__main__':
...
0
votes
0answers
20 views
Partially rotating MongoDB collection efficiency
I have a MongoDB collection with approximately 20M objects in it. Nightly, I am deleting (2 + incomplete portion) months of data and replacing them with an import from CSV that uses PyMongo 3.0....
1
vote
1answer
163 views
How to avoid warning with file system cache in mongodb?
OS Windows 10 x64. Version of MongoDB 3.6.5
When I'm starting mongo process, I'm always getting:
MongoDB shell version v3.6.5 connecting to: mongodb://127.0.0.1:27017/
MongoDB server version: 3.6.5 ...
1
vote
1answer
173 views
Mongodump Backup Resume
My database size is approx 1.5 TB and I have approx 2TB free on backup mount point. But after 10 hours my backup fail due to lack of storage and its just 60% complete. Is their any why through which i ...
0
votes
1answer
168 views
How to connect via config file in mongodb
In config file I have:
systemLog:
destination: file
logAppend: true
path: c:\data\log\mongod.log
storage:
dbPath: c:\data\db
journal:
...
1
vote
1answer
120 views
MongoDB - Killed when database disk is full [closed]
I'm using MongoDB 3.6.5 (already tested on 3.2 / 3.4) and i have enabled "directoryPerDB" in /etc/mongo.conf.
#mongod.conf
storage:
dbPath: /var/lib/mongodb
journal:
enabled: true
...
1
vote
1answer
96 views
mongodump: fact.bson: input/output error
We are trying to export 1.5TB database into mongodb. But its fail after 100gb and giving us below error. As we notice root mount point got 100% space. We are using below command:
mongodump -u admin -...
0
votes
1answer
210 views
MongoDB: replication headroom gone below 1 days (avg/sec)
getting alert that "Replication Headroom has gone below 1 days(avg/sec)".
when checked OPS manager for replication lag, max lag I can see that is of 16 seconds. Oplog size has been set to 50gigs. ...
0
votes
0answers
23 views
MongoDB - To nest or not to nest
It's a question that has been asked a lot but I haven't found a clear answer to this question:
Given the type of queries I expect, is there a design that will improve (read) performance?
I have 2 ...
0
votes
0answers
29 views
MongoDB start script - how does it choose configuration file?
I'm new to the MongoDB. I have the MongoDB server version 3.6.5 installed on my Xubuntu 14.04 VM, and I see it running (look at configuration file name):
ps -ef|grep mongodb
mongodb 79884 1 0 ...
2
votes
1answer
128 views
Single collection with a key vs multiple collections
I am designing the DB for a project, where, I am sure that I would not be querying for data belonging to multiple values of a key x at the same time. All queries will be for sure for a given value of ...
0
votes
1answer
90 views
Mongodb upgrade from 3.0 to 3.2
I have upgraded the mongodb from 3.0.15 to 3.2
mongodb3.0.15 Configuration :
Three shards
Three config servers
mongodb3.2 Configuration :
Three shards
Three config servers
No replica sets
I ...
0
votes
1answer
38 views
Replica model in Cassandra vs Mongo?
Say in Mongo we have one primary and two replica node(simple replica no sharding). Read and write request will be handled only primary node
and replica will just backup the data in case of failover.
...
0
votes
1answer
233 views
Error in creating shard cluster mongodb
I have followed the mongodb documentation to create a sharded cluster. I have created a config server replica set and shard replica set with 3 members each.Following is the procedure I followed as per ...
2
votes
1answer
246 views
Mongo CP, Cassandra AP?
I have read lot of articles on net but still confused why Mongo CP, Cassandra AP, RDBMS CA ?
Will explain my understanding and query along with that .
Mongo
Consider a scenario where I have ...
1
vote
1answer
469 views
Upgrading from MongoDB 2.4 to 3.6 [closed]
I wish to upgrade my mongo from 2.4 to 3.6. As i see in the official documents, and googling, that i need to do an upgrade for each 0.2 version, meaning doing 6 (!!!) upgrades in order to upgrade my ...
2
votes
1answer
356 views
MongoDB crashes with out-of-memory or is being killed by oom-killer
A two shards MongoDB database regularly crashes with out-of-memory error or is being killed by the oom-killer. The system runs on GCE Debian 9.4 with MongoDB v3.6.5, WiredTiger storage engine and ...
0
votes
0answers
28 views
Retrieving Mongo Databases without connecting directly to an instance
Hope someone can help.
I have two MongoDB 3.6 installation set up on Windows Server and Ubuntu. Both installations (Windows and Ubuntu) have 5 databases each including the default databases.
I've ...
1
vote
1answer
22 views
mongodb disable write access (while db migration)
I want to migrate from one cluster to another. So I'm goint go make a backup with mongodump and mongorestore. Db is not so big, so I would like to disable writes on source db before the start to ...
0
votes
1answer
543 views
Mongodb rs.add() new member in STARTUP state
I have been running a shell script that starts mongod instances on different machines, initializing them (the first machines) and adding them to a replica set (the others). The following is a summary ...
1
vote
0answers
13 views
How can I dump the data which has been added recently?
On a daily basis I will download the data from mongodb and make a backup. I use the command
mongodump -h $MONGODB_SERVICE_HOST -o /opp/rot/llc/ttc -u 'admin' \
-p $MONGODB_ADMIN_PASSWORD
So in ...
1
vote
0answers
50 views
MongoDb cleanupOrphaned() running for days
My cleanup orphans on a collection is running for 3 days now. Log shows a few million records being deleted once in a while. However, most of the time nothing is deleted.
I SHARDING [conn3919] ...
0
votes
1answer
23 views
mongodb is not accessible through IP address 35.x.x.x
I have installed mongo DB on window server that is accessible on localhost:27017 but not accessible on 35.x.x.x:27017.
I checked:
27017 Port is open.
mongoDB is running.
output of: netstat -anb | ...
0
votes
1answer
59 views
Unable to perform queries through mongos
I have setup a minimal replicated configuration with mongodb 3.6.3,it seems to be everything fine but when I connect to the mongos (which as far as I understand acts like a kind of load balancer in ...
-1
votes
0answers
235 views
Too many open files - Mongodb 3.2.4 , Ubuntu
I have a client's server, with a downed mongod.
The log shows an error on mongodb 3.2.4 and ubuntu 16
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: ...
0
votes
1answer
183 views
MongoDb BI connection issue
I am trying to configure the MongoDB BI Connector.
I have installed mongodb-bi-win32-x86_64-v2.5.0.msi Mongodb version is 3.0.15
1.Started mongod
mongod --dbpath d:/data1 --auth
Started mongosqld
...
1
vote
0answers
166 views
Run command from one server to another
I am working with two EC2 instances. On one instance Golang code runs and on another instance Mongodb runs. Now I want to import a json file through command line for which I have written following ...
0
votes
1answer
526 views
How to Restore MongoDB Database After Having Deleted DB Files From Directory
I'm running MongoDB 2.6 on Ubuntu 14.04 and I accidentally deleted db file in /var/lib/mongodb.
I cannot restart the MongoDB instance:
mongo: error SEVERE: unable to open file number 5.
If I ...