Estimation of cluster effective capacity

[vkondraschenko]

Dear support team,

I am trying to estimate memory efficiently available for cache payload in
cluster. I base my calculation on 
https://apacheignite.readme.io/docs/capacity-planning. Can you please
confirm that the following formula gives rough but realistic estimation of
memory available for caches in a small/medium size cluster:

Effective capacity = ( - 300Mb (OS) - 300Mb (Ignite JVM) - 100Mb
(Monitoring Agent JVM in deployed on each node)) * Number_of_nodes

So if there are 2 nodes in cluster with 4Gb of RAM on each one, effective
cluster capacity is about (4096 - 700) * 2 = 6792Mb. Another example, if
there are 4 nodes with 4Gb of RAM on each one and caches use replication
factor of 2 (two), then effective cluster capacity is (4096 - 700) * 4 / 2 =
6792Mb (the same volume, but there is redundancy of data).



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: OBDC Ignite driver error in MS Excel: ODBC version is not supported

[vkondraschenko]

Igor, thank you for assistance in clarifying this issue. It really seems to
be specific to configuration of Excel ODBC connections rather than
specifically Ignite ODBC driver.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: OBDC Ignite driver error in MS Excel: ODBC version is not supported

[vkondraschenko]

Igor,

Excel data import scenario is designed to query for any connection
parameters after clicking on 'Connect...'. These parameters are supposed to
be queried by the driver. But in fact the error occurs prior to querying for
any additional data.
 



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: OBDC Ignite driver error in MS Excel: ODBC version is not supported

[vkondraschenko]

Igor, I have captured logs using the 'tracing feature'. I enabled tracing
before the experiment and stopped it right after. Please find the SQL.LOG
file attached.

SQL.LOG   



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

OBDC Ignite driver error in MS Excel: ODBC version is not supported

[vkondraschenko]

I am trying to use the ODBC Ignite driver from MS Excel 2010 (importing data
from the ODBC data source), but it fails to connect with the message "ODBC
version is not supported". 

OS: Windows 10 64-bit 
Client: MS Excel 2010 64-bit 
ODBC driver:
apache-ignite-fabric-2.2.0-bin\platforms\cpp\bin\odbc\ignite-odbc-amd64.msi 
Error message: ODBC version is not supported 

I see similar reported issues for other clients. Could you please clarify
how to get around the problem?



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/