IDS Forum

Re: Max number of instances per server

Posted By: Madison Pruet
Date: Wednesday, 19 October 2016, at 3:51 p.m.

In Response To: Max number of instances per server (Kate Tomchik)

blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } You can have only 255 instances on a given logical server. That's because the server ID is used to calculate the shared memory key and the server ID is only contained in one byte of that key. If you want to have more instances on a physical machine, then you would need to create virtual machines al la VMWARE.
Also, as Carlton mentioned you must use the same path name for the chunks on the primary as the secondary. That would be an issue unless you are using relative path names for the chunks.
But let's focus on what the goal is. Is this really for high availability, or are you trying to consolidate the data from the remote machines? If the real goal is data consolidation, then I would suggest that you consider using parallel sharing that exists in IDS 12. The advantage of using that technique is that there does not have to be any data movement at all and to perform a query against all 2000 servers would not take much longer than a query against an individual server since all aspects of the query would be performed in parallel. In late versions of IDS 11, we introduced the grid query which is basically the first phase of the parallel shard query. The biggest difference is that the grid query requires dynamically moving the remote data dictionary to the server on which the query is executed and the grid query performs the operation on each node serially. With the shard query none of that happens.
There is a form of the shard table definition called "informational". This just updates the shard dictionary but does NOT cause the data to be moved from one node to the other.
Also - while the parallel shard query is described with the nosql features, it is NOT restricted to nosql tables.

Sent from Yahoo Mail for iPad

On Wednesday, October 19, 2016, 11:59 AM, Kate Tomchik <katedarts@gmail.com> wrote:

Hey all,
I am looking into the feasibility of using HDR from 2000 sites to a central
server. Is it possible for a single server to hold 2000 instances, and has
anyone else out there done that? Any details you have on how you run
queries against that as well would be great info.

--
Will chat again soon,
Kate
katedarts@gmail.com

--001a1144491cc9cb96053f3ab9e0

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Max number of instances per server
  Kate Tomchik -- Wednesday, 19 October 2016, at 12:59 p.m.
  • Re: Max number of instances per server
    Art Kagel -- Wednesday, 19 October 2016, at 1:05 p.m.
  • Re: Max number of instances per server
    Fernando Nunes -- Wednesday, 19 October 2016, at 1:06 p.m.
  • Re: Max number of instances per server
    Carlton Doe -- Wednesday, 19 October 2016, at 1:13 p.m.
    • Re: Max number of instances per server
      Kate Tomchik -- Wednesday, 19 October 2016, at 1:27 p.m.
      • Re: Max number of instances per server
        Fernando Nunes -- Wednesday, 19 October 2016, at 1:40 p.m.
  • Re: Max number of instances per server
    Khaled BENTEBAL -- Wednesday, 19 October 2016, at 2:31 p.m.
  • Re: Max number of instances per server
    Madison Pruet -- Wednesday, 19 October 2016, at 3:51 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.