Re: Ignite as Cache and Query layer for Cassandra.

2017-08-31 Thread Mark Farnan
Hi Ilya, 

That documentation I saw,  however it seems to describe only using 
Cassandra as a Persistant store for  Ignite Caches,   i.e. 

"Ignite Cassandra module implements persistent store for Ignite caches by 
utilizing Cassandraas a persistent storage for expired cache records.
It functions pretty much the same way like CacheJdbcBlobStore and 
CacheJdbcPojoStoreand provides such benefits:"

It dosn't seem to describe anywhere, how to set it up over an existing 
large cassandra table structure to act as a cache and SQL query mechanism 
for it.   Nor how to deal with the fact you can't have it all in memory 
and how Writes and Reads would be handled etc. 
Also several of the links on the page are broken. 

Ideally want to be able to run ad-hoc SQL queries over the data, including 
joins etc. \

I agree there are config examples, AWS etc,   but  they all seem to me, to 
be for persistance of general cache,  BLOB or POJO,   not for what the 
InfoWorld article described. 

Unless I'm missing something obvious !. 


Regards

Mark. 





From:   Ilya Kasnacheev <ilya.kasnach...@gmail.com>
To: user@ignite.apache.org, 
Date:   08/31/2017 06:56 PM
Subject:Re: Ignite as Cache and Query layer for Cassandra.



Hello Mark,

I have found some documentation on how to do what the article describes:

"Apache Ignite can be inserted between Apache Cassandra and an existing 
application layer with no changes to the Cassandra data and only minimal 
changes to the application"

https://apacheignite-mix.readme.io/docs/ignite-with-apache-cassandra

On the left you can see there are config examples, tests, AWS 
configuration, etc.

Hope it's good enough.


-- 
Ilya Kasnacheev

2017-08-31 16:15 GMT+03:00 Mark Farnan <mark.far...@petrolink.com>:
Howdy, 

I'm currently evaluating Ignite for a project, and am looking for some 
guidance and project sample for using Ignite over Cassandra as a cache and 
query layer.   
Note: The Cassandra database and schema already exists and is mature.   

In a Recent Infoworld post,   (
https://www.infoworld.com/article/3191895/application-development/light-a-fire-under-cassandra-with-apache-ignite.html
) it stated 

"No remodeling of Cassandra data 
Apache Ignite reads from Apache Cassandra and other NoSQL databases, so 
moving Cassandra data into Ignite requires no data modification. The data 
schema can also be migrated directly into Ignite as is. " 

However, I can't find in any documentation,  or online articles,  guidance 
on just how to do this and there are no links in the article. 
  - The Ignite docs /cassandra section appear to only cover using 
Cassandra as a persistence layer,  not for going over and caching / 
querying an existing schema.   (unless I'm missing something obvious !) 
  - The Youtube video cuts out to blank at the end, so no links are shown. 
   The  links on the slideshare document appear to be broken. 
  -  Can't find any git hub for examples on how to do this (especially not 
for the couple you tube vids) 

Can anyone please point me to some working sample code and/or 
documentation on how to do this ? 

I'm especially interested in not having to migrate any schema's,  nor 
having to pre-load the data into the cache.  (lazy load), which the 
articles imply. 
Also some of the data would be too large to load it all into Ram anyway. 


Any assistance greatly appreciated.   


Regards 

Mark. 



Ignite as Cache and Query layer for Cassandra.

2017-08-31 Thread Mark Farnan
Howdy, 

I'm currently evaluating Ignite for a project, and am looking for some 
guidance and project sample for using Ignite over Cassandra as a cache and 
query layer. 
Note: The Cassandra database and schema already exists and is mature. 

In a Recent Infoworld post,   (
https://www.infoworld.com/article/3191895/application-development/light-a-fire-under-cassandra-with-apache-ignite.html
) it stated 

"No remodeling of Cassandra data
Apache Ignite reads from Apache Cassandra and other NoSQL databases, so 
moving Cassandra data into Ignite requires no data modification. The data 
schema can also be migrated directly into Ignite as is. "

However, I can't find in any documentation,  or online articles,  guidance 
on just how to do this and there are no links in the article. 
  - The Ignite docs /cassandra section appear to only cover using 
Cassandra as a persistence layer,  not for going over and caching / 
querying an existing schema.   (unless I'm missing something obvious !)
  - The Youtube video cuts out to blank at the end, so no links are shown. 
   The  links on the slideshare document appear to be broken. 
  -  Can't find any git hub for examples on how to do this (especially not 
for the couple you tube vids)

Can anyone please point me to some working sample code and/or 
documentation on how to do this ?

I'm especially interested in not having to migrate any schema's,  nor 
having to pre-load the data into the cache.  (lazy load), which the 
articles imply. 
Also some of the data would be too large to load it all into Ram anyway. 


Any assistance greatly appreciated. 


Regards

Mark.