My app has a User collection. Each document in the collection averages about .04 MB. At worst case, a document may slightly exceed .1 MB. Needless to say, these are small documents. However, each document could potentially have over 1000…
I'm an SQL novice, I have a big data table with attributes exceeding 10000 columns which is hosted by CSV, and those columns come from multiple sites, I tried to import them into a database to manage them due to…
I have faced this scenario in one of my interview. There will one table with millions of records and the table is going to have only two columns id which is primary key and time_stamp which is of type date…
I want to segment data based on a geographic area by following this guide by MongoDB, to make an application globally accessible with low-latency. The data should be segmented by using the shard key { country : 1, userid :…
I need to retrieve information about a MongoDB collection's sharding configuration, specifically the shardKey and unique fields. While I can easily obtain this information using the sh.status() command in the MongoDB shell, I haven't been able to figure out how…
I am designing a sharded database. Many times we use two columns, first for logical shard and second for uniquely identifying a row in the shard. Instead of that I am planning to have just a 1 column with long…
just wanted to understand a scenario where if primary shard cluster down. so i have a setup of Mongo database where i have 4 shards running in replicaset. shard-1 == Server 1 (Primary), shard-1 Server 2 (Secondary), shard-1 - Server…
I'm learning about sharding approaches. How to achieve good horizontal scalability with a large number of shards in an IO-heavy application. Below I describe a case that I expect to see in my app. I think that this would be…
So I have a sharded cluster with 2 config servers, 2 shards each with 2 replicas and 2 mongos instances, everything running on different VMs. However, after configuring all of it, I finally tried to interact with the database which…