search

apache / ignite

Apache Ignite
https://ignite.apache.org/
Apache License 2.0
4.82k stars 1.9k forks source link

Ignite as a cache for SQL Server database #11622

Closed zuhairamahdi closed 1 week ago

zuhairamahdi commented 1 month ago

Hi all,

is there a way to configure and make apache ignite as a caching layer for SQL Server database. something similar to Redis RDI 'Only available in the enterprise version'.

ptupitsyn commented 1 month ago

Yes, you can use SQL Server JDBC driver and CacheJdbcPojoStore - see RDBMS Integration docs.

zuhairamahdi commented 4 weeks ago

Thanks @ptupitsyn is there any example 'docker-compose' or something similar that can kick start it? I'm not very familiar with Ignite. we are having this issue with some tables in SQL Server with millions of records with 1000s requests per minute making it very slow to only depend on SQL. that's why we want to create a cache where all the read query will be using it. and normal write to SQL that it will be 'somehow' synced to Ignite. I'm currently looking into some CDC solutions like Debezium and such to solve this issue.

ptupitsyn commented 4 weeks ago

There is a full example based on embedded H2 database: https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/datagrid/store/jdbc/CacheJdbcStoreExample.java

Switching to SQL Server should be a matter of replacing the driver and connection string.