Search code examples
sqlignite

Counting Ignite Physical Servers

Newbie question, but not seeing a clear answer in the docs: I want to run a query on Ignite (2.13) that returns the number of physical ignite servers - despite Ignite running within containers. I suspect this will require some inference, as Ignite reports IP address per server (container or physical).

Something like Select * from sys.Nodes; but somehow collapsing containers on the same server together.

Any thoughts? Thx!

Solution

  • There is no such built in machinery, why would you need it?

    I suppose you might do the following instead:

    • mark all containers running at the same machine by a single User Attribute, like MY_SERVER_NUMBER_1, MY_SERVER_NUMBER_2

    • query the nodes and filter by unique attriubteId, something like:

       select count (distinct Name) from sys.NODE_ATTRIBUTES where Name like 'MY_SERVER_NUMBER_%'