Hi Sergi
Good to know. Thanks for your contributions.
Let us know if there is anything we can do to make H2 better for Ignite.
Regards, Noel
On 2015-01-28 10:15 AM, Sergi Vladykin wrote:
Hi Noel!
Currently we use original version of H2 database, it is just a Maven dependency
in our project. Time ago I committed
some improvements for H2 database (I'm still on the committers list). I think
the page says about that, so it is done
already :)
In general of course we prefer contributing back to original projects instead
of forking.
Sergi
On Tuesday, January 27, 2015 at 8:11:25 PM UTC+3, Noel Grandin wrote:
Hi sergi
Nice to see h2 being used for something like that! Awesome!
I see on that page that grid gain engineers have patched h2. Have those
patches been contributed back?
Regards, Noel.
On Tuesday, 27 January 2015, Sergi Vladykin <[email protected]
<javascript:>> wrote:
Hi,
Apparently H2 is used as SQL engine in GridGain
<http://www.gridgain.com/> (a similar to Hazelcast open source
grid) to query entries in distributed caches.
Now GridGain is donated to Apache Software Foundation under the name of
Apache Ignite
<http://ignite.incubator.apache.org/> and as part of this transition we
are working on complete SQL support
using H2.
How it works right now you can check here:
http://doc.gridgain.org/latest/SQL%2C+Scan%2C+And+Full+Text+Queries
<http://doc.gridgain.org/latest/SQL%2C+Scan%2C+And+Full+Text+Queries>
So stay tuned!
BTW, Contributions to Apache Ignite project are welcome!
Sergi
On Tuesday, January 27, 2015 at 3:07:57 PM UTC+3, wener wrote:
Any plan to add distributability for H2 over hazelcast ?
Like OrientDB + Hazelcast
Here is a webinar talk about this
orientdb-hazelcast-__memory-distributed-graph-__database
<http://hazelcast.com/resources/orientdb-hazelcast-memory-distributed-graph-database/>.
Here is what I googled.
https://groups.__google.com/forum/#!topic/__hazelcast/-qkG8AVM1GA
<https://groups.google.com/forum/#!topic/hazelcast/-qkG8AVM1GA>
There is no easier answer to this one unfortunately. I am
however a big fan of H2 Db and have spent some
time looking at doing exactly what you have described. Here is
the basic approach, which would take a
couple of passes to get right:
1. Each node instance has a copy of the H2 database engine.
Relational data structure are stored on the
grid along with cache data
2. Modify the H2 source, injecting Hazelcast Map objects and
List objects where appropriate
3. Modify thread synchronization related to relational data
structure access and allow Hazelcast to manage
4. Look at opportunities in the H2 code to use the distributed
executor service on the grid for
parallel processing
5. The trick is to make sure you are processing data on the
grid and mot pulling large data sets back
to an individual node too soon.
H2 does provide the ability to plug-in your own file system
fairly easily, however I don't think you
would see any benefit moving the in-memory file system to a
distributed in-memory file system without
addressing concurrency issues at the data structure level.
I think it may all be worth doing though :)
Regards,
Eric
H2 dose has master-slave-abiliy , but it's very limited.
--
You received this message because you are subscribed to the Google Groups
"H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to
[email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database
<http://groups.google.com/group/h2-database>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
[email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.