The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
40 views

Replicated MongoDB server slower than simple shards

I tried to compare the performance of a sharded configuration against a sharded and replicated configuration. The sharded configuration consists of 8 shards each running on three different machines ...
0
votes
1answer
19 views

How to recover a degraded MongoDB sharded cluster?

I've had problems with a MongoDB replica set of my sharded cluster. The current status of the nodes is: node1: primary (but apparently vetoed by node3 that needs to sync) node2: rollback (it was the ...
0
votes
0answers
26 views

Is there a way to set dynamic mongodb shard tagging?

I'd like to deploy a mongodb cluster with 2 shards: one for short-term-storage (STS) and the other for long-term-storage (LTS). I need my data to be split in 2 parts: 1 month old data and newer goes ...
0
votes
2answers
45 views

Restart tomcat on two different servers at same time

We are running the Apache solr on two servers. Unfortunately on heavy load of indexing (guess) servers going down. We are manually restarting the tomcat each time. When I google I find the way two ...
0
votes
0answers
35 views

MongoDB Sharding Issue

I made some Sharding tests but I always got the same issue. I got 1 config server, 3 shards (mongod) on 3 different servers (500 Go each). When I made an insertion of huge amount of data (1 000 000 ...
1
vote
1answer
131 views

Rename Mongo Shard

Can I, and if I can, how can I rename a shard in Mongo? Like if I wanted to change the instances of rs0 to rep0 below: mongos> sh.status() --- Sharding Status --- sharding version: { "_id" ...
4
votes
1answer
567 views

What's the advantage of splitting a mysql table into smaller ones without physical distribution?

I've seen such design in my company. A big mysql table is split into tens of smaller ones of identical schema on the same server in the same db, without any physical distribution, no ...
0
votes
1answer
41 views

MongoDB sharding authentication with multiple keyFile's

I have configured MongoDB with sharding something like below. Shard1 Shard2 Shard3 -------- -------- ------- rs1(Pri) rs1(Sec) rs1(Sec) rs2(Sec) rs2(Pri) rs2(Sec) rs3(Sec) ...
3
votes
2answers
171 views

Mongo Sharding - Config Server and Mongo Authentication

I am needing to shard a database fairly soon, and am unclear on what the best practice is for enabling authentication on the mongos and config servers. I would like to have everything be secured with ...
1
vote
1answer
64 views

MongoDB Balancer

So I have 2 sharded clusters with 3 servers each.My mongos is running, my config server is running and ive also added test data to 1 of the 2 shard clusters. I am having trouble getting that data to ...
0
votes
1answer
202 views

How would I template an SLS using saltstack

I'm trying to do proof of concept with Mongodb(sharding) and Id like to run a command every time I spin up a new cluster without having to add lines in all my sls files. My current init is as follows: ...
0
votes
0answers
55 views

Setting up MongoDB sharding

Would anyone know how to setup MongoDb with 2 sharding clusters? So it must include shard keys, config servers etc.. All using configuration management tool saltstack
1
vote
0answers
181 views

Why mongo pecl module looses its connection after Primary stepDown?

I run an Apache 2.2.22-13 with pecl module "mongo 1.4.4". It connects to a MongoDB 2.4.6 sharded cluster. When a stepDown occurs, the mongo module seems to stay on the mongod node which was the ...
0
votes
1answer
81 views

What's special in restoring a DB in a MongoDB sharded cluster?

I'd like to migrate a DB from a replica set to another which belongs to a sharded cluster. Till now, this cluster has got only 1 shard, and no collection or database is really sharded. I mongodumped ...
2
votes
1answer
64 views

Add new shard - always best? [closed]

In our setup, we currently have 3 shard set sharded cluster, each shard being a replica set of 3. Our writes are about to go up significantly to implement a new feature, and we know the extra data ...
-3
votes
1answer
85 views

Mysql Cluster Sharding/partitioning [closed]

Ok so i have mysql cluster setup but what i need is say table assets to be split among the nodes, not replicated. as the purpose of me setting up the cluster was due to lack of hard drive space so how ...
0
votes
2answers
83 views

remove a mongodb replica set when into a sharding cluster

I have this configuration: mongos> db.adminCommand('getShardMap') { "map" : { "RS13" : "RS13/mongo09-02:27003,mongo09-01:27001", "RS13/mongo09-02:27003,mongo09-01:27001" : ...
0
votes
1answer
98 views

SQl Server sharding

Can SQL Server be sharded for distributed data processing? Or are there any limitations that prevent relational databases from being sharded ?
3
votes
3answers
5k views

Run a MongoDB configuration server without 3GB of journal files

For a production sharded MongoDB installation we need 3 configuration servers. According to the documentation "the config server mongod process is fairly lightweight and can be ran on machines ...
2
votes
1answer
230 views

Mongodb Slave replication lag

We using standard mongo setup: 2 replicas + 1 arbiter. Both replica servers use same AWS m1.medium with RAID10 EBS. We experiencing constantly growing replication lag on secondary replica. I ...
3
votes
4answers
340 views

Find busiest databases and tables on MySQL server

I have a busy MyMQL server with quite a few databases. I'm trying to figure out the best way to find the busiest databases (and tables) on the server so I can migrate them to a separate machine. ...
5
votes
1answer
180 views

Upgrading a mongo cluster

I am looking at adopting a Mongo cluster and am doing research. We hope to have a cluster that can scale from 10k updates per second to 100k updates per second with very write heavy traffic. The ...
8
votes
3answers
8k views

postgreSQL vs Cassandra vs MongoDB vs Voldemart?

Which database to decide upon? Any comparisions? Existing: postgresql Issues Not easily scalable horizontal. Needs sharding etc Clustering does not solve the data growth problem ...
2
votes
2answers
411 views

Mongos not using secondary for read in replica/sharding mongo setup

I have a Mongo DB setup of 4 DB (2 shards of 2 replica) and I noticed that the secondary servers of each shard is not being used for read queries. Both secondary servers received all inserts, updates ...
1
vote
1answer
321 views

ASP.NET, reaching the limits of DFSR, and file storage sharding

We run a popular web app, and our backend file storage exists on a file server, replicated to another file server for failover with DFSR. We are reaching the theoretical limits of DFSR, and therefore ...
1
vote
1answer
447 views

How to “unshard” an existant collection in mongo?

While setting up some collections in a mongo database to be sharded, I entered the name of one of them wrong (typo letter at the end). When I do db.printShardingStatus(), I see that inexistent ...
3
votes
1answer
260 views

What is the safest way to change MongoDB server structure?

I currently have a MongoDB replica set configured as such: { "_id" : "ahspy_mongo_set", "version" : 13, "members" : [ { "_id" : 0, ...
3
votes
3answers
539 views

Is it OK to shard mongodb without replica set?

Lets say I have 4 database servers. I want to add them to the "shard" cluster. That's it. No replica set, no nothing. Just 4 servers. If I turn "journaling" on all of them, is it OK?
0
votes
2answers
82 views

2 partitions in a sharded mysql database

the first one is running at 73% memory utilization. The second one runs at 16% utilization. how can i balance the 2 out?
1
vote
1answer
95 views

Multiple databases on Mysql crashes the mysql server often

We are running Mysql on CentOS 5.5. And are using the database sharding approach. As it is an erp app, there are about 300 tables for each new Application/company. At the moment we have around 600 ...
1
vote
3answers
181 views

How to automatically move specific MySQL tables from one machine to another?

I have a MySQL database with tables in the form of "shard_0", "shard_1", "shard_2", etc. I want to add another DB server and move the even-numbered shards ("shard_0", "shard_2", "shard_4", ...) to ...
0
votes
5answers
1k views

I have to shard a mysql database. I want to start with 12 shards on 2 machines. What is the best way to move some of them when I want to add a new server?

All tables are InnoDb. I would rather not use mysqldump, because the shard sizes will be about 200 GB (about 700 million rows), and that will take too long. I was hoping to just stop mysql for an ...
2
votes
1answer
390 views

How to scale out by elvolving from database partitions to sharding?

Say I have a MySQL table: CREATE TABLE tweets ( tweet_id INT NOT NULL AUTO_INCREMENT, author_id INT NOT NULL, text CHAR(140) NOT NULL, PRIMARY KEY (tweet_id) ) PARTITION BY HASH(tweet_id) PARTITIONS ...
0
votes
3answers
207 views

Splitting a MySQL DB in two may ease server from “Too many connetions”? I don't think so

I was requested to split a MySQL in two, it's kind of a horizontal partition, in which some rows correspond to one site, and some other correspond to another site. But they want to split it in two DBs ...