Re: How does Ignite provides load balancing?

Hello! There's a section in the docs: https://apacheignite.readme.io/docs/affinity-collocation#section-affinity-function You can always study https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/cache/affinity/rendezvous/RendezvousAffinityFunction.java Note

Snapshotting and Restore in Ignite

Hi, When using Ignite as a persistence store is there a way to snapshot and restore from one cluster to the other? Ignite as a database is there any data loss when one of the nodes in baseline topology goes down. Is there an ideal recommendation for a number of replicas a table should run if it

What is update check & how to disable it?

Hello, On Ignite version:- >>> ver. 2.6.0#20180710-sha1:669feacc >>> 2018 Copyright(C) Apache Software Foundation In Apache Ignite logs every hour the below statement is logged:- "INFO [ignite-update-notifier-timer] cluster.GridUpdateNotifier" What is this statement is trying to convey / do?

Re: Client connects to server after too long time interval (1 minute)

I've found. TcpDiscoveryNode try to resolve sockAddrs in readExternal method from hostNames (first) and addrs (second). TcpDiscoverySpi fills hostNames for node with local hostnames. And of course new client node can resolve  only local hostname. In my case resolution of other node's hostnames

Re: Client connects to server after too long time interval (1 minute)

I've found. TcpDiscoveryNode try to resolve sockAddrs in readExternal method from hostNames (first) and addrs (second). TcpDiscoverySpi fills hostNames for node with local hostnames. And of course new client node can resolve  only local hostname. In my case resolution of other node's hostnames

Re: Cache Structure

Thanks for your informative reply. I looked at CacheQueryExample to be able to query by both unique (k1) and non-unique (k2) keys. I use an /AffinityKey/. However, k1 (unique key) and k2 (non-unique key) are not member variables, where I would have been able to annotate them with

Re: Security Setup

Hello! You seem to have some extra files in work/marshaller directory. Can you try clearing it up? Regards, -- Ilya Kasnacheev пн, 5 нояб. 2018 г. в 20:54, Skollur : > I am trying to setup basic login and password. I have coded as below but > getting an error as in the Ignite documentation.

Re: What is update check & how to disable it?

Hello! This notifier checks if there is newer Ignite version available for upgrade and prints message. You can disable it with -DIGNITE_UPDATE_NOTIFIER=false. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: FIFO Queue with POPs AND PUSHes - like REDIS LIST

Hello! What was the problem with IgniteQueue https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/IgniteQueue.html ? Regards, -- Ilya Kasnacheev ср, 7 нояб. 2018 г. в 12:41, kommrad homer : > Hello , > I've set up a single node of ignite , on SERVER Mode , running on a VPS of

Re: Snapshotting and Restore in Ignite

Hello! Currently there is no snapshotting in Apache Ignite. You could restore a different cluster from shutdown nodes' persistence directories but not from live nodes'. There are third party commercial implementations of snapshotting for Ignite. Regards, -- Sent from:

Re: SQL Support for IN predicate

In any case, answer for replacing '?' with variables also placed on the same page I've shared earlier. Evgenii чт, 15 нояб. 2018 г. в 08:25, Ray : > Hello Evgenii, > > I have a question about IN clause not using indexes. > > From my local test results, it seems IN clause does use indexes. > > I

Re: SQL Support for IN predicate

Hi, IN clause is supported, however, it doesn't use indexes for now. It's better to replace it with a join to the temporary table: https://apacheignite-sql.readme.io/docs/performance-and-debugging#sql-performance-and-usability-considerations - paragraph 2. Evgenii ср, 14 нояб. 2018 г. в 23:26,

Re: SQL Support for IN predicate

Hello Evgenii, I have a question about IN clause not using indexes. >From my local test results, it seems IN clause does use indexes. I have a table named aaa and this table has an index on field d. The query plan indicates that IN clause does use indexes. 0: jdbc:ignite:thin://127.0.0.1/>

Re: SQL Support for IN predicate

Ray, By the way, which version do you use? Evgenii чт, 15 нояб. 2018 г. в 09:38, Evgenii Zhuravlev : > In any case, answer for replacing '?' with variables also placed on the > same page I've shared earlier. > > Evgenii > > чт, 15 нояб. 2018 г. в 08:25, Ray : > >> Hello Evgenii, >> >> I have a

Re: SQL Support for IN predicate

I'm using Ignite 2.6. Maybe the document is outdated? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Dependency resource injection with OpenWebBeans CDI instead of Spring

Hello! Judging from the .internal. designation of this interface, it doesn't look like you can meaningfully extend it in your code. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Unable to load more than 5g data through sqlline

Hello! Looks like you have allowed more heap/offheap memory for Ignite than your operating system can allocate. Are you sure you're not starting multiple nodes on same box? Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: 1 server - many Clients scenario failing

Hello! You should avoid usage of IPs not visible to some nodes, for example by setting localAddress setting. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Quering with PHP PDO returns null for all column values except the 1st one

Hello! Looks like it's getting fixed in JIRA as we speak. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ComplexObjects via REST API?

Hello! We have it kinda documented via https://apacheignite.readme.io/docs/rest-api#section-general-configuration Also I can see that the following ticket now exists: https://issues.apache.org/jira/browse/IGNITE-9758 Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Very slow to execute batch merge into statement .

Hello! My recommendation will be using Cache API's replace() or invoke() calls. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Snapshotting and Restore in Ignite

Gridgain has some kind of snapshoting add in. You can save and restore the workDirectory from each node when the cluster is in a stable state, provided that you use the same CONSISTENT_ID when restoring. We were able to convert the directory name back into a consistent ID on restore, but we had

Re: Ways to improve re-balancing of partitions and how to monitor re-balance progress

Hello! Unfortunately if you have clients coming and parting from cluster all the time, your rebalance can take long time. There is a ticket on this issue: https://issues.apache.org/jira/browse/IGNITE-7165 It looks like it will be fixed in 2.7. Regards, -- Ilya Kasnacheev вт, 13 нояб. 2018

SQL Support for IN predicate

Hi, *Is "IN" predicate supported? *If so, can we use a "?" to be replaced and how? Example. I'd like to construct something like this for an integer property: "id IN (1, 6, 12)" Thanks Ramin

Upgrading from 1.9 .... need help

Hi, We are using Ignite 1.9 OffHeapCache with swap space disabled, we have about 80 different caches, all are defined programmatically. Some have the expiry, some have eviction policy. We are trying to upgrade to 2.6 and need help - 1. Many API from 1.9 is no longer supported or deprecated in

Re: Snapshotting and Restore in Ignite

Hello, If cache backups are zero, ofcourse there will be data loss when node is removed from BLT. Number of replicas (assuming you mean number of backups) depends upon how resilient you want your cluster to be but ofcourse having more replicas can affect cache write performance. Best, Gaurav

C# Custom Affinity Functions

Hi, We are using ignite 2.6 C#. If we define a custom affinity function (written in c#) when configuring the cache (using a IgniteConfiguration object not spring config) the first call to Ignition.Start is successful. If we activate the grid, wait for it to become active then shut the