Re: Is it possible to import existing mysql database from file in console?

2017-12-21 Thread bagsiur
Ok, thanks for reply. It's helpful. I have another question: What about backup? I storage my database in memory, what happened if Apache Ignite is stopping? Do I lose my data? Haw Can I do backup and if is nessesery load it to the cluster? Does apache ignite provide tools for do this, or I must

Re: Ignite service method cannot invoke for third time

2017-12-21 Thread arunkjn
Hi Dmitry, Sorry this is off the topic but I am a beginner in Java programming. I want to understand why it helped to make EntryProcessor a static inner class. Also want to understand how to analyze thread dumps and what information we can extract from it. If you can point me to some good

Re: loadAll and removeAll from cache with custom store

2017-12-21 Thread matt
For the removeAll() call, I do see that after I do a loadCache((k,v) -> true) I can delete items from the store, but my store's deleteAll() only ever gets 1k items once, deletes them from the store, and then is never called again to delete the rest of the items in the store. -- Sent from:

loadAll and removeAll from cache with custom store

2017-12-21 Thread matt
Hi, For loading all data into Ignite before running a job, is loadAll sufficient? How can I prevent running loadAll on subsequent job runs? Is there a way to control whether or not the cache is loaded from the read-through store if the data has already been loaded? I'm concerned about job startup

Re: How to connect apache ignite node by static ip address

2017-12-21 Thread vkulichenko
I replied to this on StackOverflow: https://stackoverflow.com/questions/47931737/how-to-connect-apache-ignite-node-by-static-ip-address -Val -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

How to connect apache ignite node by static ip address

2017-12-21 Thread manatee
I have got a hetzner server with config:

Re: Performance comparisons

2017-12-21 Thread Dmitri Bronnikov
"makes sense to run benchmarks" and "makes sense to force everyone to run their own" aren't the same. I think you support the first, whereas I argue with the second. Nearly everyone publishes numbers vs Cassandra which makes it easy to compare tuned setups of any two products (except Cassandra

Re: IgniteVisor showing the cache, but SQLLINE tables are not seen

2017-12-21 Thread slava.koptilin
The first approach, as I mentioned above, is using DDL. Please see an example https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/datagrid/CacheQueryDdlExample.java The second one, you need to use CacheConfiguration.setIndexedTypes() as follows:

Re: Ignite service method cannot invoke for third time

2017-12-21 Thread arunkjn
So I have separated these classes into independent classes now and made them non static. This is also working well for me. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: IgniteVisor showing the cache, but SQLLINE tables are not seen

2017-12-21 Thread Naveen
I did the same but still no luck, here is the code snippet CacheConfiguration cc = new CacheConfiguration("AccountNew"); cc.setBackups(1); cc.setAtomicityMode(CacheAtomicityMode.ATOMIC);

Re: Ignite service method cannot invoke for third time

2017-12-21 Thread dkarachentsev
Glad to hear that it was helpful! I wrote the example just in email, so didn't have a compiler to check it :) Thanks! -Dmitry -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Soft copy High Performance in-memory computing with Apache Ignite Book by Michael Zheludkov, Shamim Bhuiyan, and Timur Isachenko

2017-12-21 Thread Naveen
Hi Igniters I am planning to buy this book from Amazon, but the delivery takes 2 weeks to deliver to India. Can anyone has soft copy of this book, even its paid, I am fine to pay for the soft copy. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite service method cannot invoke for third time

2017-12-21 Thread dkarachentsev
Sure, I meant you need to create your own inner class: private static class WorkflowEntryProcessor extends EntryProcessor { @Override public Object process(MutableEntry entry, Object... arguments) throws EntryProcessorException {

Re: Ignite cluster configure (2.3.0)

2017-12-21 Thread dkarachentsev
Hi Dmitriy, 1. You may use node filter [1] and specifically org.apache.ignite.util.AttributeNodeFilter that could be configured in XML without writing code. 2. Yes you can. You need to configure data regions and set persistenceEnabled flag. After that you may apply cachesh to that regions. [2]

Re: Ignite service method cannot invoke for third time

2017-12-21 Thread arunkjn
Hi Dmitry, Sorry I don't understand what you mean. Do you mean to do this- static EntryProcessor workflowStartProcessor = new EntryProcessor() { @Override public Object process(MutableEntry entry, Object... arguments) throws

Ignite cluster configure (2.3.0)

2017-12-21 Thread Kvon, Dmitriy
Hi All! 1. I have two types of nodes: "A" and "B". On the nodes "A" I deploy the cache "1", on the nodes "B" - cache "2". It is necessary that the "B" nodes are servers for cache "2" and clients for servers "A" at the same time. What is the best practice? 2. Can I

Re: List of running Continuous queries or CacheEntryListener per cache or node

2017-12-21 Thread Nikolay Izhikov
Hello, Dmitry. I think it a great idea. Do we a feature to list all running ComputeTasks? I, personally, think we have to implement possibility to track all user-provided tasks - CacheListener, ContinuousQuery, ComputeTasks, etc. В Чт, 21/12/2017 в 10:13 +0300, Dmitry Karachentsev пишет: >

IgniteVisor showing the cache, but SQLLINE tables are not seen

2017-12-21 Thread Naveen
Hi AM using Ignite 2.3, I have created 2 caches thru Java API and could see the same thru igniteVisor, but I dont see anything SQLLINE when I execute !tables, what could be the reason. I ahev shared the config xml, and DataLoad.java used for loading the data visor> cache -e Time of the

Re: SQL and backing cache question

2017-12-21 Thread Naveen Kumar
I do have the same question. When we execute the DDL statement for creating the table thru SQLLINE with the value_type as some.package.MWorkPlan, does it create the java class with this name and load it into JVM. OR we need to create some.package.MWorkPlan class and refer while creating the

Re: “Failed to communicate with Ignite cluster" error when using JDBC Thin driver

2017-12-21 Thread dkarachentsev
Is there any case that you're using Connection in more than one thread? It's not thread safe for now. Thanks! -Dmitry -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Server node is frequently getting dropped from cluster.

2017-12-21 Thread dkarachentsev
Hi, Is it possible that firewall configured to block DDoS breaks connection to client node? Because I see here two possible cases: 1) STW pause on client, but we should see connection timeout exception; 2) Firewall rejects connections with a large traffic, and now you're getting connection

Re: Ignite 2.3 Swap Path configuration is causing issue

2017-12-21 Thread Alexey Kukushkin
You will get OutOfMemory error if data does not fit into data region. Configure an eviction policy or persistence to avoid that.

Re: Ignite service method cannot invoke for third time

2017-12-21 Thread dkarachentsev
Hi, It looks like anonymous EntryProcessor gets excess data in context. Try to make it inner static class and check logs for exceptions on all nodes. Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Memory foot print of the ignite nThe background cache eviction process was unable to free [10] percent of the cache for Context

2017-12-21 Thread Naveen
Thanks Alexey. As you mentioned, in heap its only java classes that reside, which you can mention while starting the ignite thru VM options and it will be reflected after the node comes up Topology snapshot [ver=1, servers=1, clients=0, CPUs=8, heap=7.1GB] And, on linux when we execute top

Server node is frequently getting dropped from cluster.

2017-12-21 Thread aMark
Hi, We are using Ignite cache version 2.1 . We are using it as persistent store in Partitioned Mode having 4 cluster node running. Atomicity mode is ATOMIC, and Rebalance mode is ASYNC while CacheWriteSynchronizationMode is FULL_SYNC. We are experiencing frequent connection issue where