You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by joseheitor <jo...@heitorprojects.com> on 2018/02/27 05:34:53 UTC

How to configure a cluster as a persistent, replicated SQL database

How do I configure a cluster as a persistent, replicated SQL datastore?And
can it perform as an active-active, high-availability solution that can be
scaled horizontally? 



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

RE: How to configure a cluster as a persistent, replicated SQLdatabase

Posted by "ilya.kasnacheev" <il...@gmail.com>.

Hello  Naveen!

I guess you have to use CREATE TABLE for caches to be in PUBLIC schema. I'm
afraid it doesn't work that way for if they're created using Ignite API.

Regards,



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

RE: How to configure a cluster as a persistent, replicated SQLdatabase

Posted by Naveen <na...@gmail.com>.

Hi Stan

I was able to setup ignite with Oracle as persistent layer. 
However I still have one concern, the existing Oracle DMLs are not working
with ignite

For e.g

In Oracle below is the insert statement I use

    insert into map_dummy (ENTITY_ID, MAPPING_ID_LIST, RELATIONSHIP,
UPDATEDDATETIME, UPDATEDBY, SEQUENCE_NO, TUPLE_COUNT) values
    ('8','maplist8','rel2',sysdate,'upd2','2','2')

In ignite, I had to prefix with schema

INSERT INTO *"MapDummyCache".*MAP_DUMMY (ENTITY_ID, MAPPING_ID_LIST,
RELATIONSHIP, UPDATEDDATETIME, UPDATEDBY, SEQUENCE_NO, TUPLE_COUNT) values
    ('6','maplist6','rel5',sysdate,'upd5','5','5');

Because of this, I had to change my existing Oracle DMLs to make it work
with Ignite. 
I believe I tried to change the schema to PUBLIC by explicitly setting the
schema while creating the cache, but still no luck,

Any suggestions for this,

Thanks
Naveen



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

RE: How to configure a cluster as a persistent, replicated SQLdatabase

Posted by Stanislav Lukyanov <st...@gmail.com>.

Hi Naveen,

Please refer to this page https://apacheignite.readme.io/docs/3rd-party-store.
In short, you need to implement a CacheStore or use one of the standard implementations (CacheJdbcBlobStore, CacheJdbcPojoStore)
and add it to your cache configuration.
Also, you can set DataRegionConfiguration.persistenceEnabled=false to disable native persistence.

Thanks,
Stan

From: Naveen
Sent: 9 марта 2018 г. 17:09
To: user@ignite.apache.org
Subject: Re: How to configure a cluster as a persistent, replicated SQLdatabase

Hi Jose

I was asking how can I configure Oracle DB as persistent layer.
At the moment I am using the Ignite native persistence as persistent layer,
but I would like to use Oracle DB as persistent layer. 
How can I do this, what changes I should do to the config file.
My config file looks like this for native ignite persistence, what do I need
to add for using Oracle as persistent layer

	  <property name="dataStorageConfiguration">
	    <bean class="org.apache.ignite.configuration.DataStorageConfiguration">
	      <property name="defaultDataRegionConfiguration">
	        <bean
class="org.apache.ignite.configuration.DataRegionConfiguration">
	          <property name="persistenceEnabled" value="true"/>
	        </bean>
	      </property>
	    </bean>
	  </property>

Thanks
Naveen



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