mongodb - Different indexes on different replica set members -


as part of our mongo cluster, have hidden node analytics people use reporting. queries quite bit different ones our main application optimized for.

we can improve performance of queries quite dramatically adding indexes, relatively expensive compute, , take fair amount of memory. indexes should not used of queries running on our primary , secondary members, seems bit silly spend time , memory on main replica set members compute , keep reporting indexes in memory.

is there way create index exists on single replica set member? there way tell primary , secondary nodes not compute or store indexes know not use?

yes - can use variation on strategy used creating new index in replica set without down time. require hidden member taken off-line while index(es) created.

here link strategy: http://docs.mongodb.org/manual/tutorial/build-indexes-on-replica-sets/#procedure

in case take hidden member off-line , restart in standalone mode (remove --replset option , use different port number). once member isolated can adjust indexes (remove un-needed ones , add new ones). once indexes done being created restart member old port , --replset option.

the hidden member resync replica set , set.


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more