RDBMS as backend for Ignite SQL

[Michaelikus <lo...@ya.ru>]

Is it possible to use various RDBMS as persisted backend for Ignite SQL ?



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

RE: RDBMS as backend for Ignite SQL

[Stanislav Lukyanov <st...@gmail.com>]

If you’re asking whether you can use other DBMS as a persistence layer, then yes. 
You can use anything (any DBMS, or any kind of custom storage) as a 3rd party persistence – see https://apacheignite.readme.io/docs/3rd-party-store.

If you’re asking whether you can use multiple DBMS backing the same cache, then probably – you’d have to implement your own CacheStore that would work with multiple DBMS. That might be pretty tricky though.

If you’re asking whether you can use another SQL engine for Ignite SQL, then no – Ignite is backed by embedded H2 engine, and SQL queries to Ignite will always be processed by it.

Thanks,
Stan

From: Michaelikus
Sent: 9 июня 2018 г. 13:15
To: user@ignite.apache.org
Subject: RDBMS as backend for Ignite SQL

Is it possible to use various RDBMS as persisted backend for Ignite SQL ?



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

Re: RDBMS as backend for Ignite SQL

[Andrey Mashenkov <an...@gmail.com>]

Hi,

You can use only one backed store per cache.

I'm not sure, but very likely you will not be able to use cross-cache
transaction for caches backed by different stores.
Anyway, you can try.

On Sat, Jun 9, 2018 at 1:15 PM, Michaelikus <lo...@ya.ru> wrote:

> Is it possible to use various RDBMS as persisted backend for Ignite SQL ?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>



-- 
Best regards,
Andrey V. Mashenkov